Loading

Error Executing Stored Procedure with Dynamic Pivot

Jes Sie

I created successfully a stored procedure with a dynamic pivot. But, when I executed the sp, I got a conversion failed error. Please refer to the below image.

Hope someone will enlighten me. Thanks in advance.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Mohanty4y ago
Accepted answer
In your dynamic query you have cast @id as varchar. In dynamic query instade of @id use below query.
CAST(@id AS VARCHAR)
Jes Sie4y ago
Amit Thanks for the reply. I applied your suggestion, but, got another error.