Glad I could help.

You are getting an error after your BEGIN TRANSACTION and before your COMMIT TRANSACTION. This causes control to transfer to your CATCH block, which does not resolve the transaction...

It's a limitation of how Logarithms work in mathematics.

If you want it to start at zero, you will have to change the scale to be LINEAR instead of LOG.

Glad we could help.

It is a free tool downloadable from Microsoft.

Like this:

UPDATE E

Set EmpID = Left(LastName,1)

+ RIGHT('000000'

+ ROW_NUMBER() Over(Partition By Left(LastName,1) Order by LastName)

, 6)

From Employees E

Sci-Fi: little known author David R Palmer: "Emergence", and also "Threshold"

Fantasy: LotR, of course.

Try "The Black Company" by Glen Cook, first book of a dark fantasy series, especially...

Nice tag! I didn't think that anyone knew "Three Men In A Boat" anymore. 🙂

"Jeremiad"? Cool word! I learn something new every day. And hear I was reading from Jeremiah just yesterday (Jeremiah is definitely the ranter's ranter).

A circular relationship is one that loops back on itself, like this:

CREATE Table Chickens(

ChickenID int identity primary key

, EggID int);

CREATE Table Eggs(

...

I do not understand what "other costs" you are talking about. And, I was talking about an Enterprise scheduler. I don't know anyone who would consider the Windows...

There's no reason that I know of that this should lead to a circular relationship. Try something like this:

CREATE Table Owners(

OwnerID int identity primary key

...

Hmm, you should also try this query, just to be sure:

Select * from temp1

Dose that return your data?

Again, from what you have showed us, it looks OK. Meaning that the problem is probably in the data. You can attach the Excel file here is that...

Gift Peddie (2/23/2009)

---

I prefer the Agent because I have used a package that runs for five hours a day five days a week moving data from DB2 AS400 to SQL...