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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-15 : 08:12:26
|
mala writes "Hi,
As per your instruction I used sp_executesql.
The code is as beow:
DECLARE @SQLString NVARCHAR(1000)
declare @sqlstring1 nvarchar(1000)
declare @str nvarchar(10)
declare @clmn nvarchar(10)
declare @d nvarchar(1)
declare @m nvarchar(10)
declare @l nvarchar(10)
declare @u nvarchar(10)
set @l='1'
set @u = '2'
set @d = '1'
set @str = 'abc'
set @clmn = 'ord_ref'
set @clmn = @clmn+@d
SET @SQLString = N'if exists(select'+char(10)
seT @SQLString =@sqlstring+ @clmn+char(10)
SET @SQLString = @SQLString + N'FROM t_ord_header where'+ char(10)
SET @SQLString = @SQLString + @clmn + '='+ '"'+ @Str+ '")'+ char(10)
set @sqlstring = @sqlstring + 'begin' +char(10)
set @sqlstring = @sqlstring + 'select '+ '"'+@l+ '"'+char(10)
set @sqlstring = @sqlstring + 'end' +char(10)
set @sqlstring = @sqlstring + 'else select '+ '"'+@u+'"'
EXEC sp_executesql @SQLString
Here eveything works. But I am unable to store the value to @m
i.e. If I try to assign value to @m it doesn't work.
[eg. set @sqlstring = @sqlstring + 'else select '+ @m+ '='+ '"' +@u+'"']
After trying all the combination I am writing again for your help.
Please let me know how do I store result value to @m.
Eagerly waiting for early reply.
Bye,
Mala" |
|
|
|
|
|
Query