Assign values to multiple variables from one select statement MS SQL

Question

The code below works. Can this be improved?

declare @rlcstallname varchar(50), @rlcsalesdept varchar(50), @rlcpath varchar(50)

set @rlcstallname   = (select stallname from sometable)
set @rlcsalesdept   = (select salesdept from sometable)
set @rlcpath        = (select [path] from sometable)

I need to know how to get the three values I store into the variables using only one select statement; I find executing 3 select statements excessive.

Thanks

possible duplicate of SQL Server SELECT INTO @variable?

Will
– Will

2014-10-29 22:48:32 +00:00
Commented Oct 29, 2014 at 22:48 — Will
– Will, Commented Oct 29, 2014 at 22:48

Felix Pamittan · Accepted Answer · 2014-10-29 23:19:17Z

10

SELECT
    @rlcstallname = stallname,
    @rlcsalesdept = salesdept,
    @rlcpath = [path]
FROM sometable

answered Oct 29, 2014 at 23:19

Felix Pamittan

31.9k7 gold badges43 silver badges71 bronze badges

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

1 Comment

Ronan Masangcay Over a year ago

Thank you for this specific answer, wewesthemenace

Collectives™ on Stack Overflow

Assign values to multiple variables from one select statement MS SQL

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related