Michael Earl (5/14/2008)

---

You could do this with a check constraint. That is prbably what I would lean toward. I think you could probably get better performance out of...

It depends on what the job is doing and what the other stuff is doing.

There are no perfect security solutions. Decide what's good enough, and then go with that.

etxeb (5/14/2008)

---

Hello,

My purpose is to read some csv files from an application. And to do that I thought that the best way was to bulk that csv to the...

Won't matter if the next desired row is the same account number.

Will matter that it's SQL 2000. (You posted this in the 2005 forum, so I assumed it was...

There may be ways to test it without taking that down, but really, do you want a test that tells you, "oh sure, it'll probably work", or do you want...

Your analogy is like an analogy. (Very funny. Phil Factor will love it.)

Something I would try first, if I were you, is setting up a transaction log backup to run every 15 minutes or so. It's quite likely that this will...

I think it's a valid question. Was clear enough to me anyway.

It brings up the caveat of: Compiles and Runs does NOT mean Correct

That's an important lesson for any...

Yes. You can either set up a linked server, or use openrowset.

This article, http://www.sqlservercentral.com/articles/Advanced+Querying/61716/, has an outline of how to do that kind of thing. Just substitute string concatenation for sub-totals.

(As an aside, please keep the code a little narrower. I dislike horizontal scrolling. Not a big deal, but I'd appreciate it.)

Nope. No explanation for that. ...

GilaMonster (5/13/2008)

---

I'll go with a simple partitioned table (partitioned on the day of week, or the day of month, depending on data volumes) Don't see any need to add the...

You can get relatively accurate with the run time by setting a variable to getdate() before you execute, and another to getdate() after you execute, and comparing the difference. ...

A recursive common table expression (recursive CTE) can do that pretty easily. Here's a sample based on your sample data:

create table #T (

Seq int primary key,

Account int)

insert into #T...