select into a variable

[iamtechuser]

Hi

I need to select into a variable:

insert into #tmp EXEC @result = master..xp_cmdshell @cmd

IF (@result <> 0) -- return value from xp_cmdshell, 0 = success, 1 = failure
  BEGIN
	SELECT @output = result FROM #tmp

But @output is empty... but #tmp is not.

Help, how can I capture row data from #tmp into a variable?

Thanks

 

[Glasgow]

Are you sure @output is empty? Have you tried adding :

SELECT @output

 

[SQLSister]

Please don't post the same problem twice. It won't get you an answer any faster.

"NOTHING is more important in a database than integrity." ESquared