SELECT issueID, i.projectID, i.shortID, i.issue, i.detail, i.type, i.severity, i.status, i.created, i.createdBy, i.assignedTo, i.milestoneID, i.relevantURL, i.updated, i.updatedBy, i.resolution, i.resolutionDesc, i.componentID, i.versionID, i.dueDate, p.name, c.firstName as createdFirstName, c.lastName as createdLastName, u.firstName as updatedFirstName, u.lastName as updatedLastName, a.firstName as assignedFirstName, a.lastName as assignedLastName, m.name as milestone, pc.component, pv.version FROM #variables.tableprefix#issues i LEFT JOIN #variables.tableprefix#projects p ON i.projectID = p.projectID LEFT JOIN #variables.tableprefix#users c ON i.createdBy = c.userID LEFT JOIN #variables.tableprefix#users u ON i.updatedBy = u.userID LEFT JOIN #variables.tableprefix#users a ON i.assignedTo = a.userID LEFT JOIN #variables.tableprefix#milestones m ON i.milestoneID = m.milestoneID LEFT JOIN #variables.tableprefix#project_components pc ON i.componentID = pc.componentID LEFT JOIN #variables.tableprefix#project_versions pv ON i.versionID = pv.versionID WHERE 0=0 AND i.projectID = AND i.projectID IN () AND issueID = AND i.status IN () AND i.type = AND i.severity = AND i.assignedTo = AND i.milestoneID = AND i.componentID = AND i.versionID = SELECT count(*) as numTix FROM #variables.tableprefix#issues WHERE projectID = INSERT INTO #variables.tableprefix#issues (issueID, projectID, shortID, issue, detail, type, severity, componentID, versionID, dueDate, status, assignedTo, milestoneID, relevantURL, created, createdBy) VALUES(, , '#arguments.ticketPrefix##qCountTix.numTix+1#', , , , , , , #CreateODBCDateTime(arguments.dueDate)#NULL, 'NewAccepted', , , , #Now()#, ) UPDATE #variables.tableprefix#issues SET projectID = , issue = , detail = , type = , severity = , componentID = , versionID = , dueDate = #CreateODBCDateTime(arguments.dueDate)#NULL, assignedTo = , status = 'Accepted', status = 'New', milestoneID = , relevantURL = , updated = #Now()#, updatedBy = WHERE 0=0 AND issueID = UPDATE #variables.tableprefix#issues SET status = 'Accepted', assignedTo = , updated = #CreateODBCDateTime(Now())#, updatedBy = WHERE projectID = AND issueID = UPDATE #variables.tableprefix#issues SET status = 'New', assignedTo = '', updated = #CreateODBCDateTime(Now())#, updatedBy = WHERE projectID = AND issueID = UPDATE #variables.tableprefix#issues SET status = 'Resolved', resolution = , resolutionDesc = , updated = #CreateODBCDateTime(Now())#, updatedBy = WHERE projectID = AND issueID = UPDATE #variables.tableprefix#issues SET status = 'Closed', updated = #CreateODBCDateTime(Now())#, updatedBy = WHERE projectID = AND issueID = UPDATE #variables.tableprefix#issues SET status = 'Accepted', updated = #CreateODBCDateTime(Now())#, updatedBy = WHERE projectID = AND issueID =