Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2008
    Posts
    20

    Unanswered: problem with creation of derived table.

    hi ,

    i am unable to create a stored procedure, in which having the below derived table creation query..

    select tempkey = identity(6), * into #temptable from (select * from empl where empl_id >1000)

    plzz tell me what is error in the above code..

  2. #2
    Join Date
    May 2008
    Posts
    10

    RE:problem with creation of derived table

    hi,

    see if this works for you ... observe last A, assigned a table name ..

    select tempkey = identity(6), * into #temptable from (select * from empl where empl_id >1000) A

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •