ALTER PROCEDURE [dbo].[sp_TestSetupObjectsGet] @TestObjectName nvarchar(255) = null AS BEGIN SELECT tobj.[TestObjectName] ,ts.[TestSetupName] ,tso.[TargetSampleRate] ,tso.[ExcitationWarmupTimeMS] ,tso.[LocalOnly] ,tso.[TestObjectType] ,tso.[TestObjectPosition] ,tso.[DisplayOrder] FROM [dbo].[TestSetupObjects] tso inner join [dbo].[TestSetups] ts on ts.TestSetupId = tso.TestSetupId inner join [dbo].[TestObjects] tobj on tobj.TestObjectId = tso.TestObjectId WHERE @TestObjectName is null or tobj.TestObjectName = @TestObjectName END