Thanks a lot sir

It is working for me...

Got the solution Guys.

I have done from the SQL Server Management Studio

To enable a foreign key constraint for INSERT and UPDATE statements

1. In Object...

1st table is temp table (10X10)

2nd table is Table2 with 5 columns

i need to insert the cell values of 1st table (i.e 100 cells) into 100 rows in 2nd Table....

in the new table i should insert 100 records

new table has 5 columns

i have the hardcoded values of 1st 4 columns

and the 5th column value should be cell(1,1) of temp...

I need to select values of each cell from temp table and insert them into other table in a single column one by one

Thanks for your help

I have solved the problem.

I have assigned your case values to new column and i have sorted using the new column.

Thanks

select tid,t.Num from dbo.Table1 t

order by t.tId, CASE

WHEN t.Num = 1 THEN 10

WHEN t.Num = 2 THEN 20

...

Hi i am using distict in the select statement and i am getting the following error if i use case statement

ORDER BY items must appear in the select list...