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

Banks seem to be capable of doing date math, I've for instance seen interests paid early

😎

jasona.work (12/24/2015)

---

OK, who here has created a "spoof" stored procedure so they can make it look like they're calling DBCC TIMEWARP in their code? Maybe calling it DBCC_TIMEWARP or...

For fun, here is an alternative method

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.TBL_TESTDUPE_05') IS NOT NULL DROP TABLE dbo.TBL_TESTDUPE_05;

CREATE TABLE dbo.TBL_TESTDUPE_05

(

set_id CHAR(3)

,col1 ...

I second Jeff's suggestion in most cases but there are times when an additional table might be an overkill such as y/N for YES / NO etc. In those cases...

Quick suggestion

😎

DDL and Sample data

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.Main') IS NOT NULL DROP TABLE dbo.Main;

IF OBJECT_ID(N'dbo.Tags') IS NOT NULL DROP TABLE dbo.Tags;

IF OBJECT_ID(N'dbo.Docs') IS NOT NULL DROP TABLE dbo.Docs;

CREATE TABLE...

Jeff Moden (12/22/2015)

---

... unless you add persisted...

😉

faster the better...........oops

😎