SELECT CASE WHEN pk = 1 THEN col3 END AS newcol1,
CASE WHEN pk = 1 THEN col4 END AS newcol2,
CASE WHEN pk = 2 THEN col1 END AS newcol1,
CASE WHEN pk = 2 THEN col2 END AS newcol2
FROM mytable
-----Original Message-----
From: Patti G. L. Hall [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 10:54 AM
To: CF-Talk
Subject: SQL: Returning columns with null values when specific columns
are unknown at runtime
Is there a way to write a MSSQL 2k query that will return a result set that
contains only columns with null values when you don't know explicitly which
columns those will be?
So if I have this data
pk | col 1 | col 2 | col 3 | col 4|
1 1 2 null null
2 null 4 null null
I'd like a query that would return col 3 and col 4 where pk = 1 or col 1,
col 3 and col 4 where pk=2.
Is this possible?
-Patti
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
