Viewing post 1 (of 1 total)
quote:FYIJust solved :select PowerID, b.BookID, b.namefrom t_Power dp join t_book b On dp.bookid = b.bookidwhere @ID =CASE @SURPRESSWHEN 1 THENb.bookidELSE@IDEND
quote:
Just solved :
select PowerID, b.BookID, b.name
from t_Power dp join t_book b On dp.bookid = b.bookid
where @ID =
CASE @SURPRESS
WHEN 1 THEN
b.bookid
ELSE
@ID
END
April 10, 2002 at 5:18 am
#426945