gcopeland (1/9/2009)

---

As the resident HR guy, I note a few pretty vicious posts. That is ok, I have been dispensing unsolicited advice to my fellow techies for decades, and...

scared him off maybe? Hoepfully Peso's link he will follow.

GilaMonster (1/9/2009)

---

It's do-it-yourself sample data. Values at the top of the post, insert statements at...

dumbing down I think. Mind readers we aren't, though benefit it might be...

GilaMonster (1/9/2009)

---

Great, we've got table structure and sample data.

Based on the sample data you have posted, what are the exact results that you want? Post exactly what values you need...

Jeff Moden (1/9/2009)

---

Opportunities to hurl some well deserved pork overhand always bring the...

I think it was Jack Corbett who suggested this in another thread (I may have the wrong name) but you may want to look at the File Properties Task offered...

Good to see you...

Glen Parker (1/9/2009)

---

Hi Troops

I have an on-line Hospitality Book which is audited 6 monthly ie audit column set to 1 (default = 0)

I am attempting to select only records with...

Jeff, I think you handled that one very well. It is one that could have gotten nasty. I'd make another comment, but...

Hey, while I'm here, have you...

hmmm, no. Several starwars films I saw...

Peso (1/9/2009)

---

Lynn Pettis (1/8/2009)

---

Didn't someone write an article that talked about how DATEDIFF and DATEADD worked? I can't find one on SSC, so it may have been an article...

Sorry, had a few meetings, and then had to leave work for another meeting (non-work related). Let us know if that helps your performance issue.

Also, if you copy the...

Amazing, isn't it? Three days ago I scraping ice off my car, today I walked at lunch without a jacket!

stricknyn (1/8/2009)

---

Hello everyone,

Ok this is weird. When I run the statement below it is returning 1. Can someone explain to me why this is returning 1?

select datediff(year, '2008-01-09...