You are correct.

But when we say data is scrambled, does it mean that scrambled data should not match with data before scrambling? Shall we allow same values knowing these is...

This is helpful.

However, I see a risk with approach-1 because for customer id 97, Random date is  same as the original one. Ideally, new date should never be equal what...

Good to know! Thanks Paul

You can write a single query by doing LEFT JOIN of jobs table with status, and drops table.

• For job without any drops, you will get a single rows.
• For...

• This reply was modified 5 years, 4 months ago by GroverVivek.

Below query needs change as per my interpretation:

SET @sqlquery =
N'SELECT [PROJECTID],[MODELID],[PROJECTLINEPROPERTYID],' + @PivotColumns + '
INTO TBL_TEMP
FROM [dbo].[ProjForecastSalesStaging]

PIVOT ( SUM(AMOUNT)
FOR PROJECTFORECASTINVOICEDATE IN (' + @PivotColumns + ') )...

• This reply was modified 5 years, 4 months ago by GroverVivek.

Hi,

From Integration Service Catalog, you can see the execution report of all SSIS packages. You might get error details from there if any.

So you can follow the below steps to tune the query if you have access to the database to run the same sp by passing the parameters coming through application...

1. You can use 3 operators to accomplish this.

   1. Intersect operator to get names in both
   2. A except B to get names in A only
   3. B except A to get...

And In SQL Developers I am considering guys who also work in SSRS on daily basis. But still should have had done some R&D to know what R can give...