An alternative solution

;WITH cte AS
(
    SELECT s.Teams, s.Category, SUM(s.Sales) Sales
      FROM dbo.Sales s
    ...

An alternative solution

;WITH cte AS
(
    SELECT s.Teams, s.Category, SUM(s.Sales) Sales
      FROM dbo.Sales s
     GROUP BY...

• This reply was modified 5 years, 9 months ago by Jonathan AC Roberts. Reason: query was wrong!

There are CRM services that you only pay for how much you use and are accessed via a web-services, so there is nothing to install or write and you can...

You have:

where d.SalesOrg_CustomerWS_ID = f.Retailing_Dealer_ID

in the WHERE clause which is comparing the left joined column d.SalesOrg_CustomerWS_ID to a column.

So it is the same as having an INNER...

Is the scope of this work as follows?

<li style="list-style-type: none;">

1. Build a SQL Server database which matches your existing database
2. Migrate existing data to new database
3. Replicate existing...

For your example you would be much better off, in terms of performance, by having an update followed by an insert:

UPDATE p 
 ...

For your example you would be much better off, in terms of performance, by having an update followed by an insert:

UPDATE p 
   SET p.rate...

Have you looked at what objects are using the disk space or how much free space there is on the datafile?

If you right click on the database in the explorer...

SELECT dest.TEXT AS [Query],
deqs.execution_count [Count],
deqs.last_execution_time AS [Time]
FROM sys.dm_exec_query_stats AS deqs
CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest
ORDER BY deqs.last_execution_time DESC

https://blog.sqlauthority.com/2016/09/04/find-recent-executed-queries-sql-server-interview-question-week-086/

Maybe some of those AND's should be OR's?

Do you mean you want to have all the PST values for each...

You will find you get much better performance if you split the merge into two separate statements (an update followed by an insert).

Performance Tip: The conditional behavior described for the MERGE...

Empty file by migrating the data to other files in the same filegroup

Migrate all data from the specified file. This option allows the file to be dropped using the ALTER...

If you are worried about shrinking the datafile then the standard advice is to create a new datafile and migrate the data into it.

It looks like the entire program could be changed to be a single SQL statement. If you are using SQL Server 2012 or higher you could use the LAG function....