select

max or min(testdate), --max or min depends on which date you want assigned to that 7 day range

sum(value1), --or whatever aggregate function is needed on a column

sum(value2), --etc.

sum(value3),

from table

group by...

L' Eomot Inversé (8/13/2013)

---

batgirl (8/13/2013)

---

I fully appreciate the efforts of the author - the bottom line is that this question forced me to learn something new. I just wish...

garyh2k3 (8/13/2013)

---

My spreadsheet has sample data of grouped by month, grouped by Day. I would like the same date displayed for the group by the past 7 days. ...

garyh2k3 (8/13/2013)

---

This looks like the correct logic but it is in integer format. Is there a way for me to get the date of this calculation? For example...

Stefan beat me to it - same answer here.

group by ((DATEDIFF(day, getdate(), "datefield"))/7)

L' Eomot Inversé (8/13/2013)

---

mtassin (8/13/2013)

---

TaylorMade (8/13/2013)

---

I don't even have 2012 installed yet, so I did some research, and found:

"A folder contains one or more projects and environments in the SSISDB...

Benki Chendu (8/9/2013)

---

I dont need to know the procedure to create Linked Server. However, I know it.

I would want to let a user create linked server on his own. Does...

Did you try google?

"SQL permission to create linked server" search returned this link first:

http://technet.microsoft.com/en-us/library/ff772782.aspx

Glad it worked - I will enjoy that beer!

try something like this:

DATEADD(HOUR,5,DATEADD(MINUTE,25,"origdatetime"))

Koen Verbeeck (8/8/2013)

---

Jeff Moden (8/8/2013)

---

Koen Verbeeck (8/8/2013)

---

I think one of my first "eureka" moment - as Jeff calls it - was when I read Jeff's article about the Tally table...

I have always believed that it was up to me to find ways to add value - especially if I expected to have added compensation. I feel that I...

Sister Act

Ralph Hightower (8/2/2013)

---

I'll continue with photography as a outlet to C# programming. I am in a very small minority in the local camera club since I'm the only one that...

I definitely learn something new every day just hanging out here at SSC.com 🙂