quote:

---

Error 21001: [SQL-DMO]Stored procedure definition must include name and text (for Standard StoredProcedure) or libraryname (for Extended StoredProcedure).

---

Create Function dbo.sp_GetUlTestPressure(@serial_number varchar(20))
returns int
as
begin
declare @coilType varchar(20), @item varchar(255), @test_result varchar(255)
declare @testPressure int, @index int, @count int, @bool int
set @testPressure=-1
set @count=0
select @test_result=test_result from acp_parts where (system_id like '%label%') and (serial_number like @serial_number)
set @index=CharIndex(',', @test_result)
while (1 < @index) begin
  set @item=SubString(@test_result, 1, @index - 1) -- gets the leftmost item
  if (@count=5) begin
-- 0:WO&PartNo;
-- 1:GrpNum;
-- 2:RowsDeep;
-- 3:HeaderRows;
-- 4:CoilType;
-- 5:Pressure
    if (IsNumeric(@item)=1) begin
      set @bool=Cast(@item as int)
      set @testPressure=Cast(@item as int)
    end
  end else if (@count=4) begin
    if (CharIndex(',', @test_result)=0) begin
      set @coilType=@test_result
      select top 1 @testPressure=testPressure from TestPressures where coilType=@coilType
    end
  end else begin
    set @test_result=LTrim(SubString(@test_result, @index + Len(','), Len(@test_result)))
    set @index=CharIndex(',', @test_result)
    set @count=@count+1
  end
end
return @testPressure
end

Create Function dbo.udf_GetUlTestPressure(@serial_number varchar(20))