So far so good with the DDL but you are missing the sample data matching the expected results.

😎

Yes there is, not only in terms of performance but it's also more legible and maintainable

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID('tempdb..#n') IS NOT...

Quick suggestion, remove the maintenance plans and install Ola Hallengren's SQL Server Maintenance Solution[/url].

😎

Merry Christmas to you too.

What I got is seven rows of all-null record set.

Can anybody give me a hint where I did wrong?...

100% agreeing with Gail on this one.

😎

Piling on a bit

Most wanted (preferably dead) sql code objects and anti patterns:

1. Multi statement multi function table value functions

These functions tend to...

pietlinden (12/25/2015)

---

Was it removed in 2016? I didn't really ever use it much... just never had a reason to.

That said, anybody know what MS's plans are with reporting? It...

Quick solution

😎CREATE TABLE #DeploymentPlan

(

WorkFlow VARCHAR(100)

,Deliverable ...

arnierowland (12/25/2015)

---

Try this one:

SELECT geometry::Parse('POLYGON((

4 0, 0 0, 3 2, 1 2, 3 4, 1 4, 3 6, 2 6,

4 8, 6 6, 5 6, 7 4, 5 4, 7...

My suggestion is to rewrite this query, quite certain that there is no need for neither dynamic sql nor the nested replace. The syntax is correct but the methods are...

Merry Christmas Steve

😎

Check out this thread

😎

He he, cash only:-D

😎

Brandie Tarvin (12/24/2015)

---

Eirikur Eiriksson (12/24/2015)

---

Steve Jones - SSC Editor (12/24/2015)

---

I'm not sure that's...

Quick question, are you storing passwords in plain text?

😎

Steve Jones - SSC Editor (12/24/2015)

---

I'm not sure that's capable. More just "able".

Or...