Annee (8/6/2013)

---

Thanks for the quick response and the solution, had to modify it slightly as below:

CREATE PROCEDURE [dbo].[pr_GetVendorInfo]

(

@ClientName nVarChar(15),

@VendorName nVarChar(40),

@InvoiceType nVarChar(30)

)

AS

declare @SQL nvarchar(2000)

set @SQL = 'SELECT COUNT(*) FROM AgencySupplierPartner '

+ ' WHERE ClientName = '''+@ClientName+''' AND VendorName = '''+@VendorName +''''

if @InvoiceType = 'AcceptStandard'

set @SQL = @SQL + ' AND AcceptStandard = ''true'''

if @InvoiceType = 'AcceptSummary'

set @SQL = @SQL + ' AND AcceptSummary = ''true'''

print @SQL

exec sp_executesql @SQL