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..

select * from sys.syslanguages where langid = @@langid

nice question sir

@Grant, even i faced similar result as results... when i run the code as a step in sql server agent, i am not getting the error **AT TIMES**... but when...