Loading ...
Sorry, an error occurred while loading the content.

RE: [SQLQueriesNoCode] Return a logical row

Expand Messages
  • Damhuis Anton
    This should work: Select Col1 + | + Col2 + | + Col3 + | + Col4 + | + Col5 + | + Col6 from table1 where .......Otherwise have a look
    Message 1 of 2 , Feb 21, 2005
    • 0 Attachment
      This should work:
      Select Col1 + ' | ' + Col2 + ' | ' + Col3 + ' | ' + Col4 + ' | ' + Col5 + ' | ' + Col6
      from table1
      where .......


      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.

      Regards
      Anton


      -----Original Message-----
      From: Falls, Travis D (HTSC, CASD) [mailto:travis.falls@...]
      Sent: 21 February 2005 10:59
      To: 'SQLQueriesNoCode@yahoogroups.com'
      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.

      Confidentiality Warning
      =======================
      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.
    Your message has been successfully submitted and would be delivered to recipients shortly.