Comments by NASIFKHAN (Top 1 by date)

Basically the error is in the query ...
SELECT @UserId,@UserId,@OriginatorId,FileKey,'Account '+CAST(FileKey AS VARCHAR),-1,GETDATE(),972, -1, 0, null,NULL,NULL
FROM dbo.ApplicantDetails
GROUP BY FileKey
having FileKey IN ('8','9')

I need to rewrite it ... but don't know how to do it..


If I ran the query separately, the query is ok

Thanks
Nasif