Click here to Skip to main content
15,904,500 members
Home / Discussions / Database
   

Database

 
AnswerRe: Microsoft OLE DB Error Pin
originSH28-Sep-07 2:11
originSH28-Sep-07 2:11 
GeneralRe: Microsoft OLE DB Error Pin
paresh_joe28-Sep-07 2:40
paresh_joe28-Sep-07 2:40 
GeneralRe: Microsoft OLE DB Error Pin
pmarfleet28-Sep-07 2:46
pmarfleet28-Sep-07 2:46 
QuestionDatabase status during Database Refresh operation - Help required Pin
sarayumadhavan28-Sep-07 1:20
sarayumadhavan28-Sep-07 1:20 
AnswerRe: Database status during Database Refresh operation - Help required Pin
Paul Conrad2-Oct-07 10:23
professionalPaul Conrad2-Oct-07 10:23 
QuestionSQL Query Pin
Ashish_Sood28-Sep-07 0:55
Ashish_Sood28-Sep-07 0:55 
AnswerRe: SQL Query Pin
andyharman28-Sep-07 1:57
professionalandyharman28-Sep-07 1:57 
AnswerRe: SQL Query Pin
sarayumadhavan28-Sep-07 2:03
sarayumadhavan28-Sep-07 2:03 
Hi Ashish,

Use the below code,

create table temp#
(
assessmentid int,
appid int
)
insert into temp# select name,rank from table where rank <> 0 order by rank asc
insert into temp# select name,rank from table where rank = 0 order by name asc
select * from temp#

This will give you the output.



Regards,
Sarayu
QuestionSQL Express Installation Problem While Deploy .NET Poject Pin
ahsansharjeel27-Sep-07 21:55
ahsansharjeel27-Sep-07 21:55 
AnswerRe: SQL Express Installation Problem While Deploy .NET Poject Pin
Farhan Noor Qureshi28-Sep-07 9:53
Farhan Noor Qureshi28-Sep-07 9:53 
GeneralRe: SQL Express Installation Problem While Deploy .NET Poject Pin
ahsansharjeel28-Sep-07 17:31
ahsansharjeel28-Sep-07 17:31 
QuestionHow can I recover the Database.? Pin
pubududilena27-Sep-07 21:37
pubududilena27-Sep-07 21:37 
AnswerRe: How can I recover the Database.? Pin
pmarfleet27-Sep-07 21:59
pmarfleet27-Sep-07 21:59 
QuestionMySQL to MsSQL Converter Pin
totocaster27-Sep-07 21:24
totocaster27-Sep-07 21:24 
AnswerRe: MySQL to MsSQL Converter Pin
originSH28-Sep-07 2:15
originSH28-Sep-07 2:15 
AnswerRe: MSQL Programmer Needed Pin
Colin Angus Mackay27-Sep-07 18:48
Colin Angus Mackay27-Sep-07 18:48 
QuestionDATE COMPARISON In JET SQL QUERY Pin
Nadia Monalisa27-Sep-07 12:08
Nadia Monalisa27-Sep-07 12:08 
QuestionCalling a web service from SQL [modified] Pin
DerekFL27-Sep-07 7:24
DerekFL27-Sep-07 7:24 
QuestionHow to set ExitCode for SQL Job Pin
alex.almeida27-Sep-07 6:04
alex.almeida27-Sep-07 6:04 
AnswerRe: How to set ExitCode for SQL Job Pin
DerekFL27-Sep-07 8:41
DerekFL27-Sep-07 8:41 
Questiondatabase select query probem Pin
Nishad8527-Sep-07 4:49
Nishad8527-Sep-07 4:49 
AnswerRe: database select query probem Pin
andyharman27-Sep-07 7:00
professionalandyharman27-Sep-07 7:00 
QuestionHow to connect two database in an single application Pin
Exelioindia27-Sep-07 3:13
Exelioindia27-Sep-07 3:13 
AnswerRe: How to connect two database in an single application Pin
Pete O'Hanlon27-Sep-07 3:35
mvePete O'Hanlon27-Sep-07 3:35 
GeneralRe: How to connect two database in an single application Pin
Exelioindia27-Sep-07 4:23
Exelioindia27-Sep-07 4:23 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.