update dbo.TheTable set

TheColumn = 2009 + (TheColumn / 100.00)

How about this?

What is...

Can you provide a simplified version of what you are attempting to accomplish including table definitions (CREATE TABLE stements), smaple data (INSERT INTO statements for each table), and expected results...

Simple answer, by design. If you find yourself in a position of having to restore the master database, I am guessing it needs to be operational upon completion of...

Are talking about stripping the { and } from the data and replacing it in the same place?

J-F Bergeron (1/12/2010)

---

J-F Bergeron (1/12/2010)

---

GilaMonster (1/12/2010)

---

Johannesburg, South Africa. For anyone who's geography a little weak, that's at the southern end of the African continent.

Yes, we have electricity and internet (most...

J-F Bergeron (1/12/2010)

---

GilaMonster (1/12/2010)

---

Johannesburg, South Africa. For anyone who's geography a little weak, that's at the southern end of the African continent.

Yes, we have electricity and internet (most of the...

GilaMonster (1/12/2010)

---

Johannesburg, South Africa. For anyone who's geography a little weak, that's at the southern end of the African continent.

Yes, we have electricity and internet (most of the time), we...

Colorado Springs, Colorado (A born and raised Colorado Native).

Duplicate post. Please respond here.

Looks like a trees and forest issue. Glad to be able to help.

UNION

SELECT

dbo.Staff.Firm, --dbo.Staff is aliased Staff_3, this should be Staff_3.Firm

Person_3.FullName AS Name, CAST('NONE' AS varchar(5)) AS Department, Address_2.City, Address_2.StateCode AS State,

Company_3.Name AS...

A good place to start would be with the last article I reference in my signature block regarding Managing Transaction Logs.

Okay, twenty four hours and no response. Yep, definitely NOT a discussion on the OP's problem. Can't have a one way discussion, that is just a lecture or...

crookj (1/11/2010)

---

Thx for the replies all....

We do have an IMAX here in town so I guess my Wife and I are heading out to use the Cinemark gift card my...