Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8 Answers
- 8215 Views
- I also Faced
- E-Mail Answers
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
Find columns used in stored procedure?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
Explain database normalization?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
How to use “drop” keyword in sql server and give an example?
How to create database with physical files specified in ms sql server?
How to create a user name in a database?
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
Explain about builtinadministrator?
How do I install only the client tools of sql server 2000?
What is index in an assignment?
Explain the microsoft sql server delete command? : SQL Server Architecture
How to get the definition of a view out of the sql server?
What command do we use to rename a database?
