Problem Doing Update And Insert To Different Tables In Same Procedure.

We are trying to update and insert to two different tables using the code below.  However the code never excutes the second insert statement. (see noted area)  Does anybody have any ideas what we are doing wrong?  Any help would greatly be appreciated. 

 set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

GO

 

ALTER PROCEDURE [dbo].[AddPhoto]

@AlbumID int,

@Caption nvarchar(MAX)

AS

INSERT INTO [Photos] (

[AlbumID],

[Caption],

[Location],

[LastModified])

VALUES (

@AlbumID,

@Caption,

'tmpLocation', /* tmpLocation needed because app broke when Location column set to Allow NULLs */

GetDate())

/* Retrieve generated PhotoID */

DECLARE @PhotoID int

SET @PhotoID = SCOPE_IDENTITY()

/* Build unique location path from album and photo ID */

DECLARE @Location nvarchar(MAX)

SET @Location = '' + CONVERT(nvarchar(10), @AlbumID) + '' + CONVERT(nvarchar(10),@PhotoID) + '.jpg'

/* Update photo with new location path */

UPDATE [Photos]

SET

[Location] = @Location

WHERE

[PhotoID] = @PhotoID

 

/* Update photo with new location path */

******************************************The code never executes the statement below********************************************

INSERT INTO [PhotoDefault] (

[pidm],

[defaultPhoto],

[activityDate])

VALUES (

'1234',

'test',

getdate()

)

/* Return PhotoID and Location */

 

SELECT @PhotoID, @Location

RETURN

Thanks,

 

Jason