Stored Proc, how to select into multiple variables?

Question

My Stored Proc is not behaving how I would expect. I am expecting to populate multiple variables from 1 select statement.

Like this:

Declare @Phone nvarchar(30); 
Declare @Fax nvarchar(30); 

select @Phone = phone , @Fax = fax from customer where customerID = 1;

However, the variables are always blank after this select. I am sure the result set is scalar, and data actually exists.

Where is the obvious blunder, and thanks!

Are you sure that select * from customer where customerID = 1 returns any values? — Chris Van Opstal
– Chris Van Opstal, Commented Mar 1, 2011 at 16:08

Tom Morgan · Accepted Answer · 2011-03-01 16:08:47Z

7

That should work, I think (I'm sure someone will correct me!).

You're absolutly sure the data exists?

and if you add a

print @Phone
print @Fax

immediatly after, they're both blank?

answered Mar 1, 2011 at 16:08

Tom Morgan

2,35519 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

JL. Over a year ago

I'll recheck again, just to be 200% sure.

JL. Over a year ago

You're right, data was the concern. Obviously the example I posted above was a simplification of the real thing, but I had an issue with the where clause. Thanks again!

Collectives™ on Stack Overflow

Stored Proc, how to select into multiple variables?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related