I am using English SQL Server 2000 8.00 2039 (sp4) and following works fine.

I mean usgin [varchar] and without [N] of N''.

DECLARE @T TABLE (ID int, Test varchar(10))

INSERT INTO @T...

Are you executing as:

EXEC Uni 'unicode here'

or as

EXEC Uni N'unicode here'?

Also check the font setting in your query analyzer.

2. Uni '#3523;#3538;#3458;#3524;#3517;'

should be

2. Uni N'#3523;#3538;#3458;#3524;#3517;'

How are you executing the SP?

UPDATE Mgr

SET national_manager_id = DSR3.salesrep_id

FROM DimSalesrep Mgr

LEFT OUTER JOIN DimSalesrep DSR2 ON Mgr.manager_id = DSR2.salesrep_id

LEFT OUTER JOIN MudgeeLiv_App.dbo.dept dept ON DSR2.department = dept.dept

LEFT OUTER JOIN DimSalesrep DSR3 ON LTRIM(RTRIM(dept.mgr_num)) =...

SELECT *

FROM Client A

WHERE NOT EXISTS

(SELECT * FROM State Z

WHERE Z.StateCode = A.StateCode

AND Z.city = A.city

AND Z.zip = A.zip)

SELECT *

FROM Client

WHERE StateCode NOT IN

(SELECT StateCode FROM State)

Are you checking for @@error inside of the SP?

UPDATE YourTable

SET grade =

CASE

WHEN school IS NOT NULL AND examscore IS NOT NULL AND areacode IS NOT NULL

THEN 'A'

WHEN school IS NOT NULL AND examscore IS NOT NULL AND areacode...

INSERT INTO EMPLOYEES(Rtype, Amount, Refnumber, Color)

SELECT Rtype, 99, Refnumber, Color

FROM Employees

WHERE Rtype = 'RD'

May I know what "INNER LOOP JOIN" is?

Regards,

K. Matsumura

A few years ago, I was developing a system using SQL 6.5/Delphi 3.

In front end (Delphi), default rounding was Banker's Rounding.

Because ANSI decided to uses Banker's Rounding as standard.

My client...

SELECT ID, MAX(apple), MAX(banana), MAX(berry), MAX(cherry)

FROM Table

GROUP BY ID

ORDER BY ID

By sample data I mean DDL and INSERTS for your posted expected result.

K. Matsumura

Please post sample data.

K. Matsumura

Thank you all,

It worked in the following way:

EXEC sp_addlinkedserver '192.168.1.1'

EXEC sp_addlinkedsrvlogin @rmtsrvname = '192.168.1.1', @useself = 'false',

@locallogin = 'sa', @rmtuser = 'sa', @rmtpassword = 'password'

EXECUTE [192.168.1.1].master.dbo.sp_executesql

'SELECT A.Column1, MyDatabase.dbo.MyFunction(A.Columns1)

FROM MyDatabase.dbo.MyTable A'

EXEC...