Wow! A great help. I beleive I can do what I need with this. Just need to join some row/column groupings of the current and previous month's data with the...

Both April and March show work-dates (omitting Week-ends) M-F Dates only are shown.

Lynn, I don't see what you mean??

I appreciate your patience. I'm trying to do too much at once. I had given you March and February. Here is April and March.

SELECT '0' AS currentDATE,'0' AS currentWORKDAY,'1' AS...

Not sure what you're asking. I do add two necessary rows at the top as place holders when there are not 31 days in a month and therefore only 18...

Sorry about that.. This is how the output should be. Thank you.

SELECT '0' AS currentDATE,'0' AS currentWORKDAY,'0' AS PrevDate, '0' AS PreWORKDAY,'22' AS GroupNo UNION ALL

SELECT '1','Th','0','0','21' UNION ALL

SELECT '2','F','1','W','20'...

Thanks Gail, I got the correct join in my copy and understand the LOJ for the + in PL/SQL. Just forgot to take it out of this copy. I beleive...

Jared, Thanks. The + just concatenates the character values, PL/SQL uses || so I get the things like that. I'm currently getting :

Msg 156, Level 15, State 1, Line 140

Incorrect...

If you're able, avoid the dynamic sql .... try something like this in your where clause.

WHERE ...

...

AND CASEWHEN NOT(@FirstName) IS NULL

AND e.FirstName LIKE @Firstname THEN 1

END=1

ANDCASEWHEN NOT(@Surname) IS...

I apologize for the post. It's very easy to accidently post the topic before you actually want to when editing.

Anyway, I'm looking for help in determining the missing hours in...