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"
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"