/****** Object:  Stored Procedure dbo.JMO_SWB_Selp    Script Date: 12/1/2005 11:49:34 PM ******/


CREATE proc JMO_SWB_Selp (
   @k_swb_name      char(65),
   @k_swb_resn      char(17)
)
as
begin
   Select
      swb_name,
      swb_resn,
      swb_srt,
      swb_srv,
      swb_flag,
      swb_desc
   From jmo_swb
   Where
       swb_name         >= @k_swb_name      and
       swb_resn         >= @k_swb_resn
   Order by
       swb_name,
       swb_resn
   For Browse
end
GO
GRANT EXECUTE ON  [dbo].[JMO_SWB_Selp] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_SWB_Selp] TO [emuser]
GRANT EXECUTE ON  [dbo].[JMO_SWB_Selp] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_SWB_Selp] TO [jmouser]
GRANT EXECUTE ON  [dbo].[JMO_SWB_Selp] TO [uniadmin]
GRANT EXECUTE ON  [dbo].[JMO_SWB_Selp] TO [uniuser]
GO