View Single Post
 
Old May 1st, 2008, 10:51 AM
rgerald rgerald is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Naperville, IL, USA.
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts
Default

You had:
Code:
    select * from PromoDetailID PD
    Join PromoID P On P.PromoID = PD.PromoID
    where PD.PromoSKU like '%@varSKU%'
    and P.PromoActive=1
    and P.PromoLanguage='E'
Change it as follows:

    where PD.PromoSKU like '%' + @varSKU + '%'


Rand