harry.sh16 (8/16/2009)

---

As posted earlier my input in source is of Char data type with values like 0,1,5,6, 12,14, 22.

My destination data type is numeric(1,0). Do i need a transformation at...

Full and Differential backups will not break the log chain on the source database, so you will be able to continue running your full and differential backups after configuring log...

If you log your messages to a table variable first, you can then write those messages to a permanent table outside of teh transaction (either after the commit or rollback)....

Your best resource may be the one you may be replacing in January. Work with this individual as much as possible while you can. Learn the systems you...

Jeff Moden (8/15/2009)

---

Lynn Pettis (8/15/2009)

---

GilaMonster (8/15/2009)

---

Yes, you would.... Especially the one that reads 'MCT'

I've corrected him...

GilaMonster (8/15/2009)

---

Yes, you would.... Especially the one that reads 'MCT'

I've corrected him elsewhere also today. I'm...

Having read that you are using SQL Server 2000, not SQL Server 2005 you really should also pay a little closer attention to where you post your request for help....

I think I...

It would also help if you could provide the DDL for the tables involved, sample data that shows the problem you are trying to solve, expected results to be achieved.

Please...

harry.sh16 (8/14/2009)

---

I'm trying to convert number values like 0 , 1, 2 which are stored as char(10) datatype to numeric(1,0) datatype.

Both source and destination's are SQL Server.

Tried various type...

Started off making this harder than it was. here is the code I came up (also note how I set everything up, as this is how you should post...

Duplicate post. Please don't post in multiple forums. You just fragment responses to your request for help that may result in duplicate work by others.

Please post replies here.

What kind of error messages are you getting? It would help if you would provide the entire error message(s).

This isn't the article I was thinking about, but it would definately be one worth reading for your project as well:

http://msdn.microsoft.com/en-us/library/ms345146(SQL.90).aspx.

Going to say it again, you are going to need a rolling window partitioning for what you are trying to accomplish. Based on what I am seeing you want...