Thankyou so much. You are completely right.
Thanks for looking at the code.
None of the values passed into the EXEC would have NULL.
How does using print help me debug?
I have tried this with the EXEC....
ALTER PROCEDURE [dbo].[SearchTenderMultiRegions]
@whereclause nVarChar(MAX), --4000 chars...
I have tried using the varchar(MAX), but in some instances I have 20,000 char's in the query and it gets truncated.
Also when trying to do the...
SQL Server 2005
My problem (excuse me for being a novice) is that whenever the query becomes complex
in the @whereclause (and it does) it cant exceed the character...
Separate names with a comma.