SSIS comes with something called CHECKPOINT. This allows a process to be restarted from the point of failure. I think you should be using this.

https://docs.microsoft.com/en-us/sql/integration-services/packages/restart-packages-by-using-checkpoints?view=sql-server-ver15

I use Faker, you might need to install Python to use it

https://faker.readthedocs.io/en/master/

Thank...

Install the table valued function in this script: https://www.sqlservercentral.com/scripts/a-daterange-table-valued-function

IF OBJECT_ID('[dbo].[DateRange]','IF') IS NULL BEGIN
    PRINT 'CREATE FUNCTION [dbo].[DateRange]' 
    EXEC ('CREATE FUNCTION...

If you have a query that is taking a long time to execute. Just paste it into SSMS and press the estimated execution plan button in the menu: 

If you have a query that is taking a long time to execute. Just paste it into SSMS and press the estimated execution plan button in the menu: 

i know this one.

the situation is little bit different.

so the query is can we use "with cte" or recursion  inside following clauses like  exists  or cross apply or outer...

You cannot union two WITH statements together. You also cannot have an order by within a union all unless you also use TOP to limit the rows though you could...

You can also get the query plan as text

SELECT TOP(10)
       d.name          ...

When you execute dynamic SQL in a stored procedure you need to have the permissions to execute the SQL inside the dynamic SQL.

This is not true for non-dynamic SQL as...

SELECT DISTINCT GRPID, PLNCD, XPLNE, EXTNO, EffDate, TermDate FROM History WHERE MBRNO IN (SELECT MBRNO FROM dbo.Member_MRN_lkupAllMBRNOs(@strMBRNO)) ORDER BY EffDate ASC

How large (MB/GB) is the "History" table?

How is it...

dbo.Member_MRN_lkupAllMBRNOs is a table valued function.

Can you provide the code?

The execution plan of the query would also be helpful.

Open the script from the control, a new instance of VS will appear with the script in.

Then save the script (ctrl+s) and close the new instance of VS.

Then save the...

SELECT *
  FROM myTable
 WHERE NOT(Sale = 'N' AND Purchase = 'N')

SELECT *
  FROM myTable
 WHERE (Sale <> 'N' OR Purchase <> 'N')

;WITH CTE AS
(
    SELECT t1.Code,
           t1.Name,
        ...