Hi,

i have this data in the staging table called Stage1. C1,C2 and C3 are column Headers.

C1 C2 C3
41 te cc
51 te cc
42 te cc
41 te cc
51 te cc
42 te cc
41 te cc
51 te cc
42 te cc

 Now from this staging table i want to insert into another temp table in the same order but i want to insert row42 after row41. ex: 41,42,51 and again 41,42,51 and so on. If this is the case how do i query to insert into another table.

can you guys help me with the query? appreciate your help

Thx

This is the same question you asked on the other forum... the ONLY way you can come close is to put a clustered index on the target table. And, I'll say it again, RDBMS's don't store data in the order that you want. The ONLY way to guarantee correct display order is with an ORDER BY. The ONLY way to guarantee correct logical calculation order is with a clustered index and an index hint.

At least try my suggestion...

dont think it makes sense

by sorting you would get
41
41
41
42
42
42
52
52
52 etc.

what youre asking for requires different values in the te cc data or an extra col.
so that really the sort order is new_field, c1

then youd get

41 newfield a te cc

42 newfield a te cc
52 newfield a te cc
41 newfield b te cc
42 newfield b te cc
52 newfield b
41 newfield c
42 newfield c
52 newfield c
etc
you dont really need to see the new field but it must exist really for you to know theyre in the right order.

hope that helps