Click here to Skip to main content
15,922,155 members
Home / Discussions / Database
   

Database

 
AnswerRe: Inserting rows dynamiccaly on based on calculation Pin
__TR__3-Jul-12 20:41
__TR__3-Jul-12 20:41 
Questionlan chat software Pin
Member 913183919-Jun-12 1:42
Member 913183919-Jun-12 1:42 
AnswerRe: lan chat software Pin
Richard MacCutchan19-Jun-12 2:01
mveRichard MacCutchan19-Jun-12 2:01 
AnswerRe: lan chat software Pin
Eddy Vluggen19-Jun-12 2:36
professionalEddy Vluggen19-Jun-12 2:36 
AnswerRe: lan chat software Pin
Paul Conrad19-Jun-12 8:19
professionalPaul Conrad19-Jun-12 8:19 
QuestionError 1064,.... please Help Pin
Jassim Rahma16-Jun-12 0:10
Jassim Rahma16-Jun-12 0:10 
AnswerRe: Error 1064,.... please Help Pin
Mycroft Holmes16-Jun-12 3:14
professionalMycroft Holmes16-Jun-12 3:14 
Questionif - else statement in sql Pin
begg15-Jun-12 8:36
begg15-Jun-12 8:36 
Hi,

I have a list to populate. I have a query to populate it in mssql 2008. It involves three tables. If the query returns the value then I populate it and it is done. But , if the query doesnot return anything then I want to run another select statement because I do not want to leave the list view empty. I have to populate at least the names of the client. It could be something simple but I am just beginning to use mssql so I am stuck.



Select C.name as Client ,
B.Detail as Detail from tableA A
left join tableB B on B.bID = A.bID
Left join tableC C on C.clientID = B.clientID
where aID= '100';

if does not return anything,

I want to run another sql to atleast get the name of the client even if there is no related detail with that client.

second sql would be

Select C.name as Client from tableA A

Left join tableC C on C.clientID = A.bID
where aID= '100'

[P.S. the bID field of Table A could actually either be bID as is or C.clientID inserted into bID field of Table C.]


I am confident about the queries but its just about extracting the values from the result.

Thanks,
AnswerRe: if - else statement in sql Pin
Corporal Agarn15-Jun-12 8:41
professionalCorporal Agarn15-Jun-12 8:41 
AnswerRe: if - else statement in sql Pin
Michael Potter15-Jun-12 10:18
Michael Potter15-Jun-12 10:18 
AnswerRe: if - else statement in sql Pin
vvashishta18-Jun-12 19:49
vvashishta18-Jun-12 19:49 
AnswerRe: if - else statement in sql Pin
rimazuc20-Jun-12 5:31
rimazuc20-Jun-12 5:31 
AnswerRe: if - else statement in sql Pin
rimazuc20-Jun-12 5:40
rimazuc20-Jun-12 5:40 
AnswerRe: if - else statement in sql Pin
hearthofmine24-Jun-12 22:33
hearthofmine24-Jun-12 22:33 
QuestionHow can i select all dates between date range? Pin
RA|-|UL PATEL15-Jun-12 3:30
RA|-|UL PATEL15-Jun-12 3:30 
AnswerRe: How can i select all dates between date range? Pin
bobrien10015-Jun-12 8:11
bobrien10015-Jun-12 8:11 
GeneralRe: How can i select all dates between date range? Pin
Corporal Agarn15-Jun-12 8:44
professionalCorporal Agarn15-Jun-12 8:44 
AnswerRe: How can i select all dates between date range? Pin
Mycroft Holmes15-Jun-12 13:44
professionalMycroft Holmes15-Jun-12 13:44 
AnswerRe: How can i select all dates between date range? Pin
Jörgen Andersson15-Jun-12 22:36
professionalJörgen Andersson15-Jun-12 22:36 
AnswerRe: How can i select all dates between date range? Pin
vvashishta18-Jun-12 20:09
vvashishta18-Jun-12 20:09 
Questionhow to make a duplicate database with new name in SQL Server 2008 Pin
nvarunkumar15-Jun-12 0:06
nvarunkumar15-Jun-12 0:06 
AnswerRe: how to make a duplicate database with new name in SQL Server 2008 Pin
Sandeep Mewara15-Jun-12 1:11
mveSandeep Mewara15-Jun-12 1:11 
GeneralRe: how to make a duplicate database with new name in SQL Server 2008 Pin
nvarunkumar15-Jun-12 2:04
nvarunkumar15-Jun-12 2:04 
GeneralRe: how to make a duplicate database with new name in SQL Server 2008 Pin
nvarunkumar18-Jun-12 21:59
nvarunkumar18-Jun-12 21:59 
AnswerRe: how to make a duplicate database with new name in SQL Server 2008 Pin
Paul Conrad19-Jun-12 8:22
professionalPaul Conrad19-Jun-12 8:22 

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.