Thanks Tal. That worked like a charm !

Thanks Antares and WZ. Your feedback was very helpful.

Antares, that link did not work. Could you repost the link please? That would be helpful.

Thanks wz700. Where can i get a list of such unicodes to work with sql server?

Thanks. I found the option once i posted my message out here. Your timely response is appreciated.

That's not what i am looking for. I hear that some companies sell training notes to be distributed by the training institutes. We are planning to start a training institue...

This is the message i got...Does this mean i need to install service pack 4.0?

Microsoft SQL Server 7.00 - 7.00.842 (Intel X86)

Mar 2 2000 06:49:37

Copyright...

Hi,

Thanks for the response. However, the sp_compare2tables stored procedure did not work. I have found a solution by intersecting the two tables to find the difference. Issue solved.

Thanks Jay it worked with the double FROM WTRDET statement. Its strange though while i was testing SQL with the same SELECT * query it gave me an error. But...

Jay, i am using SQL server 7.0

Here's the query and the error results:

DELETE

FROM WTRDET

INNER JOIN

(

SELECT Order_NBR ,Line_NBR, MAX(Ship_Date) as MaxShipDate

FROM WTRDET GROUP BY Order_NBR ,Line_NBR

) AS dt

ON WTRDET.Order_NBR =...

hey Jpipes, i tried the query. It works fine with Select statement, however, when i use the delete statement it gives me an error at the INNER JOIN and at...

Andy,

We have tried the forms on stand alone client pc and its able to connect to the database on a server using the user dsn. The real...

Thanks Brandon & Elias. I was able to fix it the same way you guys had mentioned in your messages. It works fine now. Thanks very much.

Excuse me? i don't get it. I have admin privileges in the NT box and i use "SA" as the login for the SQL server in the package that i...

steve,

i got it, i had changed the sa password previously and forgot to change it in the EM sql agent. I changed it now. Works fine.

thanks for...