>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.
If it's not broken, fix it until it is.
My Blog 
