SET NOCOUNT ON
GO
SELECT '"EXEC " + @[User::TempProcSchema] + @[User::_parDataFolder] + "_" + "' + REPLACE(name, 'datafolder-', '') + ISNULL(PARAMs, '') + '"
'
FROM sys.objects o
OUTER APPLY (SELECT '
' + Util.dbo.StringCOncat(p.name + ' = ?', ',
') AS PARAMs
FROM sys.parameters P
--INNER JOIN sys.types t ON t.user_type_id = p.user_type_id
WHERE p.OBJECT_ID = o.OBJECT_ID) p
WHERE type = 'p'
AND SCHEMA_ID = SCHEMA_ID('template')
AND name NOT LIKE '%transform%proper%'
AND name NOT LIKE '%sevenin%'
--AND name NOT LIKE '%sevenindic%'
--AND name NOT LIKE '%TransLegalParty%'
--AND name NOT LIKE '%TransformTransAction%'
GO
SELECT REPLACE(name, 'DataFolder-', '') + ','
FROM sys.objects o
WHERE type = 'p'
AND SCHEMA_ID = SCHEMA_ID('template')
AND name NOT LIKE '%transform%proper%'
AND name NOT LIKE '%sevenin%'
--AND name NOT LIKE '%sevenindic%'
--AND name NOT LIKE '%TransLegalParty%'
--AND name NOT LIKE '%TransformTransAction%'