sp_helptext GetvinsProdclass3CD
Text
CREATE Proc GetvinsProdClass3CD
@ProdClass3CD as int
as
select top 5 ProductCD, sum(point) as point from vinstemp WITH (NOLOCK)
where Prodclass3cd = @ProdClass3CD
group by ProductCD
order by point desc, ProductCD
sp_helptext ex_VinsBookEvent
Text --------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Create Proc Ex_VinsBookEvent
@BookClass1CD int,
@BookClass2CD int,
@BookClass3CD int
as
Select B.BookCD, B.imagePaths, B.BookName, B.Price, B.SellPrice
From Book B With (NoLock) join BookBookClass BBC With (NoLock)
on B.BookCD=BBC.BookCD
Where BBC.BookClass1CD=@BookClass1CD and BBC.BookClass2CD=@BookClass2CD and BBC.BookClass3CD=@BookClass3CD
And SubString(SVAppendix,1,2)>'00'
Order by SubString(SVAppendix,1,2)
