create procedure sp_sel_MntInstruments_Sel 

@what as varchar(15),
@samplenumber as bigint

as
begin	
		
		if @what = 'subdept' 
			select deptid, subdeptid, description from MstSubDept with(nolock) where deptid = 2 order by description			
			
		if @what = 'instrument'
			select InstrumentId, dbo.fn_ProperCase(InstrumentName) as "InstrumentName" from MstLabInstrument with(nolock) order by InstrumentId	
		
		if @what = 'samplenumber'		
			select a.SampleNumber, a.InstrumentId , a.CdmDesc , a.FirstName +' '+ a.MiddleName +' '+  a.LastName1 + ' '+ a.LastName2  
			from AppLabSenderQueueHST a with(nolock) where a.SampleNumber = @samplenumber
end 

exec sp_sel_MntInstruments_Sel 'subdept'
exec sp_sel_MntInstruments_Sel 'instrument'...

create procedure sp_sel_MntInstruments_Sel 

@what as varchar(15),
@samplenumber as bigint=null
...

quote:

---

Originally posted by CVDpr

Yes @samplenumber as bigint=null, Thanks

---