WCM Forum - sql server 2005 trigger

auch wenns gaga ist, momentan hab ich das so:
Code:
 

CREATE TRIGGER [dbo].[NewsletterChanges]

ON [dbo].[NewsletterChanges]

INSTEAD OF INSERT

AS

BEGIN

DECLARE @UserID VARCHAR(50);

DECLARE @Email VARCHAR(100);

DECLARE @Optin VARCHAR(50);

DECLARE @LastUpdateDate VARCHAR(24);

DECLARE @UpdateDate DATETIME;

DECLARE @CustomerNR VARCHAR(13);

DECLARE @Message VARCHAR(500);

DECLARE c CURSOR LOCAL FAST_FORWARD

FOR

SELECT mUserID,

mEmail,

CASE mOptIn

WHEN 'WAHR' THEN 1

WHEN 'FALSCH' THEN 0

END,

'10000'+mCustomerNR AS mCustomerNR,

mLastUpdateDate,

CONVERT(datetime, mLastUpdateDate, 104) AS UpdateDate

FROM INSERTED;

OPEN c

FETCH NEXT FROM c INTO @UserID, @Email, @Optin, @CustomerNR, @LastUpdateDate, @UpdateDate

WHILE @@FETCH_STATUS= 0

BEGIN



INSERT INTO NewsletterChanges(mUserID, mEmail, mOptIn, mCustomerNR, mLastUpdateDate, mUpdateDate)

VALUES(@UserID, @Email, @Optin, @CustomerNR, @LastUpdateDate, @UpdateDate);

EXEC usp_NewsletterChanges @CustomerNR, @Message;

END

FETCHNEXTFROM c

CLOSE c

DEALLOCATE c

END