This gives the expected results, but it may not handle unexpected data such as PayHours being inconsistent for a given employee/date.

SELECT ROW_NUMBER() OVER(ORDER BY m.EmployeeNum, m.LaborDate, GROUPING(m.ID),...

The following code seems simpler and easier to understand to me.

SELECT *
FROM #tsttable AS t
WHERE t.cid NOT IN (100, 111)
OR t.ccode NOT IN ('out', 'outa', 'stt', 'cnty')

Using...

If you knew the items were fixed you could get them back using a PIVOT query:

SELECT *
 FROM #testtbl src
 PIVOT (MAX(Item) FOR Item IN (XX,...

Have you looked at sub-reports?

Drew

Use a tally table.  Here I've used an inline tally table.

INSERT #Child (PID, PName)
SELECT
p.PID
,p.PName
FROM #Parent p
CROSS APPLY (VALUES(1), (2), (3), (4)) t(n)
WHERE p.NoOfChildrenRecs >= t.n

Drew

Also they have to be in two different data sets so it wont just give me the same name again. if you have any ideas where to start that...

Last but certainly not least, there is no way that I'd ever include spaces or other special characters in the columns so as to make them require brackets....

Also, this is just part of the code and when I am running the complete Stored procedure I am getting this particular error:   Msg 207, Level 16, State...

This sounds like homework.  You're better off attempting this yourself.

Drew

A couple of other points.

• Always use a temp table or a table variable when providing sample data.

  • It obviates the need for cleanup.

• Use an international date format instead...

This is the source of your error.  The procedure requires three...

There are so many issues with this code, it's hard to know where to start.  Since you failed to provide the error message, it's even more difficult.

1. You have an...

Agree with @Taps.  LEAD() or LAG() is the best option here.  Those functions were specifically designed to handle these types of queries.

Drew

You would have to write a trigger.

I also notice that...