Click here to Skip to main content
15,883,901 members
Home / Discussions / Database
   

Database

 
Questionselect problem Pin
Stephan Hoppe4-Jul-08 12:24
Stephan Hoppe4-Jul-08 12:24 
AnswerRe: select problem Pin
leoinfo4-Jul-08 14:59
leoinfo4-Jul-08 14:59 
GeneralRe: select problem Pin
Stephan Hoppe5-Jul-08 6:13
Stephan Hoppe5-Jul-08 6:13 
QuestionHow to get date only from the table Pin
BalasubramanianK4-Jul-08 3:20
BalasubramanianK4-Jul-08 3:20 
AnswerRe: How to get date only from the table Pin
leoinfo4-Jul-08 3:50
leoinfo4-Jul-08 3:50 
QuestionTrouble joining between 3 tables Pin
dlarkin773-Jul-08 10:14
dlarkin773-Jul-08 10:14 
AnswerRe: Trouble joining between 3 tables Pin
Paul Conrad3-Jul-08 11:15
professionalPaul Conrad3-Jul-08 11:15 
AnswerRe: Trouble joining between 3 tables Pin
Blue_Boy3-Jul-08 22:39
Blue_Boy3-Jul-08 22:39 
First result for accountnumber 1234

SELECT     OD.ProductCode, O.DeliveryDate, CASE WHEN O.DeliveryDate IS NULL THEN NULL ELSE OD.Quantity END AS quantity<br />
FROM         dbo.Products P INNER JOIN<br />
                      dbo.OrderDetails OD ON P.ProductCode = OD.ProductCode LEFT OUTER JOIN<br />
                      dbo.Orders O ON OD.ID = O.ID AND O.AccountNumber = 1234


Second result for accountnumber 6789

<br />
SELECT     OD.ProductCode, O.DeliveryDate, CASE WHEN O.DeliveryDate IS NULL THEN NULL ELSE OD.Quantity END AS quantity<br />
FROM         dbo.Products P INNER JOIN<br />
                      dbo.OrderDetails OD ON P.ProductCode = OD.ProductCode LEFT OUTER JOIN<br />
                      dbo.Orders O ON OD.ID = O.ID AND O.AccountNumber = 6789



I Love T-SQL
"Don't torture yourself,let the life to do it for you."

QuestionRTF in Reporting services reports Pin
AlterD3-Jul-08 9:14
AlterD3-Jul-08 9:14 
QuestionHelp in get Time Pin
Senthil S3-Jul-08 4:08
Senthil S3-Jul-08 4:08 
AnswerRe: Help in get Time Pin
DerekFL3-Jul-08 4:39
DerekFL3-Jul-08 4:39 
AnswerRe: Help in get Time Pin
Blue_Boy3-Jul-08 22:43
Blue_Boy3-Jul-08 22:43 
Questiontrigger instead of identity Pin
Mr.Kode3-Jul-08 1:04
Mr.Kode3-Jul-08 1:04 
AnswerRe: trigger instead of identity Pin
DerekFL3-Jul-08 4:43
DerekFL3-Jul-08 4:43 
AnswerRe: trigger instead of identity Pin
DerekFL3-Jul-08 4:55
DerekFL3-Jul-08 4:55 
AnswerRe: trigger instead of identity Pin
leoinfo4-Jul-08 4:26
leoinfo4-Jul-08 4:26 
Questionbegin tran... commit and stored procedures/functions Pin
blakey4043-Jul-08 0:21
blakey4043-Jul-08 0:21 
AnswerRe: begin tran... commit and stored procedures/functions Pin
DerekFL3-Jul-08 4:52
DerekFL3-Jul-08 4:52 
GeneralRe: begin tran... commit and stored procedures/functions Pin
blakey4043-Jul-08 5:11
blakey4043-Jul-08 5:11 
QuestionUnable to view SQL Report with normal login Pin
Ankur.Bakliwal3-Jul-08 0:09
Ankur.Bakliwal3-Jul-08 0:09 
Questioninstallation Pin
Kissy162-Jul-08 23:50
Kissy162-Jul-08 23:50 
AnswerRe: installation Pin
John_Adams3-Jul-08 5:35
John_Adams3-Jul-08 5:35 
QuestionStored Procedure or Trigger for Autogenerate Colunm Pin
rrrriiizz2-Jul-08 20:45
rrrriiizz2-Jul-08 20:45 
AnswerRe: Stored Procedure or Trigger for Autogenerate Colunm Pin
Mycroft Holmes2-Jul-08 20:56
professionalMycroft Holmes2-Jul-08 20:56 
GeneralRe: Stored Procedure or Trigger for Autogenerate Colunm Pin
rrrriiizz2-Jul-08 21:34
rrrriiizz2-Jul-08 21:34 

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.