What problem(s) were you trying to solve with c# that you couldn't solve with tsql?

Not sure it's what you need but :

Select c1, min(c2) as c2 from t1 group by c1

It's still not like it's a temp table with only a few dozen rows. She's wasting a lot of time with this curosr/loop.

Sorry... I thaught you knew how to grant permissions with tsql .

I'm gonna be delaying a lot after this one .

Anyways, I think 26% is not a lot. Thge fact is that you...

I have no ida why she sets so many variables... and she didn't provide enough information. So looks like you'll have to wait on this one

That's you bottlenck. Change this task to a bulk insert using dts.

You could import all the files, then start working on validating/splitting.

Then you'd just have 11 insert queries to...

Just forgot something... make sure that the trigger only fires on the first update. I assume here that you are updating a column in the same table where the...

You can add another update trigger if you want. But I would make sure that it fires after the first one. Look up sp_settriggerorder in bols for more...

Here's a little view I put up for an ADP releasing software (releases are made often due to many hotfixes).

It select the procs and functions that do not have deny...

Same here... working only 4 hours today. So I only have 26 minutes to go now .

Or does he mean with the system tables??

Looks like I didn't go to school long enough .

Thanx for the tip.

How are importing the files anyways?

She's going to Pluto to get some ice. I choose to go in my Freezer. Takes less time. .

It's her choice...