Por favor me podria una mano con un error que me esta saliendo con un store procedure , de antemano muchas gracias, me bota este error,
error 446: cannot resolve collation for equal to operation.
Este es el store procedure:
CREATE PROCEDURE OF_CREAFC_CLIENTES
AS
INSERT INTO Customerstatus
(CardNo, LastName, FirstName, Mi, Sex, MaritalStatus, Address1, Address2, City, State, Zip, GeographicId,
Category, HomePhone, BusinessPhone, DL, CashBack, Balance, Discount, CreditLimit, ChargeOk, FrequentShopper, WriteChecks,
StoreCoupons, GovermentCheck, PayrollCheck, TermsId, Type, ResaleNo, Link, ShoppedFor, Purchases, NumberOfChecks,
PointsEarned, Memo, Deleted, CardIssued, Created, Modified, ModifiedBy, PricingLevel, ReceiptType,
TipoCliente, TieneBeneficiarios, Empresa, Salario,
TipoIdentificacion, DescuentoPeriodo, MontoDsctoPeriodo, DsctoMultiplePeriodo,
HoraIniDscto, HoraFinDscto, BirthDate)
SELECT
IdCliente, '. ' , Nombre, 'R', 1 , 0 , Direccion, '' , Ciudad, '54', '54001' , 0 ,
0, Telefono1, Telefono3,Tarjeta, 0, 0, 0, 0, 0, 1, 1,
1, 0, 0, 0, 'PC', ' ', ' ', 0, 0, 0,
0, ' ', 0, GETDATE(), GETDATE(), GETDATE(), 1, CASE WHEN TIPO='DETAL' THEN 2 ELSE 1 END AS TIPO, 0,
'0', 0, Empresa, 0,
' ', 0, 0, 0,
'00:00:00', '00:00:00', Fhnace
FROM SERVIOFI.RAYOTEXSA.DBO.FC_CLIENTES
WHERE IDCLIENTE NOT IN (SELECT CARDNO FROM Customerstatus )
UPDATE A
SET FirstName=B.NOMBRE, DL=B.TARJETA,PricingLevel=CASE WHEN B.TIPO='DETAL' THEN 2 ELSE 1 END
FROM SERVIOFI.RAYOTEXSA.DBO.FC_CLIENTES B ,Customerstatus A
WHERE B.IDCLIENTE = A.CARDNO AND YEAR(B.FHING)=YEAR(GETDATE()) AND MONTH(B.FHING)=MONTH(GETDATE()) AND DAY(FHING)=DAY(GETDATE())
GO