Funny!

Sad really though that they can't at least let you script in .net languages.

I suppose there are some trusted/untrusted code issues to resolve.

Postgres has had extensions for other languages...

Daniel Brink (2/24/2014)

---

Nice article. I'm still working on writing my first technical article. It's a bit of a daunting task, but I'm getting there.

Regarding sp_ExecuteSQL: Dynamic SQL is one of...

Wow thanks for what was effectively part 2 in this spackle 🙂 You've written an article in its own right to answer my question and I am very grateful, as...

Thanks for the Spackle Jeff, I always read your articles.

Just thinking a bit further, is the clustered index enough to really take advantage of those end and start date intersections?...

Left join... Where a column...

raulggonzalez (1/21/2014)

---

davoscollective (1/21/2014)

---

Ah yes you are correct, my mistake, the maxrecursion 0 removes the limit. I agree, go for the better performing code. It is one statement, but internally it...

Ah yes you are correct, my mistake, the maxrecursion 0 removes the limit. I agree, go for the better performing code. It is one statement, but internally it is still...

raulggonzalez (1/21/2014)

---

PHYData DBA (1/20/2014)There might be several other ways of doing this without using a Row By Row script. We could not find one that was as easy to read...

"Mr Pepper" ? Surely that's the only real Doctor present.

I found this thread both amusing and enlightening on many levels.

Thanks for the great article.

I suppose for SQL people it might look unreadable but I found your examples very easy to understand. There's a clear nested structure

Evaluate<-Rows<-Row functions etc

I...

Lowell (3/10/2009)

---

not built in , no; typically formatting is left for the presentation layer, like vb;

you can do something pretty close:

declare @val decimal (12,6)

set @val =...

I realise...

dwain.c (11/6/2013)

---

davoscollective (11/6/2013)

---

Are you trying to return only records where ReferenceNo IS null?

Imagine...

Are you trying to return only records where ReferenceNo IS null?

Imagine this is...

Great article, thanks for sharing. I've used similar constructs for flexible SSRS reports. I learned a few nice tricks, I particularly like the @debug and the line numbers, very nice.

Based...