BEGIN TRANSACTION
DECLARE @ClaimID int

INSERT INTO [Dashboard].[dbo].[ST_ClaimSummary] (UserID, TravelMilesGross, TravelMilesDeducted, TravelMilesNet, TravelAmount, ExpenseAmount, TotalAmount)

VALUES (1,28.1,8.1,20,7.20,3.30,10.50)

SET @ClaimID = SCOPE_IDENTITY()

INSERT INTO [Dashboard].[dbo].[ST_TravelDetail] (UserID, ClaimID, RowID, Date, Type, Description, PostcodeFrom, PostcodeTo, MilesGross, MilesDeducted, MilesNet, Amount, LearnersVisited)

VALUES (1, @ClaimID, 0, CONVERT(DATE,'30/09/16',3),'Travel','first visit','DL15 9GL','DH8 5EE',28.1,8.1,20,7.20,'Bob Smith (020101154611)'),(1, @ClaimID , 1, CONVERT(DATE,'30/09/16',3),'Travel','first visit','DL15 9GL','DH8 5EE',28.1,8.1,20,7.20,'Bob Smith (020101154611)')

INSERT INTO [Dashboard].[dbo].[ST_ExpenseDetail] (UserID, ClaimID, RowID, Date, Description, Amount)

VALUES (1, @ClaimID, 0, CONVERT(DATE,'01/10/16',3),'tyne tunnel',3.30),(1, @ClaimID ,1, CONVERT(DATE,'01/10/16',3),'tyne tunnel',3.30),(1, @ClaimID ,2, CONVERT(DATE,'01/10/16',3),'tyne tunnel',3.30)

DECLARE @StepNumber int = 1

INSERT INTO [Dashboard].[dbo].[ST_WorkflowLog] (ClaimID, StepNumber, OldStatus, OldResponsible, NewStatus, NewResponsible, Comment)

VALUES (@ClaimID, @StepNumber, 'Draft', 1, 'Submitted', 10, NULL)

SELECT  'Claim_ID' = @ClaimID

COMMIT

$statement = sqlsrv_query($conn,$saveclaim_sql);
if($statement) {
            sqlsrv_fetch($statement);
            $claimID = sqlsrv_get_field( $statement, 0);
}