hey guys, just a quick question:
declare @set varchar(2000)
set @set = ' DECLARE @employee_id int
SELECT @employee_id = employee_id
FROM ##employee
WHERE code = ''AA'''
SELECT @employee_id '
if you exec this, it gives me a number eg. 65656
how do i now , use this 'output' and assign it to a variable?