just to be sure, can you exec sp_help History and also exec sp_help LM_Date1 so we can be sure the columns H.Paid_Date and LM_Date1.Paid_Date are both datetime?

We recently upgraded, but we did not do it the way you described.

we brought up a new server, and made sure it had access to the san.

depending on the database,...

the only way i see that happening is if the columns with the date is being treated as a varchar...but you said you were sure the fields were datetime data...

i think it's because the script was generated in compatibility 90 syntax, but you are creating the table in V80:

i think this part is not 80 compatible on line 35...

Without more details, I'd build a prototype job that looked something like this:

IF EXISTS(SELECT STATUS FROM SOMETABLE WHERE STATUS='READY')

BEGIN

SET XACT_ABORT ON

...

Karthika Raman (1/17/2008)

---

I will not be able to control the entire process through SSIS. The migration tool cannot be controlled through SSIS. So given that I have to...

i put to gether the table and data, but didn't have time to continue; this might help in the analysis:

create table #SpreadSheet(

Zip varchar(9),

City ...

see this page for someone else who had the same issue:

http://www.sqlservercentral.com/Forums/Topic419269-146-3.aspx

there is a function called Propercase in the script contributions section.

with that function installed, you could then simply do an update:

UPDATE SomeTable

SET NameColumn = dbo.Propercase(NameColumn)

Proper Case A String Or...

we had to maintain level 80 compatibility for a while;

tracing the application, we found that some sql statements which you could get away with in 80 fail in 90;

specifically it...

a function is a special, more limited type of stored procedure. it is specialized, so it has more limitations.

here's some high points, but there's a lot of infor to google...

select * from sysindexes where name like '_Wa_Sys%' in sql 2000 or 2005.

SQL server collects statistics on every query you run....those statistics can be used to determine whether a...

I'm properly chastized for talking without testing...

my answer is appropraite for WHERE statements, but not a replace...

LIKE '%%%%' would be where a percent sign exists in the data, for example.

two of the same character in a row is the escape for any special character in sql:brackets, percents, single quotes, etc.

replace(somecolumn,'%%','') to get rid of a percent sign, if it...

maybe i read your attachment too quickly, but i didn't see a worksheet with the data, only the sheet with the column definitions.

if there was a worksheet with just data...