Query to create Job Services based upon Job Service

Use this query to create Job Services based upon a single Job Service:

Insert Into [JobService] ([DBId], [Id], [JobId], [ServiceId], [Num], [Description], [DescriptionExcess], [ClientId], [FeeType], [FeeTypeTrigger], [Fees], [ACFees], [Limit], [IndexValue], [IndexArticleId],
[IndexCalcAmount], [YearlyCyAmount], [YearlyIndexCalcAmount], [CommissionArticleId], [CommissionRate], [CommissionAmount], [CommissionACAmount], [IncludeInInvoice], [Frequency],
[FrequencyNum], [FrequencyType], [FrequencyDate], [RepeatMonth], [RepeatNumber], [TimeReportTypeId], [NumberOfUnits], [StartDate], [EndDate], [CurrencyId], [ACCurrencyId],
[GLAccountId], [VATId], [VATCode], [VATRate], [ArticleId], [CountryIndexId], [CountryIndexTypeId], [LastInvoiceTId])
Select [JobService].[DBId],
ROW_NUMBER() OVER(ORDER BY [Job].[Number]) + nnnnn AS [ResId],
[Job].[Id] as [JobId],
[JobService].[ServiceId],
[JobService].[Num],
[JobService].[Description],
[JobService].[DescriptionExcess],
[Job].[ClientId] as [ClientId],
[JobService].[FeeType],
[JobService].[FeeTypeTrigger],
[JobService].[Fees],
[JobService].[ACFees],
[JobService].[Limit],
[JobService].[IndexValue],
[JobService].[IndexArticleId],
[JobService].[IndexCalcAmount],
[JobService].[YearlyCyAmount],
[JobService].[YearlyIndexCalcAmount],
[JobService].[CommissionArticleId],
[JobService].[CommissionRate],
[JobService].[CommissionAmount],
[JobService].[CommissionACAmount],
[JobService].[IncludeInInvoice],
[JobService].[Frequency],
[JobService].[FrequencyNum],
[JobService].[FrequencyType],
[JobService].[FrequencyDate],
[JobService].[RepeatMonth],
[JobService].[RepeatNumber],
[JobService].[TimeReportTypeId],
[JobService].[NumberOfUnits],
[JobService].[StartDate],
[JobService].[EndDate],
[JobService].[CurrencyId],
[JobService].[ACCurrencyId],
[JobService].[GLAccountId],
[JobService].[VATId],
[JobService].[VATCode],
[JobService].[VATRate],
[JobService].[ArticleId],
[JobService].[CountryIndexId],
[JobService].[CountryIndexTypeId],
[JobService].[LastInvoiceTId]
from [JobService], [Job]
where [JobService].[DBId] = 1 and [JobService].[Id] = xxxxx
and [Job].[DBId] = zzzzz and Not [Job].[Id] = yyyyy
and [Job].[Number] like '% - Advisory'