CREATE proc JMO_MWC_Selp (
@k_mwc_clus char(21),
@k_mwc_name char(17)
)
as
begin
Select
mwc_clus,
mwc_name,
mwc_brt,
mwc_brv,
mwc_desc
From jmo_mwc
Where
mwc_clus >= @k_mwc_clus and
mwc_name >= @k_mwc_name
Order by
mwc_clus,
mwc_name
For Browse
end
GO
GRANT EXECUTE ON [dbo].[JMO_MWC_Selp] TO [emadmin]
GRANT EXECUTE ON [dbo].[JMO_MWC_Selp] TO [emuser]
GRANT EXECUTE ON [dbo].[JMO_MWC_Selp] TO [jmoadmin]
GRANT EXECUTE ON [dbo].[JMO_MWC_Selp] TO [jmouser]
GRANT EXECUTE ON [dbo].[JMO_MWC_Selp] TO [uniadmin]
GRANT EXECUTE ON [dbo].[JMO_MWC_Selp] TO [uniuser]
GO