Get Value From in Exec - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Get Value From in Exec

Author

Topic

pthsoon
Starting Member

12 Posts

Posted - 2010-05-10 : 00:00:09

I wish to get data after EXEC to put into @R1From_O, @R1To_O, @R2From_O,@R2To_O, @R3From_O, @R3To_O
But is Cannot find how? Can anypeople help me out, please?

USE NBIMS
DECLARE @R1From NVARCHAR(15)
DECLARE @R1To NVARCHAR(15)
DECLARE @R2From NVARCHAR(15)
DECLARE @R2To NVARCHAR(15)
DECLARE @R3From NVARCHAR(15)
DECLARE @R3To NVARCHAR(15)

DECLARE @R1From_O NVARCHAR(15)
DECLARE @R1To_O NVARCHAR(15)
DECLARE @R2From_O NVARCHAR(15)
DECLARE @R2To_O NVARCHAR(15)
DECLARE @R3From_O NVARCHAR(15)
DECLARE @R3To_O NVARCHAR(15)

DECLARE @RSID NVARCHAR(15)
DECLARE @i INT

SET @i=0
WHILE @i<3
BEGIN
SET @i=@i+1
SET @R1From='Rs_C'+ CONVERT(NVARCHAR(2),@i)+ 'R1_FROM'
SET @R1To='Rs_C'+ CONVERT(NVARCHAR(2),@i)+ 'R1_TO'
SET @R2From='Rs_C'+ CONVERT(NVARCHAR(2),@i)+ 'R2_FROM'
SET @R2To='Rs_C'+ CONVERT(NVARCHAR(2),@i)+ 'R2_To'
SET @R3From='Rs_C'+ CONVERT(NVARCHAR(2),@i)+ 'R3_FROM'
SET @R3To='Rs_C'+ CONVERT(NVARCHAR(2),@i)+ 'R3_TO'

--SELECT @R1From,@R1To,@R2From,@R2To,@R3From,@R3To

EXEC('SELECT ' + @R1From + ',' + @R1To + ',' +@R2From + ',' + @R2To + ','
+ @R3From + ',' + @R3To +' FROM REPORT_STRUCT WHERE RS_ID=''' + 'ICT01002' + '''')
END

asgast
Posting Yak Master

149 Posts

Posted - 2010-05-10 : 04:18:31

http://msdn.microsoft.com/en-us/library/ms188001%28SQL.90%29.aspx