antony-688446 (3/3/2010)

---

I am on the 'poor question' side of this debate. Yes, read the code, make assumptions, and you get the right answer (not convinced its worth 2 points, as...

preetshari (3/3/2010)

---

i get a syntax error when i run this. "Incorrect syntax near '@num'."

Lynn Pettis (3/3/2010)

---

preetshari (3/3/2010)

---

Yes but i need to return the updated LastUsedIndex.

Does this accomplish what you require?

DECLARE...

First, are the files formatted the same? If so, using a FOR EACH container could simplify the process along with dynamically configuring the connection to the import file. ...

SQL Server Express does not have SQL Server Agent, that's why you can't start it.

preetshari (3/3/2010)

---

Yes but i need to return the updated LastUsedIndex.

Does this accomplish what you require?

DECLARE @num int -- or what ever type it is

BEGIN TRAN

UPDATE SeqNumbers

@num...

I hope you have current backups. IIRC, the waste basket on Server may not be big enough to allow you to recover the database files like you would other...

Tells you the last time...

You should check the microsoft web site to be sure, bit iirc, since the Evaluation Edition is essentially the Enterprise Edition with an expiration date I don't think you can...

preetshari (3/3/2010)

---

When two transactions are running the same process concurrently i need to make sure that the other transaction waits till the first one finishes.

Following is an example,

BEGIN Tran

SELECT LastUsedIndex...

I see it now, have a MCDBA working for me that really doesn't get it at all. Do have to say this individual is starting to try, but I...

Have you tried importing the data into a table that does not have the primary key defined and then adding the PK after word? I have found that this...

Just a shot in the dark, but have you tried updating statistics on the database, or at least the tables that the query can/does use?

WayneS (3/3/2010)

---

Lynn Pettis (3/3/2010)

---

They could tier the certifications, as well. One level for those that have passed the certification tests, but lack real worled experience, a higher level for...

Garadin (3/3/2010)

---

Check the article in my signature about crosstabs/pivots. It explains how to make a crosstab query which will work in 2000.

Also, you might want to take a peek...

I noticed that you are selecting from the CTE three times, once in the main query and twice in subqueries. You may want to consider populating one or two...