hahahaha...will do that..:)

Preyatham

I dont know "Common Table Expression". But my intension is to write such a most wanted procedure using only loops and developer friendly with no complexities :-D ....

Preyatham

i too thought this was a boring stuff..but when started to work for this, it pissed me....once i make a generic procedure i will publish here to take your comments CEO...:)

Preyatham

firstly i am talking in sql and not in any other technology... see here is the exact question...write a procedure in which you need to display all direct reports of you..if you do not have a direct report then go for your manager and list his direct reports...write this proc without recursion and without using cursors in the procedure....

bzinez

yeah i tried this for a requirement and successfull..and i am just trying to make it generic so that i can publish here.....

bzinez

i dont know how did you store the global data in resx file. As per my knowledge resx file is automatically created for an aspx and it only holds the data of the page. I dont know how to call resx file in the code but i have a suggestion...Dont make the code too complicated..if you want the global data to be stored then create a separate class...while deploying use x copy deployment where you only use dll...hope this will help you...

bzinez

did anyone try writing a recusion procedure without using recursion priciple.....also do not use cursors...any luck, do let me know ;)

bzinez