Well, you could use:

WHERE cast(year(EFF_DT) as varchar) + right('0' + cast(month(EFF_DT) as varchar), 2) = '200909'

But do keep in mind that what you're doing often kills query performance, because using...

It would be easier to create a view in db1 that queries the tables in db2 and db3. Or one view for each, if the table structures aren't really...

Mark Pratt (9/1/2009)

---

I did this recently to determine if a row needed to be updated. I put a checksum column in the table using the values that could possibly...

I'm in Tampa, but my Saturdays are usually fully booked. (Pun intended) I'll see what I can do to arrange some time on the 17th. Should be...

I once licked a live electrical cord to find out if it was plugged in. Thus, I'm not in a position to criticize ANYONE for "you shouldn't have done...

I carry two smartphones. I have a BlackBerry assigned from work, and a T-Mobile Dash for my personal use.

For security reasons, I don't access my bank accounts and such...

rboggess (8/31/2009)

---

I see a lot of folks here bashing a guy for standing up for Linux against a crack-pot zealot. Any reason y'all are ganging up?

I'm not saying either...

James Stover (8/31/2009)

---

C'mon, where are the "Mark of the Beast" comments??

Really, nature has already given us a GUID. It's called DNA. That bit of technology has been around for...

That'll work so long as you don't ever add more territories. If adding more territories is even vaguely possible, I'd look into doing a dynamic pivot/cross-tab query, or into...

Don't worry about the sleeping threads in that case. Only do something about them if they're causing an actual problem (which they almost certainly won't).

Definitely look at using something...

It depends on the data type you're using for your identity column.

Take a look at Int, BigInt, SmallInt in Books Online. It has the max/min values.

If you manage to...

Jan Van der Eecken (8/31/2009)

---

Hey Steve,

I may be missing something here, but why does SSC not just refuse to accept a nick that will create a duplicate instead of adding...

I just read up on ZFS, and there are some caveats on it that would potentially keep me from using it.

For example, it appears to be very sensitive to being...

That can certainly cause a performance hit.

Does it have appropriate indexes?

And here I was,...