Viewing 15 posts - 1 through 15 (of 25 total)
So what I need. I have a code where I have defined Actuals, Forecast and Absolute Error for each title in each location (store).
When you want to sum individual...
December 14, 2021 at 10:33 pm
As Steve mentioned use AVG() or Min() or Max() aggregate function to return 701.
If you want more people to look into, Provide some sample data with table structures...
December 14, 2021 at 6:20 pm
Different ways to achieve it. Depends on number of employees and its role under different managers with their start date.
Try this:
WITH cte1
AS
(SELECT
...
December 10, 2021 at 1:38 am
In SSIS, on the data flow, check the properties, and set the ValidateExternalMetadata property of a data flow component, make it False so that it continues with the execution of...
September 29, 2021 at 8:27 pm
check the following link(s) if it helps:
1) https://michaeljswart.com/2012/05/t-sql-merge-statement-syntax-generator/
2) https://www.pigeonsql.com/single-post/Dynamic-SQL-Merge-Script-for-Generate-Merge-statement
CDC would have been better as there are only 4 operation code to find which rows are altered...
September 27, 2021 at 11:12 pm
Do you have a machine in Azure, can you ping from on-premise to check Azure network?
use PSPING to test the above to ensure that the VPN tunnel is used instead...
September 5, 2020 at 9:07 pm
In the remote query, check the quotes around the name column are these double-quotes or single?
What happens if you add order by clause to the above queries?
September 5, 2020 at 8:46 pm
I would advise you to perform the following steps in a test environment before applying to production.
3rd replica
------------
Stop data movement to 3rd replica
Remove the 3rd replica from the AG and...
September 5, 2020 at 8:29 pm
Hi Srinivas,
This could be because of different master keys on Server A(source) and Server B (target).
You have to create a master key on the target instance that you have restored...
September 5, 2020 at 7:45 pm
jarodjp42 - Monday, March 26, 2018 1:00 PM% of total price for each customer.
@jarodjp42:
Because you asked for % (percentage), that...
June 10, 2018 at 11:36 pm
Apologies... my bad. I took it to some other direction. Thanks for correcting me Sue.
May 3, 2018 at 6:39 am
This is where we come across job responsibilities or separation of duties. Only few selected individuals or a group in an organization must have the ability to change the...
May 2, 2018 at 2:53 am
TSX is
SQL2 and SQL3
created a...
May 2, 2018 at 2:25 am
Looks to me like an Excel Driver Issue, this might need 64 bit drivers. Ensure that excel data source settings are correct in SQL Agent Job.
or
Try running the...
April 21, 2018 at 5:44 pm
Use
--------ORDER BY b.CmpntNum
Or
ORDER BY Component
April 14, 2018 at 4:49 pm
Viewing 15 posts - 1 through 15 (of 25 total)