Posted by Erland Sommarskog on 04/09/07 21:59

(plaster1@gmail.com) writes:
> Thanks Ed. Although i'm getting syntax issues with the UNION portion
> of you query. Perhaps that's a version issue as well (i'm using SQL
> server 7.0).

A common recommendation is that you post:

o CREATE TABLE statements for your tables.
o INSERT statements with sample data.
o The desired output given the sample.

This makes it easy to copy and paste to develop a tested solution. Without
that, you get more or less guessworks.

Ed's query should be OK in SQL 7, but 1) I don't know how you adapted it
to your problem 2) what error message you got.




--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Help needed for datediff function for SQL query
• Prev in forum: Re: select distinct record only if certain column not null
• Thread view: Re: select distinct record only if certain column not null

[Reply to this message]