Re: How can I get all records for both tables with the latest begin date if exists?

On 15 Jun 2006 10:24:08 -0700, TGEAR wrote:

(snip)
Please help

Hi TGEAR,

I just replied to this question in the original thread. Let me know if
anything is stil unclear!

--
Hugo Kornelis, SQL Server MVP
.

Relevant Pages

  • Re: Compare record count in table1 to qty in table2?
    ... Here is a query I'm trying to use and, of course, it does not work: ... INNER JOIN Item_Serial ... Hugo Kornelis, SQL Server MVP ...
    (comp.databases.ms-sqlserver)
  • Re: Compare row data and input data into a new field
    ... >>I have a simple query which I cannot seem to work out and would like some ... > Why store it in the table and recalculate it each time you need it? ... > Hugo Kornelis, SQL Server MVP ...
    (microsoft.public.sqlserver.mseq)
  • Re: SQL2005 collation vs Oracle
    ... Maybe keywords are case sensitive in Oracle?? ... Hugo Kornelis, SQL Server MVP ...
    (comp.databases.ms-sqlserver)
  • Re: sqlexec
    ... How can i execute a piece of sqlstmt which is stored in a string variable ... from query analyser. ... Hugo Kornelis, SQL Server MVP ...
    (microsoft.public.sqlserver.mseq)