DECLARE @xsltManagerName VARCHAR(256) = 'Suggested Count Data'
DECLARE @xsltConcatenatorName VARCHAR(256) = 'Suggested Count Data Concatenator'
;

DECLARE @TaskNameId BIGINT
DECLARE @concatenatorId BIGINT


SELECT  @concatenatorId = [XSLTManagerID]
  FROM [tbXSLTManager] 
WHERE [Name]= @xsltConcatenatorName 

SELECT @TaskNameId = [TaskNameId] FROM 
[tbTaskXSLTExportDetail]
WHERE [XSLTManagerID] IN (
SELECT  [XSLTManagerID]
  FROM [tbXSLTManager] 
WHERE [Name]= @xsltManagerName)
;


UPDATE [tbTaskXSLTExport]
SET ConcatenateAll=1,
	ConcatenateAllXSLTManagerId = @concatenatorId,
	ConcatenateAllFileName='SuggestCountAll_<yyyy><mm><dd>_<hh><min><ss>.csv'
WHERE TaskNameId=@TaskNameId

GO