Please help I want to concatenate the results from
three recordsets returned from one procedure
the procedure is simply
ALTER PROCEDURE [dbo].[usp_keywordSearch]
(
@keywords varchar(2000)
)
AS
Begin
DECLARE @CRC int
-- Set parameter values
EXEC @CRC = [dbtophorse].[dbo].[usp_keywordSearchComment] @keywords
DECLARE @ARC int
-- Set parameter values
EXEC @ARC = [dbtophorse].[dbo].[usp_keywordSearchLineageAllAncestry] @keywords
DECLARE @SRC int
-- Set parameter values
EXEC @SRC = [dbtophorse].[dbo].[usp_keywordSearchSynopsis] @keywords
How can I concatenate the three recordsets this returns?
three recordsets returned from one procedure
the procedure is simply
ALTER PROCEDURE [dbo].[usp_keywordSearch]
(
@keywords varchar(2000)
)
AS
Begin
DECLARE @CRC int
-- Set parameter values
EXEC @CRC = [dbtophorse].[dbo].[usp_keywordSearchComment] @keywords
DECLARE @ARC int
-- Set parameter values
EXEC @ARC = [dbtophorse].[dbo].[usp_keywordSearchLineageAllAncestry] @keywords
DECLARE @SRC int
-- Set parameter values
EXEC @SRC = [dbtophorse].[dbo].[usp_keywordSearchSynopsis] @keywords
How can I concatenate the three recordsets this returns?