In SQL 2005 you can use XML data Type to pass structured data to stored procedure, instead of TVP.

as I understand the second post from Greg Charles was enough to you.

You are passing one parameter that contains only one value ('A' or 'B' or 'ABC' or whatever)....

Hello,

I just want to make things clearer:

You want to pass A, B, C or D in your parameter and after it to use in your IN clause?

If it is YES,...

Hello nabajyoti.b,

Just to notice, there is NO such format as you wish.

The nearest format is the previously mentioned, but you need modification

DECLARE @InvoiceDate DATETIME

DECLARE @Ans AS VARCHAR(12)

SET @InvoiceDate =...