You could skip all non-numeric chars at the front of the string, viz:

SELECT

date_input,

SUBSTRING(date_input, PATINDEX('%[0-9]%', date_input + '0'), 30) AS adjusted_date_input

FROM (

...

select

g_a.id as GLAcct,

g_a.descr as GLDesc,

sum(case when g_l.transaction_date >= '20140101' AND g_l.transaction_date < '20140201' THEN g_l.amount_n ELSE 0 END) AS Jan,

--...

sum(case when g_l.transaction_date >= '20140701' AND g_l.transaction_date < '20140801' THEN g_l.amount_n...

CELKO (9/4/2014)

---

Attribute splitting. You...

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

TomThomson (9/3/2014)

---

CELKO (9/3/2014)

---

Do you have you copy of the ANSI/ISO Standards? Read them. The only display format allowed is ISO-8601, 'yyyy-mm-dd' and not your punctuation free version. Sorry....

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

LutzM (9/3/2014)

---

ScottPletcher (9/3/2014)

---

...

There are 3rd party solutions that do that, but they are rather expensive. At least one we investigated uses its own "black box" to hold the data...

If you want to verify the current setting, run this statement:

EXEC sp_configure 'max server memory'

CELKO (9/3/2014)

---

You doing everything wrong. Where is the DDL? That is minimal Netiquette in SQL forums. Is this all INTEGER math? I hope not! But that is what your coalesce...

SQL Server has a feature called computed columns that could be very useful here. Basically you can create a virtual column based on a computation, and it becomes effectively...

LutzM (9/3/2014)

---

One of the issues when using triggers to audit changes is the ability to disable the trigger, apply the change and re-enable the trigger.

Without any audit for DDL changes...

Triggers can capture the originating user as well if you provide that info to the trigger. This can be passed in several ways, including CONTEXT_INFO, APP_NAME or even a...

Agreed, there's no easy way to tell if an index has extra columns. You can use the missing index stats to get a feel for missing column(s) though. ...

Eirikur Eiriksson (8/29/2014)

---

Thank you Scott, Tom and Lynn, this was the discussion I wanted to get going in this context. The subject is far to dependent on the environment and...

Lynn Pettis (8/29/2014)

---

ScottPletcher (8/29/2014)

---

The page split / fragmentation concern is often overblown. Remember, one INSERT, but you may read the row 1000, 10K, 100K+(?) or more times. Particularly...