henkvisser (1/16/2009)

---

I'm trying to use the stored procedure below in SQL Server 2000, but I get the following error;

Server: Msg 170, Level 15, State 1, Line 4

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 4: Incorrect syntax near 'much'.

Failed to get the call stack!

I know there difficulties passing tablenames but this is clearly not a tablename.

Var values used:

@BatchID = 461

@ErrorReason = 'DataElementID too much characters (>3)'

@WhereStatement = 'LEN(DataElementID) > 3'

CREATE PROCEDURE dbo.spWriteErrorRows

@BatchID INT,

@ErrorReason VARCHAR(200),

@WhereStatement VARCHAR(200)

AS

EXEC('

INSERT INTO dbo.ImportError

(DataElementID, CenterCode, ValueType, ValueDate, [Value], ImportDate, BatchID, ErrorReason)

SELECT

DataElementID, CenterCode, ValueType, ValueDate, [Value], GetDate(), ' + @BatchID + ', ' + @ErrorReason + '

FROM dbo.ImportAccess

WHERE' + @WhereStatement)

GO

Obviously it can't handle the @ErrorReason variable. Is there any way to fix this?