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

😎

Brandie Tarvin (12/22/2015)

---

Sorry to interrupt a valuable discussion on posters, but I need some sympathy.

Cancer cat (Formerly had a sarcoma removed) now needs to go back in for some surgical...

Good stuff, care to share the solution?

😎

stevennjuki (12/22/2015)

---

Hello,

I am able to get various totals summed up from varying row numbers of this table

CREATE TABLE [dbo].[tb_a]([cl_t][datetime] NOT NULL ,[cl_a][decimal](18,5) NOT NULL) ON [PRIMARY]

like this...

Michael L John (12/22/2015)

---

Eirikur Eiriksson (12/22/2015)

---

GilaMonster (12/22/2015)

---

Eirikur Eiriksson (12/22/2015)

---

One recent poster kept asking over and over again why he was getting an error whilst trying to do something he'd already...

Crossing the...

sharonsql2013 (12/22/2015)

---

Hi,

I am trying to compare two columns but looks like its a data issue

One column as data like "Team Leader - XYZ" and second one has "Team Leader-XYZ"

Is there...

GilaMonster (12/22/2015)

---

Eirikur Eiriksson (12/22/2015)

---

One recent poster kept asking over and over again why he was getting an error whilst trying to do something he'd already been told was impossible, had...

ScottPletcher (12/22/2015)

---

Edit: Not at all "moving the goalposts". The only reason for the rule is the issue it causes if you get the type wrong, as I stated many...