Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009

    Question Unanswered: sql 2005 stored procedures

    I used to run an excel query that would bring back results. I could then use the following


    and then copy this for every cell so that I could find any TRUE results.
    I have now changed the query into a stored procedure to capture the data into my database but I am not to sure how to do the compare.

    Can someone help me please?

  2. #2
    Join Date
    Feb 2004
    One Flump in One Place
    COALESCE(CASE WHEN b1=b2 AND d1=d2 THEN 1 END, 0)
    pootle flump
    ur codings are working excelent.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts