Skip to content
«
»
 

How to Compare Stored Procedure Result Sets

Posted by 
on  December 9 2009

You are currently browsing comments. If you would like to return to the full story, you can read the full entry here: “How to Compare Stored Procedure Result Sets”.

Filed under SQL
Comment (RSS)  |  Trackback  |  Permalink

3 Comments

  1. Mike says:
    May 9, 2011 at 8:25 am

    The last line of TSQL above when looking for result sets matches
    AND ds.ChkSum ps.ChkSum
    should be
    AND ds.ChkSum = ps.ChkSum

    Reply to this comment
  2. Ashwin says:
    March 30, 2011 at 3:49 am

    hi

    how do i pass date value in openquery?

    Reply to this comment
  3. Ashwin says:
    March 30, 2011 at 2:35 am

    how do i give two values in single parameter?

    for Example:
    single value

    SELECT *
    INTO #Procedure1
    FROM OPENQUERY(LOCALSERVER, ‘set fmtonly off exec dbo.Procedure1 1,hr’)

    more than on value
    SELECT *
    INTO #Procedure1
    FROM OPENQUERY(LOCALSERVER, ‘set fmtonly off exec dbo.Procedure1 ’1,24′,hr’)

    here single quotes not allowed in parameters

    Reply to this comment

post a comment OR Post Your Question on our ASK! Community!

«
»