You're welcome.

Can you provide the definition of the underlying table, and some sample data to insert into it?

There are a couple of ways to get what you want, but I need...

It's possible it's just a typo in what you posted, but the first thing I noticed is that you don't have single-quotes around the cut-off date in the When clause....

Nope.

I've been caught with errors like that before, and you've called me out the same sort of way. I've never taken it personally...

Steve Jones - Editor (3/13/2009)

---

So do we teach people here? Or push them to get better? Or push them away and say "you're not qualified" and "you need to go...

J (3/12/2009)

---

I was talking about using the bcp utility, accessing the file system, generating Excel spreadsheet.

Yes, this was in SS2K, not SS2K5 of course -- now less and less appropriate...

1. Duh! Because!!!11one!!

2. They're indexes...

This does not sound to me like something that you will be building yourself. It may seem like a simple idea, but, trust me, if it has anything to...

JacekO (3/12/2009)

---

GSquared (3/12/2009)

---

That would violate one of the key properties of a database, its ACIDity. Not a good idea. Read up on why ACID matters. It's just...

I just did a pretty heavy-duty test of the YYYYMMDD method, and it seems to be plenty fast and was accurate for all dates I checked.

Here's the test:

set nocount on;

if...

Good article, Lynn. Glad you mentioned the legal issues surrounding Leaplings.

JacekO (3/12/2009)

---

Lynn,

If I am not mistaken the SAVE POINTS still does not provide you with an option to nest. It allows you to rollback to a certain point but...

The first rule with xp_cmdshell is don't use it unless you absolutely have to.

The second rule is, if you think you have to use it, you're probably wrong.

All that aside,...

Basically, it allows you to have slightly finer control over complex stored procedure transactions.

Say, for example, you have a stored procedure that inserts some data into a table, then calls...

That one was translated. Look back a few few...