title: Why is this SQL returning two result sets?
body: <p>This test code is representing som code I have in my database, but when I use LinqToSql, it says the stored proc is returning two result sets....</p>
  
  <pre><code>CREATE PROCEDURE [dbo].[Test] 
      @a UNIQUEIDENTIFIER,
      @b UNIQUEIDENTIFIER,
      @c UNIQUEIDENTIFIER
  AS
  BEGIN
      SET NOCOUNT ON;
  
      IF @c IS NULL
      BEGIN
          SELECT        DISTINCT p1, p2
          FROM          dbo.Test
          WHERE         (a=@a) AND 
                        (b=@b) AND 
                        (c IS NULL)       
      END
      ELSE
      BEGIN
          SELECT        DISTINCT p1, p2
          FROM          dbo.Test
          WHERE         (c=@c)
      END        
  END
  GO
  </code></pre>
  
  <p>I thought code like above would only return one result set? Can I force it to return one result set?</p>