Annee (8/5/2013)

---

I am using SQL server 2005

Here is the ddl:

CREATE TABLE [dbo].[AgencySupplierPartner](

[ClientName] [nvarchar](15) NOT NULL,

[VendorName] [nvarchar](40) NOT NULL,

[TaxID] [nchar](9) NOT NULL,

[AcceptStandard] [nvarchar](10) NULL,

[AcceptSummary] [nvarchar](10) NULL

CONSTRAINT [PK_AgencySupplierPartner] PRIMARY KEY CLUSTERED

(

[ClientName] ASC,

[TaxID] ASC

)

I would like to write a stored procedure to which I would pass 3 parameters ClientName, VendorName and InvoiceType as parameters.

While ClientName and VendorName are the column names 'InvoiceType' is a variable which could be one of the column names(AcceptStandard or AcceptSummary)

I am trying to put it together as a stored proc(see below), but it doesn't work, probably due to syntax error where I am plugging in @InvoiceType.

Can someone please help me fix it? Thanks!

CREATE PROCEDURE [dbo].[pr_GetVendorInfo]

(

@ClientName nVarChar(15),

@VendorName nVarChar(40),

@InvoiceType nVarChar(10)

)

AS

SELECT COUNT(*) FROM AgencySupplierPartner

WHERE ClientName = @ClientName AND VendorName = @VendorName AND @InvoiceType = 'true'