• Not sure what you are asking

    You can run the following in a query window in management studio and get the output - but will be left with the table in a database

    CREATE TABLE department

    (

    dept_no CHAR(4) NOT NULL,

    dept_name CHAR(25) NOT NULL,

    location CHAR(30) NULL

    )

    go

    insert into department values ('d1', 'developer', 'Dallas')

    insert into department values ('d2', 'tester', 'Seattle')

    insert into department values ('d3', 'marketing', 'Dallas')

    select * from department

    What you have there looks like it was the output from something like osql


    Cursors never.
    DTS - only when needed and never to control.