Grant Fritchey (12/9/2014)

---

Sean Lange (12/9/2014)

---

Here is where I am going to disagree with Gail and Grant. I have worked on a system that had many procs nested like this and...

Before you use the sp_foreach proc you should take a look at this article. http://sqlblog.com/blogs/aaron_bertrand/archive/2010/12/29/a-more-reliable-and-more-flexible-sp-msforeachdb.aspx

Here is where I am going to disagree with Gail and Grant. I have worked on a system that had many procs nested like this and it was a serious...

Don. (12/9/2014)

---

djj (12/9/2014)

---

First is there a reason you are using TEXT? Why not VARCHAR(MAX)? From BOL

ntext, text, and image data types will be removed in a future version...

Wow Luis. I knew a cross tab was the answer but I couldn't begin to put together some code from the original post. Well done sir!!!

Here is an article that talks about the issues with MERGE and lists the connect items associated with it.

http://www.mssqltips.com/sqlservertip/3074/use-caution-with-sql-servers-merge-statement/%5B/url%5D

Jack Corbett (12/2/2014)

---

Ed Wagner (12/2/2014)

---

GilaMonster (12/2/2014)

---

Sean Lange (12/2/2014)

---

This beauty was around 6,000 lines long. That was not a typo. It was a "single" query with something on the...

vecerda (12/2/2014)

---

Sorry about the formatting.

What I need is a listing of store openings by period.

I basically need a horizontal table (in SSRS at the end) that will list 12 periods...

Let's start with some formatting so we can read that query...

SELECT TOP (1000) d.Project_Name

,d.STATUS

,d.Country

,d.Region

,p.Period

,p.Quarter

,p.Year

,d.Brand

,d.Store_Opens_Actual

,d.DA

,d.DPN

,d.StoreNumber

,CONVERT(VARCHAR(10), CASE

WHEN ISDATE(d.Store_Opens_Actual) = 1

THEN d.Store_Opens_Actual

WHEN ISDATE(d.Store_Opens_Forecast) = 1

AND ISDATE(d.Store_Opens_Actual) = 0

THEN d.Store_Opens_Forecast

WHEN ISDATE(d.Store_Opens_Baseline) = 1

AND...

David Burrows (12/2/2014)

---

Luis Cazares (12/2/2014)

---

I have this problem every time...

Ed Wagner (12/2/2014)

---

And reading that makes me want...

Matt Miller (#4) (12/1/2014)

---

Ed Wagner (11/25/2014)

---

Eirikur Eiriksson (11/25/2014)

---

Ed Wagner (11/25/2014)

---

Eirikur Eiriksson (11/24/2014)

---

Jeff Moden (11/24/2014)

---

Evil Kraig F (11/24/2014)

---

Jeff Moden (11/24/2014)

---

Eirikur Eiriksson (11/24/2014)

---

Just a quick question to "the thread", am I missing...

Avoidance

Is it just me or is LinkedIn quickly becoming the most useless website in existence? It seems that all that is there is recruiters always trying to get me to...

Deries (12/1/2014)

---

Hi,

Thank you very much for the your response.

The above table structure is where we store the hourly data for all the units. We dont have any other table...