I have found reference to http://sqljunkies.com/WebLog/ktegels/archive/2005/05/11/14179.aspx in SQL server daily newsletters but I do not want the output for xml as example shows. I want result set ordered by hierachy...

The point is I want the order of the result set to be the order of employees in the hierachy if employee A is managed by employee B, Employee B is...

Actually they are complex stored procedures. The procedures are used to calculate salaries in a payroll system.

I have to loop on employees to start generating their pay check. The main...

what I am tring to do is this

I have a main procedure with a cursor that has my master database table and I am looping on the records of this...

Dear All,

I was searching forum for any questions regarding triggers as I am new in using them. I coud not really understand how to use virtual table. Do you mean...