Viewing 4 posts - 1 through 4 (of 4 total)
Thanks to everyone who responded to my question.
With the various replies I was able to obtain what I required.
rg
March 31, 2010 at 7:04 am
K Cline (3/29/2010)
Uses the assistance of a tally table to create the repeater effect.
Hi,
Thank you for this. What sort of structure would the 'Tally' table have?
rg
March 30, 2010 at 4:57 am
Bhuvnesh (3/29/2010)
Can you post required columns for staffno for 1234 so that i can get rough idea/hint ?
Hi Bhuvnesh,
The result set would look like
StaffNo Name StartDate ...
March 29, 2010 at 6:07 am
Hi al,
Below is ddl for above example table.
Thanks,
rg
WITH tempsalary AS
(
SELECT 1234 [StaffNo], 'Tom' [Name], '01/04/1982' [StartDate], '01/06/1992' [EndDate], 20000 [Salary] UNION ALL
SELECT 1234 [StaffNo], 'Tom' [Name], '02/06/1992' [StartDate], '02/06/1998' [EndDate],...
March 29, 2010 at 4:40 am
Viewing 4 posts - 1 through 4 (of 4 total)