Post reply

Return NULL values as output, if there is no matching records for a select query

  • October 27, 2011 at 10:55 am

    #259261

    I need to return NULL values as output, if there is no matching records for a select query. Any idea on how I can achieve this ?

    Thanx in Advance !

    Sanz

  • October 27, 2011 at 11:03 am

    #1400298

    with no data/examples/require results to work on....

    pure guess...have you tried LEFT OUTER JOINS?

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • October 27, 2011 at 11:04 am

    #1400299

    Sanz,

    You might do a little better by providing more details in your post. Many of the gurus on this site (I'm absolutely not one of them) will not bother to respond to your post, unless you provide clear details about the tables being queried, the data in those tables and your objective in querying. Rightly so, because it can be difficult to help someone when you can't understand their question.

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    http://www.sqlservercentral.com/Forums/Topic604325-61-1.aspx

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply