Using results with variable

[ddeegan]

Hello

I am trying run a sql statement and place the result into a table.

Below is my attempt to put the result in a variable

I know I'm murdering the syntax - Am I close? Do I have the wrong concept?

declare @SEQ_return as varchar(100)
set @SEQ_return = select field from table -- returns 1 value
insert @SEQ_return into table

Thanks in advance
Dave

 

[SQLDenis]

This should work

declare @SEQ_return as varchar(100)
select @SEQ_return =field from table -- returns 1 value

insert into table
select @SEQ_return

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/