Differences
This shows you the differences between two versions of the page.
| 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> | ||