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
- 7994 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
How to create new tables with "select ... Into" statements in ms sql server?
What are the benefits and tasks of object explorer? : sql server management studio
What are trace files?
What do you mean by collation recursive stored procedure?
What are the options which must be set to allow the usage of optimistic models?
Mention what are the core components of ssrs?
How to write a query with an inner join in ms sql server?
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
Explain collation?
How to download and install sql server 2005 books online?
What types of Joins are possible with Sql Server?
Explain the flow of creating a cube? : sql server analysis services, ssas
How to move database physical files in ms sql server?
Can you please differentiate between a primary key and a unique key?
Can we use custom code in ssrs?
