>>>Forget it.
>>>Sorry.
>>
>>Yes Yes Yes Yes Yes .. ??
>>
>>kidding of course. Cheers,
>
>Cheers :)
>
>How can I do:
>
>declare @CategoryPrice smallmoney
>select @CategoryPrice = select 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 )

Also it is good idea to pass a field list?
>
>Is it right?