Yes paul! 😉

Hi jfallsen, please post sample data, ur table structure, and ur desired output.. this is really pain staking to create them and then attend ur request.. as i had time...

Dear Will, please go through the following article by Jeff http://www.sqlservercentral.com/articles/Best+Practices/61537/ on forum etiquettes..

the information u have provided is not sufficient for us to help u... please post the table...

markjrouse (3/26/2010)

Are there some perculiar behaviours of cursor I should be aware of?

...

hello Paul, i learnt CTE from BOL, so thot that i will frame the code similar to the one in BOL :-D... my tribute...

Welcome dude!

U can pass the ID column as well there...

;WITH HierarchyCTE (ID, EmpID , ReportingManager)

AS

(

SELECT EH.ID, EH.EmpID , EH.ReportToID

...

Good code Nabha.. winner...

Here u go buddy!

;WITH HierarchyCTE (ID, EmpID , ReportingManager)

AS

(

SELECT EH.ID, EH.EmpID , EH.ReportToID

FROM...

Pretty question

Asane, @@LangID gives u the language ID of the current session, which is nothing but the configured language of the server...sys.syslanguages will also retreive you the date format as well.....

😎 🙂

ok fine, i created some sample data and table

if object_id('dataset') is not null drop table dataset

create table dataset( file_no int , fromD int , toD int)

insert into dataset

select 101, 1101,...

Hi sir,

Please post some sample data along with schema as given in the following Jeff's post

http://www.sqlservercentral.com/articles/Best+Practices/61537/

That would help us a lot..

Guyz any updates on this?? do u guys needs more info on the error, i can give..