RE: [SQLQueriesNoCode] Return a logical row
- This should work:
Select Col1 + ' | ' + Col2 + ' | ' + Col3 + ' | ' + Col4 + ' | ' + Col5 + ' | ' + Col6
Otherwise have a look at COALESCE and a variable.
I don't have the sample with me right now, if the above example does not work in your case I will look it up for you.
From: Falls, Travis D (HTSC, CASD) [mailto:travis.falls@...]
Sent: 21 February 2005 10:59
Subject: [SQLQueriesNoCode] Return a logical row
I have three tables in my database: DirectoryInformation, DomainProfile, and REF_FileWatcherApplicationDomain. I store paths in the DirectoryInformation table. My issue is the REF_ FileWatcherApplicationDomain has a localID and a remoteID which corispond to directory data in the DirectoryInformation table. I want to return a single row of data with both of these fields.
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
The contents of this e-mail and any accompanying documentation
are confidential and any use thereof, in what ever form, by anyone
other than the addressee is strictly prohibited.