New SCRUM Request

#htmleditformat( trim( _line ))#

set nocount on declare @newTrackingId varchar(25) select @newTrackingId = max( round( convert( float, trackingId ), 0 ) + 1 ) from tbl_SCRUM_Requests where isNumeric( trackingId ) = 1 INSERT INTO tbl_SCRUM_Requests (DateCreated, OwnerID, OwnerType, Requestor, RequestType, Rank, ReleaseName, Description, Notes, AssignedTo, StatusCode, trackingId, productFocus ) VALUES ('#created#', 78, 'MSC', '#requestor#', '#reqType#', '#rank#', '#release#', '#description#', , -1, 'U', @newTrackingId, ); select trackingId = @newTrackingId, requestId = @@identity set nocount off set nocount off declare @contentId int insert into tbl_FSC_Content ( mainFolder, subfolder, subfolder2, filename ) values( 'MSC78', 'SRQ', '', ) select @contentId = @@identity insert into tbl_SCRUM_Repository ( ownerId, ownerType, containerid, containerType, docTitle, category, uploaddate, contentId, filesize, fileExt, docDescription, sortRank, restricted, hiddenFile, internalOnly ) values( 78, 'MSC', , 'SRQ', , 0, {fn now() }, @contentId, , , 'File Attachment', 99, 'Y', 'N', 'N') set nocount on

New SCRUM Request

Your request has been submitted.