i am running a large query that produces a recordset. what i want to do is put those records into a table but i don't know the syntax to do it
this is what i have so far
this is what i have so far
Code:
declare
@identifier as varchar(50),
@Occurrances as numeric,
@Status as int,
@Notes as varchar(30),
@Type as varchar(10),
@DTLMR as datetime
declare x cursor for
"SQL STATEMENT"-- contains the query
open x
fetch next from x into @identifier, @Occurrances, @Status , @Notes, @Type, @DTLMR