Viewing 15 posts - 1,891 through 1,905 (of 1,922 total)
Chandradyani (3/29/2010)
Dear ColdCofee,Thank you so much for your answer and you link for etiquette so next time I will ask a better question.
Welcome Mate... and thanks for going thro the...
March 29, 2010 at 2:04 am
Lynn petis, jeff moden, steve jones, gail shaw, garadin, jack, rbarry, paul, anirban, gsquared, ninja , nabha ,cirqudesqliel etc etc etc etc- these are all stalwarts here, and u can...
March 29, 2010 at 1:06 am
Paul, i have a doubt here.. did i answer to OP's question.. i understood it in a way and i have provided the link.. do u think i have given...
March 29, 2010 at 12:20 am
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...
March 28, 2010 at 11:54 pm
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...
March 28, 2010 at 1:21 am
markjrouse (3/26/2010)
Are there some perculiar behaviours of cursor I should be aware of?
...
March 26, 2010 at 9:47 am
Paul White NZ (3/26/2010)
A very similar example
hello Paul, i learnt CTE from BOL, so thot that i will frame the code similar to the one in BOL :-D... my tribute...
March 26, 2010 at 9:09 am
U can pass the ID column as well there...
;WITH HierarchyCTE (ID, EmpID , ReportingManager)
AS
(
SELECT EH.ID, EH.EmpID , EH.ReportToID
...
March 26, 2010 at 2:22 am
Here u go buddy!
;WITH HierarchyCTE (ID, EmpID , ReportingManager)
AS
(
SELECT EH.ID, EH.EmpID , EH.ReportToID
FROM...
March 26, 2010 at 2:14 am
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.....
February 4, 2010 at 1:57 am
Viewing 15 posts - 1,891 through 1,905 (of 1,922 total)