Query problem.
Posted by:
Herman
Date: February 19, 2007 05:08AM
Have a problem. suprise =)
Columns:
Date_start , Date_Stop , User_ID , info
Date_stop is optional ( NULL if not used )
sample database information
2007-01-01 , 2007-01-04 , 102 , infotext
2007-04-09 , NULL , 105 , infotext2
2007-06-04 , 2007-06-06 , 222 , infotext3
i want the Query output look like this.
Column: Date , User_Id , Info
not any start/stop date
one row for each date
2007-01-01 , 102 , infotext
2007-01-02 , 102 , infotext
2007-01-03 , 102 , infotext
2007-01-04 , 102 , infotext
2007-04-09 , 105 , infotext2
2007-06-04 , 222 , infotext3
2007-06-05 , 222 , infotext3
2007-06-06 , 222 , infotext3
is it possible to make a Query/view to fix that? or must i use Stored Procedures?
how shall i do?
regards Herman
Edited 2 time(s). Last edit at 02/19/2007 06:21AM by Herman .