davidlars99
asked on
select [value] into [variable] from [table]
hi,
how is it possible to achieve something like this?
select min(RowId) into @minRowId from @t1
where @t1 is the table variable and @minRowId is the INT variable
how is it possible to achieve something like this?
select min(RowId) into @minRowId from @t1
where @t1 is the table variable and @minRowId is the INT variable
select @minRowId = min(RowId) from @t1
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I did and it didn't work. I'll try again when I get home.
Thanks!
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Forgot to add: Here's a link to MSDN example that explains Mr_Peerapol's response.
No points for me.
No points for me.