Viewing 15 posts - 1 through 15 (of 54 total)
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...
June 25, 2022 at 7:19 am
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...
June 24, 2022 at 12:46 pm
Good to know! Thanks Paul
February 15, 2021 at 1:08 pm
You can write a single query by doing LEFT JOIN of jobs table with status, and drops table.
February 15, 2021 at 11:45 am
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 + ') )...
February 15, 2021 at 11:01 am
Hi,
From Integration Service Catalog, you can see the execution report of all SSIS packages. You might get error details from there if any.
October 29, 2020 at 7:38 am
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...
August 20, 2020 at 4:19 pm
August 20, 2020 at 4:10 pm
<Order_Notification Level="x">
<Order_Company Level="y2">
<Order Level="z3" />
...
February 11, 2019 at 4:54 am
February 2, 2018 at 2:06 am
February 1, 2018 at 5:45 am
January 25, 2018 at 6:49 pm
January 25, 2018 at 6:45 pm
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...
January 25, 2018 at 11:04 am
Viewing 15 posts - 1 through 15 (of 54 total)