79277358

Date: 2024-12-13 06:10:49
Score: 0.5
Natty:
Report link

I have tried like this that work for me please try and check

DROP PROCEDURE IF EXISTS TestingSP;

IF EXISTS (SELECT * FROM sys.types WHERE is_table_type = 1 AND name = 'EntityIds')
      DROP TYPE dbo.EntityIds;

CREATE TYPE dbo.EntityIds AS TABLE (EntityId UNIQUEIDENTIFIER);


CREATE PROCEDURE dbo.TestingSP
        @AccountIds dbo.EntityIds READONLY
    AS
    BEGIN
            CREATE TABLE #TempMonthlyPermits (
                MonthlyPermitId uniqueidentifier  
            );

            INSERT INTO #TempMonthlyPermits (MonthlyPermitId)
            SELECT Id
            FROM MonthlyPermits
            WHERE AccountId IN (SELECT EntityId FROM @AccountIds);

            DELETE FROM MonthlyPermitFees
            WHERE MonthlyPermitId IN (SELECT MonthlyPermitId FROM #TempMonthlyPermits);

            DELETE FROM RecurringChargesHistories
            WHERE MonthlyPermitId IN (SELECT MonthlyPermitId FROM #TempMonthlyPermits);

            DELETE FROM MonthlyPermits
            WHERE Id IN (SELECT MonthlyPermitId FROM #TempMonthlyPermits);

            DELETE FROM MetaData
            WHERE AccountId IN (SELECT EntityId FROM @AccountIds);

            DROP TABLE #TempMonthlyPermits;
    END;
Reasons:
  • RegEx Blacklisted phrase (1): I have tried like this that work for me please
  • Long answer (-1):
  • Has code block (-0.5):
  • Low reputation (1):
Posted by: Rahul Timbaliya