Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
tmp [2019/01/17 17:51]
gerardorourke
tmp [2019/04/02 09:42] (current)
gerardorourke
Line 1: Line 1:
 ==== tmp ==== ==== tmp ====
  
 +<​code>​ 
 +DECLARE @parameterValues NVARCHAR(MAX) 
 +SET @parameterValues = ( 
 +SELECT DISTINCT 
 +','​ + [EnterpriseName] + ':'​ + CAST([SkillTargetID] AS NVARCHAR(MAX)) 
 +FROM 
 +[enumeration].[Skill_Group] 
 +FOR XML PATH(''​)) 
 +SET @parameterValues = SUBSTRING(@parameterValues,​ 2, LEN(@parameterValues) - 1) 
 +IF (@parameterValues IS NOT NULL AND @parameterValues != ''​) 
 +BEGIN 
 +EXECUTE [DW622].[connector].[InsertCalculationParameterTypeValues] '​skillGroups',​ '​Ucce',​ @parameterValues 
 +END 
 +</​code>​