Thanks Dwain.C

That did the trick for that. What are you talking about, "special characters"? You did not include the article. There are some rows that use RTF data, would that...

Thanks Luis

That worked perfectly.

I hope that you have a very nice weekend

Andrew SQLDBA

Thanks Everyone

I was getting close, but I was struggling. Thank you very much for your assistance.

Who ever had the bright idea of storing date data like this needs to have...

Thanks Gail

I never thought of it that way. Great analogy. While looking thru some of the data, I found that one out of the 3 million rows actually had a...

Chris

Thank you for your concern and advice. I know that. But I am querying this data from another database to pump into one of my own. I have no control...

Thank You Luis, that worked perfectly.

Greatly appreciate it.

Andrew SQLDBA

Thank You to Everyone

I just figured it out. I got up, walked away for a while, watched a little tv, and came back to hit again.

This is what I used:

UPDATE...

Also, on another note. You should Never prefix a user sproc with "sp_" that is reserved for the system sprocs. You will gain some performance when you use a different...

Just my 3 cents......

But do not use that naming convention. You should not prefix your objects with the type of object. Everyone can easily tell it is a table.

You will...

Sounds like you have the "Default" database set to a database that the login does not have access. Check that, and make certain you change the database name to the...

I am receiving the same error in my SSIS Package after deploying it to a Prod Server. I have no messagebox in either script task, they have all been removed....

Cannot be done that I know of. you can use a simple web page that can do this. You can always use SQL Agent and schedule the sproc.

Andrew SQLDBA

Why in the world would ever think about using dynamic SQL? That is just horrible.

Stay far away from the dynamic SQL. That would never pass one of my code reviews.

Andrew...

Robert

But you kept trying to install SQL Server over top of things that were not working correctly any way. I have never had an issue using a .NET front-end with...

I can, but was trying to avoid it sincerely. It just makes no sense to me that installing a program on a computer is so difficult and, if anything goes...