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
- 8212 Views
- I also Faced
- E-Mail Answers
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
What are sql server functions?
What is the difference between a "where" clause and a "having" clause?
Explain cursor as data base object?
Is truncate a dml command?
Explain the various types of concurrency problem?
Which are the two editions in which SQL Azure database available?
Explain cdc and sql injection?
How to copy the tables, schema and views from one sql server to another?
Different types of keys in SQL?
Explain about remote stored procedure?
Explain “@@rowcount” and “@@error” in sql server?
What is compound operators?
Write query to return all rows sql?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
How to run sql server 2005 books online on your local system?
