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 / praveen kumar
this is not right query beacuse if table contain 1000
record then you need to give 1000 condition .so it is not
right answer
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to use column default values in insert statements in ms sql server?
How you can minimize the deadlock situation?
Determine when an index is appropriate?
What is difference between view and materialized view?
How to rename databases in ms sql server?
How you can change the database name in SQL SERVER?
Is sql server is free?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What are the advantages to use stored procedures?
What are the recovery models in sql server 2000?
What is sql server programming?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Define Business Edition in SQL Azure?
How to connect sql server management studio express to sql server 2005 express?
Define candidate key, alternate key, and composite key.