DECLARE @OldMenuSetName NVARCHAR(50) = 'TestLId:204'--'Stara Nazwa' --tu jest nazwa z ktorej robimi kopie
    DECLARE @NewMenuSetName NVARCHAR(50) = 'Nowa nazwa' --tu jest nazwa dla nowego Menu Set
    DECLARE @LocationId BIGINT = 1 --tu jest Id Location do ktorego zostanie podpiety nowy Menu Set

    INSERT INTO dbo.INFMenuSet (INFAccountId, Name, IsDeleted)--, LastSyncDateUTC, LastSyncTweetID)
    SELECT ms.INFAccountId
        , @NewMenuSetName
        , 0
    FROM dbo.INFMenuSet as ms
    WHERE ms.Name = @OldMenuSetName

    DECLARE @NewMenuSetID BIGINT = IDENT_CURRENT('INFMenuSet')
    UPDATE [dbo].[INFLocation]
    SET INFMenuSetId = @NewMenuSetID
    WHERE Id = @LocationId

    INSERT INTO dbo.INFMenuSetItem
           ( INFMenuSetId
           , INFLanguageId
           , IsVisible
           , Item
           , ItemName
           , LogoINFFileId
           , INFDocumentTemplateId
           , ListOrder
           , IsDeleted
           , DeleteDateUTC)
    SELECT @NewMenuSetID
           , msi.INFLanguageId
           , msi.IsVisible
           , msi.Item
           , msi.ItemName
           , msi.LogoINFFileId
           , msi.INFDocumentTemplateId
           , msi.ListOrder
           , msi.IsDeleted
           , msi.DeleteDateUTC
    FROM INFMenuSetItem msi
        INNER JOIN INFMenuSet ms ON ms.Id = msi.INFMenuSetId
    WHERE ms.Name = @OldMenuSetName

    select * from INFMenuSet where id = @NewMenuSetID
    select * from INFMenuSetItem where INFMenuSetId = @NewMenuSetID