DECLARE @SQL nvarchar(max)
SET @SQL = 'select incident0.ticketnumber as ''ticketnumber'', incident0.title as ''title'', incident0.new_datetimeofincidentutc as ''new_datetimeofincidentutc'', incident0.new_actual_resolution_timeutc as ''new_actual_resolution_timeutc'', incident0.new_delayduration as ''new_delayduration'', incident0.prioritycodename as ''prioritycodename'', incident0.prioritycode as ''prioritycode'', incident0.incidentid as ''incidentid'', incident_customerid_account_accountid.new_kategorcustomername as ''incident_customerid_account_accountid_new_kategorcustomername'', incident_customerid_account_accountid.new_kategorcustomer as ''incident_customerid_account_accountid_new_kategorcustomer'' from (' + @CRM_FilteredIncident + ') as incident0 left outer join FilteredAccount as incident_customerid_account_accountid on (incident0.customerid  =  incident_customerid_account_accountid.accountid)'
EXEC ( @SQL )