Thank You!:-)

Which CTE, MyCTE?

Yes, but I have to go to my DBA to make these kind of changes and it is not easy with our DBA. With CTE, I can do it myself.

Thanks Sean. It is just what is required.

One more request:

I am new to CTE.

Do you have a CTE that will delete all the children when the parent is deleted automatically?...

Yes, the objective is to delete orphan records but in the example UnitID 1's record should not be deleted as their heirarchy is correct. You could have unit...

Thanks! I will check it out.:-)

Sorry, the select in the middle of code should be replaced by DELETE as follows:

--===== If the test table already exists, drop it

IF OBJECT_ID('TempDB..#tblUnit','U') IS...

Thanks!

This does not work the way I want to.

Also, I have an additional issue to consider and that is: All ParentIDs begin at 0 so they will not have...

This is the script to create records in table:

--===== If the test table already exists, drop it

IF OBJECT_ID('TempDB..#tblUnit','U') IS NOT NULL

...

Sorry. I was just trying to show the relationship between records. Can you give an example of recursive cte to do this?

Thanks! I will try it out.

Thanks but it does not do what I want to do. The query shows null End_Date and null EndDates. As I am only trying to capture records that changed (End_date...

Thank You!:-)

Thanks:-)

Thanks.

I already have a date in a different column and I trying to calculate the number of minutes worked by an employee on a given date. I have...