*****
Declare @maxNumber int
select @maxNumber = max(number)
from (serial s inner join type_view t on s.id_type=t.id and id_group=@id_group)
     inner join equipment e on e.id_sn=s.id and id_host_place=@id_host_place and number is not null
If @maxNumber is not Null  
	set @maxNumber =  @maxNumber +  1 
***********
Declare @strSQL nvarchar( 1024 ),@i int
select	@i = '0',
	@strSQL = N'update equipment set '

If @id_host_place != '0' begin
	set @strSQL = @strSQL + N'id_host_place=''' + convert(nvarchar( 12 ),@id_host_place) + ''''
	set @i = '1'
End
If @basic = '1' 
		set @strSQL = @strSQL + N',number=''' + convert(nvarchar( 12 ),@maxNumber) + ''''

print (@strSQL)  -- для проверки
 
**
 --exec (strSQL)
 

set @strSQL = @strSQL + N',number=''' + convert(nvarchar( 12 ),@maxNumber) + ''''

if @MaxNumber Is Null 
        update equipment set number = NUll where ......