SELECT INTO

[yogi77]

HI,

I am trying to do something like this within a stored procedure using MS SQL7.0;

SELECT field1, field2, field3 INTO @var1, @var2, @var3 FROM table_name WHERE field1 = @passedinarg

However, without much joy. Is there a way of doing this or do I need to the long winded version;

SET @var1 = (SELECT field1 FROM table_name WHERE field1 = @passedinarg)

SET @var2 = (...etc

TIA,

Yogi
"Let us not condemn ignorance, let us condemn the reluctance to share"

 

[TheInsider]

I think it would look like this:

SELECT @var1 = field1, @var2 = field2, @var3 = field3 FROM table_name WHERE field1 = @passedinarg

 

[yogi77]

Thanks CCTC1, that's exactly what I was trying to do. It's amaing how simple it looks when someone shows you. "Let us not condemn ignorance, let us condemn the reluctance to share"