select requestId from tbl_SCRUM_Requests where description like and ownerId = 78 and ownerType = 'MSC' select email from tbl_Fspro_members where fspro_userId = select fspro_userId from tbl_Fspro_members where ownerId = 78 and fsl_tablecode = 'MSC' and email = insert into tbl_SCRUM_Requests ( ownerId, ownerType, rank, description, sizeEstimate, statusCode, trackingId, notes, datecreated, createdBy, modifiedby, assignedTo, projectId, complexity, requestor, requestType, releaseName, topPriority, approved, billingStatus, devComponent ) values ( 78, 'MSC', 1, , 'Tiny', 'Q', '', '

Managed in Jira

', getDate(), , , , , 'L', , 'ENHANCEMENT', , 'Y', 'Y', '?', 212 ); declare @requestId int = @@identity; declare @trackingId varchar(25) = cast( @requestId as varchar ); update tbl_SCRUM_Requests set trackingId = @trackingId where requestId = @requestId; select ownerId, ownerType, requestId, rank, description, sizeEstimate, statusCode, trackingId, notes, datecreated, createdBy, modifiedby, assignedTo, projectId, complexity, requestor, requestType, releaseName, topPriority, approved, billingStatus, devComponent from tbl_SCRUM_Requests where requestId = @requestId