how live temp table in sql server for send records step by step ?

• tnt750

  Old Hand

  Points: 349

  More actions

  January 26, 2012 at 3:58 am

  #267210

  i want send one record in each step and insert to temp table

  then complete all record move to temp table insert from temp table to master table

  help me?

  parden me

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  January 26, 2012 at 4:30 am

  #1438680

  Vague question. Language issue I suppose.

  I'm sorry, I guess all you can get is a vague answer:

  CREATE TABLE #tempTable (

  id int NOT NULL identity(1,1),

  num int NOT NULL

  )

  INSERT INTO #tempTable (num) VALUES(1)

  --do something else

  INSERT INTO #tempTable (num) VALUES(2)

  --do something else

  INSERT INTO #tempTable (num) VALUES(3)

  INSERT INTO masterTable

  SELECT *

  FROM #tempTable

  Does this help?

  Can you describe your problem in more detail?

  -- Gianluca Sartori

• tnt750

  Old Hand

  Points: 349

  More actions

  January 26, 2012 at 4:51 am

  #1438688

  thank you

  i must send 500 record to server then

  insert into master table

  i do not insert my records directly to master table

  first insert to string gride in my application then must move to server then inserted