Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Please post the full error message, the exact version of SQL that you are on and what seems to cause the error.

Steve Jones - Editor (1/9/2009)

---

There's no downside to doing this. Change it during the day, set up backups every 15 minutes and keep track of the sizes. Set an outlook...

JPLeBlanc (1/9/2009)

---

I have attempted this, but who knows if i was doing it correctly or not, do you all know of any specific learning courses for the workflow editor? or...

crfenix (1/9/2009)

---

Thanks you all for your answers! My script will be executes on MANY servers and I think a couple of them are sql server 2000 so Try Catch is...

The inserted table will contain all the rows that were updated. There may be more than one, SQL doesn't have row triggers.

So, what you need is something like this

UPDATE tbl_Question1Answers...

Duplicate post. No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic633463-8-1.aspx

JPLeBlanc (1/9/2009)

---

It looks and feels fairly simple but each time i do this i get an import error. It finds the data but from what i remember without doing...

There's no equivalent on SQL 2000.

On SQL 2000, check to make sure the log backups are running and check that there are no old open transactions or old unreplicated...

How long is a piece of string?

It depends on the activity in your database, the frequency of your log...

I'm actually the other way around. The heat just kills me. Day...

Please post table definitions, sample data, the query and show what you think you should be getting, and what you are. Read this to see the best way to post...

It's been 30+ degrees here...

jonas_granlund (1/9/2009)

---

I dont agree to that SQL server 2008 dont work as an XML Store, with the new enhancement in XQuery and XML Schema it is a really great XML...

Absolutely. SQL is a relational...