MotivateMan1394 (9/25/2015)

---

hi

I create a report base on categories and sales of goods.

Now I have Daily Info abaout all Products.

But I Need to present this report base on weekly periods....

Quick question, can you post the DDL (create table) and preferably some sample data as an insert statement?

😎

...and break your back...

Not that I'm getting old:Whistling: but the likes of CZ-P09...

Ed Wagner (9/25/2015)

---

Eirikur Eiriksson (9/25/2015)

---

SQLRNNR (9/25/2015)

---

jasona.work (9/25/2015)

---

Ed Wagner (9/25/2015)

---

jasona.work (9/25/2015)

---

Ed Wagner (9/25/2015)

---

jasona.work (9/25/2015)

---

Dang...

Now I'm going to have to leave it to the wife which one we go to Sunday (Saturday...

SQLRNNR (9/25/2015)

---

jasona.work (9/25/2015)

---

Ed Wagner (9/25/2015)

---

jasona.work (9/25/2015)

---

Ed Wagner (9/25/2015)

---

jasona.work (9/25/2015)

---

Dang...

Now I'm going to have to leave it to the wife which one we go to Sunday (Saturday is booked.)

Of course, the...

Jeff Moden (9/21/2015)

---

Eirikur Eiriksson (9/19/2015)

---

Jeff Moden (9/19/2015)

---

Eirikur Eiriksson (9/17/2015)

---

Using my normal test harness, Kristen's DATETIMEFROMPARTS solution is a clear winner, more than twice faster than the next one. Note that...

jasona.work (9/25/2015)

---

Ed Wagner (9/25/2015)

---

jasona.work (9/25/2015)

---

Ed Wagner (9/25/2015)

---

jasona.work (9/25/2015)

---

Dang...

Now I'm going to have to leave it to the wife which one we go to Sunday (Saturday is booked.)

Of course, the Ren...

Ed Wagner (9/25/2015)

---

jasona.work (9/25/2015)

---

Ed Wagner (9/25/2015)

---

jasona.work (9/25/2015)

---

Dang...

Now I'm going to have to leave it to the wife which one we go to Sunday (Saturday is booked.)

Of course, the Ren Fest...

SQLRNNR (9/25/2015)

---

Eirikur Eiriksson (9/25/2015)

---

WayneS (9/25/2015)

---

Eirikur Eiriksson (9/25/2015)

---

SQLRNNR (9/23/2015)

---

Eirikur Eiriksson (9/23/2015)

---

WayneS (9/23/2015)

---

Eirikur Eiriksson (9/23/2015)

---

Come on Jason, don't be shy, pitch one of your good comments:-P...

WayneS (9/25/2015)

---

Eirikur Eiriksson (9/25/2015)

---

SQLRNNR (9/23/2015)

---

Eirikur Eiriksson (9/23/2015)

---

WayneS (9/23/2015)

---

Eirikur Eiriksson (9/23/2015)

---

Come on Jason, don't be shy, pitch one of your good comments:-P in here, I've...

SQLRNNR (9/23/2015)

---

Eirikur Eiriksson (9/23/2015)

---

WayneS (9/23/2015)

---

Eirikur Eiriksson (9/23/2015)

---

Come on Jason, don't be shy, pitch one of your good comments:-P in here, I've only done few...

smthembu (9/24/2015)

---

Hi All,

I have recently upgraded my DEV environment from SQL 2008 SP4 to SQL 2012 SP2 and all went good. Now the issue at hand is that when i...

SQLRNNR (9/24/2015)

---

GilaMonster (9/24/2015)

---

robinwilson (9/23/2015)

---

Thanks all for the information and detailed responses which is all really useful.

Heaps

I was told this by the software supplier:

I accept that clustered indexes do seem like...

Slum