IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_SensorModelsGet]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_SensorModelsGet]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_SensorModelsGet]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[sp_SensorModelsGet] AS' 
END
GO
ALTER PROCEDURE [dbo].[sp_SensorModelsGet]
	@Model		nvarchar(50) = null
AS
BEGIN

	SET NOCOUNT ON;
	SELECT [Model]
		  ,[Manufacturer]
		  ,[UserPartNumber]
		  ,[Capacity]
		  ,[OffsetToleranceLow]
		  ,[OffsetToleranceHigh]
		  ,[MeasurementUnit]
		  ,[Bridge]
		  ,[Shunt]
		  ,[BridgeResistance]
		  ,[FilterClass]
		  ,[UniPolar]
		  ,[IgnoreRange]
		  ,[CouplingMode]
		  ,[Version]
		  ,[RangeLow]
		  ,[RangeAve]
		  ,[RangeHigh]
		  ,[LastModified]
		  ,[ModifiedBy]
		  ,[LocalOnly]
		  ,[NumberOfAxes]
		  ,[CalInterval]
		  ,[AxisNumber]
		  ,[Polarity]
		  ,[Invert]
		  ,[CheckOffset]
		  ,[CalibrationRecord]
		  ,[ISOCode]
		  ,[SupportedExcitation]
		  ,[InitialEU]
		  
	  FROM [dbo].[SensorModels] where @Model is null or [Model] = @Model
END






























GO