Click here to Skip to main content
14,367,300 members
   

Database

 
AnswerRe: Clarification on SQL Server Function? Pin
uspatel13-Mar-13 3:00
professionaluspatel13-Mar-13 3:00 
QuestionArithmetic overflow error converting expression to data type nvarchar. Pin
Vimalsoft(Pty) Ltd12-Mar-13 11:19
professionalVimalsoft(Pty) Ltd12-Mar-13 11:19 
AnswerRe: Arithmetic overflow error converting expression to data type nvarchar. Pin
Mycroft Holmes12-Mar-13 13:35
memberMycroft Holmes12-Mar-13 13:35 
AnswerRe: Arithmetic overflow error converting expression to data type nvarchar. Pin
Richard Deeming13-Mar-13 3:18
mveRichard Deeming13-Mar-13 3:18 
Questionput a condition in join query Pin
demoninside912-Mar-13 2:38
memberdemoninside912-Mar-13 2:38 
AnswerRe: put a condition in join query Pin
Jörgen Andersson12-Mar-13 3:19
protectorJörgen Andersson12-Mar-13 3:19 
GeneralRe: put a condition in join query Pin
demoninside912-Mar-13 19:47
memberdemoninside912-Mar-13 19:47 
GeneralRe: put a condition in join query Pin
Mycroft Holmes12-Mar-13 21:40
memberMycroft Holmes12-Mar-13 21:40 
Did you actually try what Jorgen wrote, the isnull test does exactly what you are asking for:

select ISNULL(LogBook, Vehcile_Booking) from ..
.

Will test logbook and return a non null result, if it is null then it will return vehicle_booking.
Never underestimate the power of human stupidity
RAH

GeneralRe: put a condition in join query Pin
demoninside912-Mar-13 21:49
memberdemoninside912-Mar-13 21:49 
GeneralRe: put a condition in join query Pin
Mycroft Holmes12-Mar-13 23:23
memberMycroft Holmes12-Mar-13 23:23 
GeneralRe: put a condition in join query Pin
demoninside912-Mar-13 23:39
memberdemoninside912-Mar-13 23:39 
QuestionHow to Recover the Data if the Delete Query is Fire?? Pin
Anubhava Dimri11-Mar-13 23:11
memberAnubhava Dimri11-Mar-13 23:11 
AnswerRe: How to Recover the Data if the Delete Query is Fire?? Pin
Mycroft Holmes11-Mar-13 23:40
memberMycroft Holmes11-Mar-13 23:40 
GeneralRe: How to Recover the Data if the Delete Query is Fire?? Pin
Anubhava Dimri12-Mar-13 0:44
memberAnubhava Dimri12-Mar-13 0:44 
Questiondatabase design for a self food ordering system? Pin
suryakanthithommy11-Mar-13 7:40
membersuryakanthithommy11-Mar-13 7:40 
AnswerRe: database design for a self food ordering system? Pin
Sandeep Mewara11-Mar-13 8:04
mentorSandeep Mewara11-Mar-13 8:04 
Questionwhy i am unable to retrieve holiday name Pin
Member 870181310-Mar-13 23:35
memberMember 870181310-Mar-13 23:35 
AnswerRe: why i am unable to retrieve holiday name Pin
Mycroft Holmes11-Mar-13 0:20
memberMycroft Holmes11-Mar-13 0:20 
GeneralRe: why i am unable to retrieve holiday name Pin
Member 870181311-Mar-13 5:31
memberMember 870181311-Mar-13 5:31 
QuestionBCP - Exported files (docx, xlsx & pptx) are corrupted Pin
ragasai10-Mar-13 17:52
memberragasai10-Mar-13 17:52 
QuestionDatabase design for E commerce web site Pin
subbaraogaddam8-Mar-13 20:44
membersubbaraogaddam8-Mar-13 20:44 
AnswerRe: Database design for E commerce web site Pin
gvprabu8-Mar-13 21:04
membergvprabu8-Mar-13 21:04 
GeneralRe: Database design for E commerce web site Pin
subbaraogaddam8-Mar-13 21:21
membersubbaraogaddam8-Mar-13 21:21 
GeneralRe: Database design for E commerce web site Pin
gvprabu8-Mar-13 21:31
membergvprabu8-Mar-13 21:31 
GeneralRe: Database design for E commerce web site Pin
subbaraogaddam8-Mar-13 21:40
membersubbaraogaddam8-Mar-13 21:40 

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.