You can do this quite easily using a tally table; read Tally Tables[/url] if you are not familiar with these.

It's easy if the periods for each Id can't cross...

select dateadd(DD,-1,dateadd(MM,@uptomonth,cast(str(@year,4)+'-01-01'as date)))

Stefan Krzywicki (12/2/2011)

---

Ninja's_RGR'us (12/2/2011)

---

GSquared (12/2/2011)

---

But I was just quoting Blazing...

Y? No pantz yet, so nos genst z rulz.

Iz 2 errly inz z month 4 endz ov month nitemayorz, today ownly sekunz. Or u meanz frun...

GSquared (12/2/2011)

---

Brandie Tarvin (12/1/2011)

---

Hey, guys. Is Gus gone yet?

GSquared (12/1/2011)

---

- GSquared, RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF,...

Sounds like Chicago

Excellent question. A good one for Friday - nice and easy.

I don't understand why so many people (184 out of 370 so far) got it wrong.

It must seem blindingly...

Samwise

But this sequence raises a question: do Hobbits eat frozen yoghurt?

Hugo Kornelis (12/1/2011)

---

Well, I guess the issue is that the...

What makes you think that?

bitbucket-25253 (11/30/2011)

---

I am tempted to go back and quote all those whiners and challenge them to submit a QOD, if only to show them how difficult it is. Now...

SQLRNNR (11/30/2011)

---

L' Eomot Inversé (11/30/2011)

---

Pain, doom, disaster, or maybe I'm just having a bad day.

Today's QotD and my response to comments on it could be taken as an object less...

Gerardo Galvan Castro (11/30/2011)

---

Tom,

In the e-mail newsletter the QotD did not state it was for SQL Server 2008 and later, so I tested under SQL Server 2005 (the...

Pain, doom, disaster, or maybe I'm just having a bad day.

Today's QotD and my response to comments on it could be taken as an object less in how to screw...