>>Thanks a lot.
>>

>>declare @PassedCategory char(1)
>>set @PassedCategory = 'L'
>>declare @CategoryPrice smallmoney
>>select @CategoryPrice = Price from PriceInfo where CreditCategory = @PassedCategory
>>select 'CT' as State, @CategoryPrice as Price, CreditType, county,
>>registry, city, address, def1FName, Def1LName
>>from CTCredit..CreditInfo where CredID in
>>(select CredID from CartDetail
>>inner Join CartContent on
>>CartDetail.CartContentID = CartContent.CartContentID
>>and CartContent.State = 'CT' and CartContent.CreditCategory = @PassedCategory )

>Ok, didn't work. Will need to create an SqlStr.

And run it using EXECUTE() or sp_executesql. Remember that it'll be separate batch so it wouldn't be able to see any sproc variables.