This is probably overly complicated, but I think it works:

Start out with the parse routine:

declare @a varchar(150),

@b-2 varchar(150),

@c varchar(150)

set @a = 'AUDITR 0287 Location 01 Auditor ,Location 16 Auditor,Location 19...

That's because in this syntax:

declare @r varchar(255)

select @r = '"$5,176,641.00"'

select @r = replace('"','',@r)

select @r

you are using a double-quote as the string expression, and trying to replace every instance of...

Greg,

See how this works:

SELECT DATENAME(year, sys_requestdate) AS Year, DATEPART(mm, sys_requestdate) AS Month_No, DATENAME(month, sys_requestdate) AS Month_Name,

COUNT(sys_request_id) AS Opened, COUNT(sys_requestclosedate) AS Closed

FROM request

GROUP BY DATENAME(month, sys_requestdate), DATENAME(year, sys_requestdate), DATEPART(mm, sys_requestdate)

HAVING (DATENAME(year,...

I think you answered your own question. The incorrect order of the REPLACE function parameters is the problem. You should run it like this instead:

select @r =...

If you found two duplicated item_no's why did four rows get deleted? Wouldn't you want to delete just one of the duplicates so that one unique row would remain?

I must...

To answer the 'Why don't you just use replication/triggers to keep the tables in sync' questions:

Our app is being phased out, and was developed by 2 teams of developers that...

I agree, I think there's no way around the fact that you have to convert first. This should put you in the right direction for converting to standard MSSQL...

The answer is 6 seconds. 😉

But seriously, what kind of date format is that? I couldn't find any examples of converting from that format.

Wow, that's sweet! I hadn't seen that before.

To implement a join, you need fields of like data types with potentially matching data to act as the join fields. They DO NOT, however, have to be named...

This may start you off in the right direction for the first part of your question:

create proc uspGetAdmins @User varchar(40), @IsAdmin varchar(1) OUTPUT

as

set @IsAdmin = (

select IsAdministrator

from tbl1 as t1

join...

How about using a distributed query to copy all the data after adding the 2000 server as a linked server? This is after using the Generate Scripts wizard in...

James, I think you are right. SET IDENTITY_INSERT YOURTABLENAME ON should perform the same function as (in DTS) checking the Enable Identity Insert box, right?

Seth

Thanks, but that still doesn't work in SQL Express. Guess I'll just install the real thing. 🙂

I was referring to the error logs. I think the problem is I'm running SQL Server 2005 Express, and it doesn't seem to allow you to see any activity...