Click here to Skip to main content
15,905,068 members
Home / Discussions / Database
   

Database

 
Questionif - else statement in sql Pin
begg15-Jun-12 8:36
begg15-Jun-12 8:36 
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 
I have one SQL Table with 2 columns as below

Column1: ProductionDate - DateTime - Not NULL
Column2: Quantity - Int - Not NULL

Now There are 2 Records in Table

1-1-2012, 5
1-3-2012, 7


Output of Result should be as below if i give date range StartDate as 1-1-2012 and EndDate as 1-15-2012

1-1-2012 5
1-2-2012 0
1-3-2012 7
1-4-2012 0
1-5-2012 0
1-6-2012 0
.
.
.
1-15-2012 0

Means Query should return all the dates of given range with Quantity and if no entry in Table then 0 for Quantity.

How to Do it? Please suggest with Query
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 
GeneralRe: how to make a duplicate database with new name in SQL Server 2008 Pin
nvarunkumar19-Jun-12 21:31
nvarunkumar19-Jun-12 21:31 
QuestionIn SQL Server, how to generate table script as a single statement? Pin
dexterama14-Jun-12 3:24
professionaldexterama14-Jun-12 3:24 
AnswerRe: In SQL Server, how to generate table script as a single statement? Pin
PIEBALDconsult14-Jun-12 4:09
mvePIEBALDconsult14-Jun-12 4:09 
GeneralRe: In SQL Server, how to generate table script as a single statement? Pin
dexterama14-Jun-12 5:50
professionaldexterama14-Jun-12 5:50 
AnswerRe: In SQL Server, how to generate table script as a single statement? Pin
Mycroft Holmes15-Jun-12 13:38
professionalMycroft Holmes15-Jun-12 13:38 
Questioni want to do left join that should not return same multiple rows Pin
asifkhan114-Jun-12 1:45
asifkhan114-Jun-12 1:45 
AnswerRe: i want to do left join that should not return same multiple rows Pin
DRKARTHIKRAJ14-Jun-12 2:32
DRKARTHIKRAJ14-Jun-12 2:32 

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.