View Single Post
 
Old May 1st, 2008, 10:13 AM
RinoDM RinoDM is offline
Friend of Wrox
Points: 550, Level: 8
Points: 550, Level: 8 Points: 550, Level: 8 Points: 550, Level: 8
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2006
Location: , , .
Posts: 112
Thanks: 12
Thanked 0 Times in 0 Posts
Default Store procedure help ???

Hi to all...

I created this store procedure that i pass it a 6 digit number...
but it returnes me nothing...

CREATE PROCEDURE sp_GetAllSKU
    @intSKU int

AS
    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'

GO

But if i run it in query analyzer and actually put a number it returnes me info...

select * from PromoDetailID PD
Join PromoID P On P.PromoID = PD.PromoID
where PD.PromoSKU like '%417856%'
and P.PromoActive=1
and P.PromoLanguage='E'


Is there something i'm missing in my SP that i need...

thanking you in advance...

Rino