Did you try the steps that I listed above?

Paul White (4/13/2009)

---

RBarryYoung (4/13/2009)

---

1) For splitting the lines in stored procedure definitions, there is a subtle bug that exists in almost every line-splitting routine, including the ones so far in...

And finally, here is the inclusion code to inlcude it with the other tests:

--- ==========================================================

--- -> Tally/fUNCTION solution

PRINT 'Start Tally-function 3 solution (correct line-splitting)'

SELECT @now = GETDATE()

--- Split text...

Here is the tally-function with the same bug as the other routines:

create function [dbo].[fnSplit4](

...

Jeff may not remember it but he helped me out with some tally-based line-splitting code over the summer and there were several unusual results to come out of it:

1) For...

From flawed reasoning and...

hmm, why two backslashes ("\\"), Florian? Or is that just a C# thing?

Jeff Moden (4/13/2009)

---

Heh... crud... I just sent Tony an email saying that I may have to cancel the book. Flo just beat the hell out of a Tally...

Jeff Moden (4/13/2009)

---

Heh... crud... I just sent Tony an email saying that I may have to cancel the book. Flo just beat the hell out of a Tally...

I apologize, but unfortunately, because of conflicts between VS 2005/.net 2.0 and VS 2008/.net 3.5, my SMO dev environment is down right now so I cannot effectively test anything.

I have...

Well certainly, rudimentaty trending predictors, such as least-squares projections are easy enough to code up in Transact-SQL, however this kind of thing is the specialty of Analysis Services(SSAS). I...

kruti (4/12/2009)

---

the point is, if we are not using 'GO' statement, then how SS will execute the bunch of statement?

eg.:

Statement-1

Statement-2

Here, will Statement-1 execute first, and once it is executed completely...

ABAS101 (4/12/2009)

---

In regards to the article about "Go To Statement Considered Harmful," WOW. If technology hasn't gotten any better since 1980's, I'll go back to my old job. Wait, that...

rajamohangade (4/12/2009)

---

Thanks to you all for all your inputs.

my req is :

If A=null

execute stored prod 1

else

check If A=c

execute stored prod 1

meaning, if the column value is null (this is...

ABAS101 (4/11/2009)

---

Out of curiosity, have you ever created a job in SQL Server with multiple steps and tell it what to do upon failure? If so, then you've used GOTO....