roh_ranjan (9/26/2012)
Hello SeanThank you for response.I completely agree what you are saying.If you see the above Jason response where he created temp table and show the hierarchy.In same table I need to perform addition/deletion/substitution of the user.Can you help me in this.
Thanks
R
Sure I can help.
If you want some real help with your code please take a look at the first link in my signature about best practices.
You say you agree but you still haven't posted any ddl or sample data.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/