I had a similar problem with a project I was working on. I opted to use an additional table to join against that defined the day schedules for a week....

Can you be a little more specific? For example, will you have more than one level of parent/child hierarchy? Is this simply to populate a list box or drop down...

Here is a very simple way to achieve what you are looking for.

SELECT TOP 1 empid,empWage

FROM

(

SELECT TOP 4 empid,empWage

FROM Empdetails

ORDER BY empid DESC

) a

ORDER BY a.empid ASC

I am wondering why you are putting a transaction inside a transaction. Although this is not unheard of and certainly useful at times, if you attempt to rollback the outside...