Click here to Skip to main content
16,006,605 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralJPEG loading ! Pin
Hadi Rezaee12-May-02 4:33
Hadi Rezaee12-May-02 4:33 
GeneralRe: JPEG loading ! Pin
Mazdak12-May-02 5:19
Mazdak12-May-02 5:19 
GeneralMicrosoft Forms Image 2.0 question ! Pin
Hadi Rezaee12-May-02 4:31
Hadi Rezaee12-May-02 4:31 
QuestionProxy Source code? Pin
chaolong12-May-02 3:25
chaolong12-May-02 3:25 
AnswerRe: Proxy Source code? Pin
chaolong12-May-02 16:36
chaolong12-May-02 16:36 
GeneralDisable Menu Items Pin
Michi77712-May-02 2:31
Michi77712-May-02 2:31 
GeneralRe: Disable Menu Items Pin
Matt Gullett12-May-02 2:49
Matt Gullett12-May-02 2:49 
QuestionDB2/SQL question ? Pin
Learning12-May-02 2:16
Learning12-May-02 2:16 
This might be wrong board for this question but was just trying my luck to see whether anyone here had a suggestion..

I have a situation which I am trying to solve just by creating SQL's without programming because of some installation requirements. I did not have any luck with it. Was wondering whether anyone knows of a solution :
Here is the situation-

DB2 Table 1:
------------

FirstName LastName DateOfBirth History Begin Date
--------- -------- ----------- -----------
Joe Smith 01/01/95 05/25/1997
Joe Smith 01/01/95 11/01/1997

Bob Smith 05/07/55 10/01/1998

Sherri Gaston 11/11/73 11/15/1999
Sherri Gaston 11/11/73 12/20/1999
Sherri Gaston 11/11/73 05/05/2000

Primary Key in the above table is FirstName, LastName, DateOfBirth.
From the above table I am trying to create a "daily" level table which will have a record for every primary key starting from the first history Begin Date record date to the next history Begin date.
So for example the result for "Joe Smith" will be

Joe Smith 01/01/95 05/25/1997
Joe Smith 05/26/1997
Joe Smith 05/26/1997
Joe Smith 05/26/1997
Joe Smith 05/26/1997
.........until 11/01/1997 (his last record's history begin date).
I don't mind building intermediate temporary tables. Can anyone help or thing of something?
Thank you
M
AnswerRe: DB2/SQL question ? Pin
Matt Gullett12-May-02 2:37
Matt Gullett12-May-02 2:37 
GeneralRe: DB2/SQL question ? Pin
Learning12-May-02 6:30
Learning12-May-02 6:30 
GeneralVC.NET together with VC ++ 6.0 Pin
Eugene Pustovoyt12-May-02 1:54
Eugene Pustovoyt12-May-02 1:54 
GeneralRe: VC.NET together with VC ++ 6.0 Pin
Mazdak12-May-02 5:06
Mazdak12-May-02 5:06 
GeneralRe: VC.NET together with VC ++ 6.0 Pin
Eugene Pustovoyt12-May-02 18:33
Eugene Pustovoyt12-May-02 18:33 
GeneralRe: VC.NET together with VC ++ 6.0 Pin
Michael P Butler12-May-02 6:40
Michael P Butler12-May-02 6:40 
GeneralRe: VC.NET together with VC ++ 6.0 Pin
Eugene Pustovoyt12-May-02 18:37
Eugene Pustovoyt12-May-02 18:37 
GeneralKeyboard binds Pin
Todd Smith11-May-02 18:26
Todd Smith11-May-02 18:26 
GeneralRe: Keyboard binds Pin
Tom Archer11-May-02 19:04
Tom Archer11-May-02 19:04 
GeneralRe: Keyboard binds Pin
Rama Krishna Vavilala12-May-02 3:48
Rama Krishna Vavilala12-May-02 3:48 
GeneralRe: Keyboard binds Pin
Tom Archer12-May-02 4:40
Tom Archer12-May-02 4:40 
GeneralWriting CFileDialog pathname to disk Pin
In_Way_Too_Deep11-May-02 17:19
In_Way_Too_Deep11-May-02 17:19 
GeneralRe: Writing CFileDialog pathname to disk Pin
Christian Graus11-May-02 18:21
protectorChristian Graus11-May-02 18:21 
GeneralRe: Writing CFileDialog pathname to disk Pin
Nish Nishant11-May-02 19:02
sitebuilderNish Nishant11-May-02 19:02 
GeneralRe: Writing CFileDialog pathname to disk Pin
Christian Graus11-May-02 20:52
protectorChristian Graus11-May-02 20:52 
GeneralRe: Writing CFileDialog pathname to disk Pin
Nish Nishant11-May-02 21:04
sitebuilderNish Nishant11-May-02 21:04 
GeneralRe: Writing CFileDialog pathname to disk Pin
Tom Archer12-May-02 4:44
Tom Archer12-May-02 4:44 

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.