Here is my take on this solution:

select

gla.id as GLAcct,

gla.descr as GLDesc,

sum(case when cast(gl.transaction_date as DATE) between dateadd(year,datediff(year,0,getdate()),0) ...

CELKO (9/4/2014)

---

The highlighted (bolded) pattern for validation will allow for INVALID MONTHS. Since when do we have a 13th, 14th, 15th, 16th, 17th, 18th, or 19th month in ANY...

Yes, I actually threw one of Mr. Celko's own arguments back at him in a post talking about dates.

I liked the COBOL reference since he likes to use it when...

CELKO (9/4/2014)

---

... The pattern for validation is '[12][0-9][0-9][0-9]-00-00' and '[12][0-9][0-9][0-9]-[01][0-9]-00'

Your mindset is still back in FORTRAN and BASIC with UDF and procedural programing. Aas you have been told, they have...

Solomon Rutzky (9/4/2014)

---

Jeff Moden (9/3/2014)

---

I guess I'd have to disagree. Nulls mean "Unknown" and it is definitely known that there are no values on either side of the space...

CELKO (9/4/2014)

---

...

rental_month CHAR(10) NOT NULL

CHECK (rental_month LIKE '[12],[0-9][0-9][0-9]-[01][0-9]-00')

Why not do it like this? It uses less space and ensures you don't get any invalid months or...

CELKO (9/3/2014)

---

the truncated YYYY-MM-DD is allowed in ISO 8061. But DD is constrained to be in the range 01 to 31 so the CELKO YYYY-MM-00 is guaranteed non-conformant...

Looks like several of the games this week could be really close.

[font="Arial Black"]Any given Sunday![/font]

CELKO (9/3/2014)

---

Vastly more important, "we" do not store editing chars within the data! Even if one insists on storing dates as (var)char, why on earth would there ever...

Welsh Corgi (9/3/2014)

---

I completed the code two hours ago minutes before a meeting that I had.

Edit:

The off shore people did not create the table that I needed until today so...

Welsh Corgi (9/3/2014)

---

The final solution should have the Current Date in the Where clause.

My query works until I try and add the WHERE Clause.

I finally got the real Table from...

SreeSql (9/3/2014)

---

With "CONNECT ANY DATABASE" we can basically let users to have visibility to all the databases but not the underlying data inside the databases. As Gail mentioned, there is...

SQLRNNR (9/3/2014)

---

Luis Cazares (9/3/2014)

---

xsevensinzx (9/3/2014)

---

Koen Verbeeck (9/3/2014)

---

xsevensinzx (9/3/2014)

---

I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question just...

Nope.

Give this a try:

with basedata as ( -- creating test data

select

*

from

(values ('INTERNAL COMMUNICATIONS:' + Char(13) + 'Blah blah blah blah'),

...