jcrawf02 (9/8/2014)

---

Jack Corbett (9/8/2014)

---

Sean Lange (9/8/2014)

---

Sometimes being a parent is really difficult. I have been coaching both of my boys soccer teams for a long time. As an...

Just for grins here is another way to do this. This is a little convoluted but I want to use integer math for this. 😀

create table #SomeDates (MyDate datetime)

insert #SomeDates

select...

Ed Wagner (9/8/2014)

---

Sean Lange (9/8/2014)

---

Sometimes being a parent is really difficult. I have been coaching both of my boys soccer teams for a long time. As an adult who plays...

Sometimes being a parent is really difficult. I have been coaching both of my boys soccer teams for a long time. As an adult who plays it is immensely rewarding...

WayneS (9/8/2014)

---

Sean Lange (9/5/2014)It is truly a shame. He has so much he could offer to anybody in this profession but his demeanor online has jaded me so much I...

ramana3327 (9/8/2014)

---

Hi,

I created a view in dev box. I need to deploy that in the production.

How to create deployment scripts for the views with all the commands needed to deploy...

navie22 (9/5/2014)

---

Get date in where condition will also change with each moth like

AND MT.TRANSACTIONDATE BETWEEN DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE())-2, 0) --First day 2 months ago

AND DATEADD(MILLISECOND, - 3, DATEADD(MONTH,...

Assuming the schema are identical it is most likely going to be fragmented indexes or stale statistics. Another option is it might data quantity of data revealing a nonperformant query.

What...

Capsize

Is there a reason you need your data denormalized like this? Would seem easier if you just calculate xMonths ago as needed.

You could just add some additional columns to your...

cphite (9/5/2014)

---

jcrawf02 (9/4/2014)

---

Ed Wagner (9/4/2014)

---

Koen Verbeeck (9/4/2014)

---

andrew gothard (9/4/2014)

---

You know Chris...

Dynamic sql is the only option here.

Solomon Rutzky (9/4/2014)

Hi Sean. In the case of:

Bob,Sally,

The result should be 3 records:

Bob

Sally

{empty string}

A NULL cannot be there as it was a non-NULL string that was split. And there...

Solomon Rutzky (9/4/2014)

---

Lynn Pettis (9/4/2014)

---

Solomon Rutzky (9/4/2014)

---

Second, this shouldn't be controversial since a NULL concatenated into a non-NULL string will (well, should) result in a NULL. This behavior can be...

Grant Fritchey (9/4/2014)

---

Koen Verbeeck (9/4/2014)

---

Roy Ernest (9/4/2014)

---

Thx guys..

There was not SQL Saturday this year. We will have one during memorial day weekend next year.

Jack, hopefully we can meet...