I have a sproc that returns a single line and column with a text, I need to set this text to a variable, something like:
declare @bla varchar(100)
select @bla = sp_Name 9999, 99989999, 'A', 'S', null
but of course, this code doesn't work…
thanks!
Best Answer
If you are unable to change the stored procedure, another solution would be to define a temporary table, and insert the results into that