create procedure [dbo].[MssWebInsertOrderLocation]
    @inOrderId int,
    @inOrderLocationAddressTypeId int,
    @inDescription varchar(100),
    @inCrossStreet varchar(1024),
    @inServiceEntrance varchar(1024),
    @inSiteNote varchar(1024),
    @inContactId int,
    @inBuildingId int,
    @inImportedFlag bit
as
begin
    set nocount on;
    insert into OrderLocations(
        OrderFID,
        Name,
        OrderLocationAddressTypeFID,
        CrossStreet,
        ServiceEntrance,
        SiteNote,
        OrderContactFId,
        BuildingFId,
        ImportedFlag)
    select OrderFID = @inOrderId,
        Name = @inDescription,
        OrderLocationAddressTypeFId = @inOrderLocationAddressTypeId,
        CrossStreet = @inCrossStreet,
        ServiceEntrance =@inServiceEntrance,
        SiteNote = @inSiteNote,
        OrderContactFId = @inContactId,
        BuildingFId = @inBuildingId,
        ImportedFlag = @inImportedFlag;

    declare @id int = SCOPE_IDENTITY();
    select @id
end
GO
GRANT EXECUTE ON  [dbo].[MssWebInsertOrderLocation] TO [MssExec]
GO