i have a table #temp1(id, Name groupname ) and record
like this 1 R1 S
2 R3 S
3 R2 S
4 R4 D
5 R5 D
6 R6 K
7 R7 K
8 R8 L
9 R9 L
10 R10 L
11 R11 K

and i want to display record based on user defind sorting
order e.g.
1 R4 D
2 R5 D
3 R6 K
4 R7 K
5 R11 K
6 R1 S
7 R3 S
8 R2 S
9 R8 L
10 R9 L
11 R10 L

Answer Posted / pradip jain

Hi Ram, what new you are done man?
you have posted same answer as me.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you improve the performance of a SQL Azure Database?

115


Why would you use sql agent?

723


What is bcp? When does it use?

505


Explain the use of keyword with encryption. Create a store procedure with encryption?

529


Can we return Data from 4(more than 1) tables in stored procedure?

605






How to return the second 5 rows in ms sql server?

622


What is user defined datatypes and when you should go for them?

571


What is difference between joins and subqueries?

527


When you should use a low fill factor?

510


What is the maximum number of index per table?

556


What is triggers in ms sql server?

632


What are the hotfixes and patches in sql server?

539


Can you always create a cache of a report?

115


What is the stuff?

519


What is linked report?

87