Sean is correct....

--Create your type

CREATE TYPE TCType AS TABLE

(

TranCode varchar(20)

)

--Create some sample data

CREATE TABLE Test (TranCode varchar(20))

INSERT INTO Test (TranCode) VALUES ('BUY')

INSERT INTO Test (TranCode) VALUES ('SELL')

INSERT INTO Test (TranCode) VALUES ('CONSTRAIN')

INSERT INTO Test (TranCode) VALUES ('HOLD')

INSERT INTO Test (TranCode) VALUES ('ON ACCOUNT')

--Create your procedure

CREATE PROCEDURE TestProc

@TCType TCType READONLY

AS

SELECT

*

FROM Test T

INNER JOIN @TCType TC

ON T.TranCode = TC.TranCode

GO

--Decalre your variable populate it and pass it to the procedure

DECLARE @TranCodes AS TCType

INSERT INTO @TranCodes SELECT 'BUY' UNION SELECT 'HOLD'

EXECUTE TestProc @TranCodes