Hey there i do a select depending of what they want, i use a couple of If. Is there something similar to switch for sql of a better approach to do this?create procedure sp_sel_MstAHBTE_Sel@what as varchar(20)asbeginset nocount on if @what = 'fcid' select FCID, Description from MstFinancialClass with(nolock) if @what = 'servicearea' select ServiceArea, Description from MstServiceArea with(nolock) if @what = 'regtype' select RegistrationType, Description from MstRegistrationType with(nolock) if @what = 'billtype' select BillTypeID, Description from MstBillType with(nolock) if @what = 'patienttype' select PTID, Description from MstPatienttype with(nolock)end
Something Similar to Switch for SQL?
Posted - 2008-11-20 : 10:01:39
