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

    Question Unanswered: sql 2005 stored procedures

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

    =if(and(b1=b2,d1=d2),TRUE,FALSE)

    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
    Location
    One Flump in One Place
    Posts
    14,912
    Code:
    .....
    COALESCE(CASE WHEN b1=b2 AND d1=d2 THEN 1 END, 0)
    ....
    Testimonial:
    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
  •