Lynn Pettis (3/30/2009)

---

Jan Van der Eecken (3/30/2009)

---

Geez, you are quick to pull out the rule book. Admitted, the pic is about the red card in the finals of a prof...

I understand...

Heh... it's all your fault, ya know? Our conversations about 3 months ago are what started it all.

Thanks for the feedback, Grant.

Absolutely unbelievable... I'm truly humbled by all your good urgings. Thank you all for your confidence.

Apparently, you good folks aren't the only ones that think that I should write...

Just add +1 to the following and you'll get your 60 months...

where n.n <= DATEDIFF(m,@first_month,@last_month)[font="Arial Black"]+1[/font]

Gabriel P (3/27/2009)

---

I figured it out in case anyone is interested.

declare @first_month datetime, @last_month datetime

select @first_month = DATEADD(m,DateDiff(m,0,Min(sale_datetime)),0),

@last_month = DATEADD(m,DateDiff(m,0,Max(sale_datetime)),0)

from #temp

select n.n, t1.*

from #nums n

cross apply (select top 10 *

from...

Jacob Pressures (3/27/2009)

---

Thanks guys. So what, I'd have to subscribe to a forum to get all the different posts? Much of what i see often goes over my head....

SinghS (3/27/2009)

---

I am struggling with same issue. I want to identify special characters at varchar column so that I can replace it with some other character.

Example: “Hello World”

Space between “Hello”...

Heh... bad day, David?

Please see the link in my signature below... we...

Ummmm.... the only way a DELETE trigger that updates the table will cause other triggers to fire is if Cascade Triggers is turned on. It's not normally a good...

Sorry... almost forgot... spreadsheets and plain text are a bit of a chore because most folks on this forum like to test their code against your good data before posting...

Joseph Henry (3/28/2009)

---

Thanks for all of the advice. I'm wondering though.. Can I use Pivot without having aggregate functions? I started to work on a select statement, but...

... and here's the code, all cleaned up so it can actually be copied correctly instead of the mess the code window made. Barry, if you test compare against...

Man... I just went back and looked at the code I posted... these bloody new code windows added an extra charindex, changed double spaces to single spaces, and did a...