That's just the list of columns from the cross apply "x(C)", you can...

So it's for staging tables on your database, not your application tables?

SELECT CONCAT('
SELECT ',x.c, '
  FROM ',QUOTENAME(t.TABLE_SCHEMA), '.', QUOTENAME(t.TABLE_NAME),'
 GROUP BY ', x.c, '
HAVING COUNT(*) > 1;')
  FROM INFORMATION_SCHEMA.TABLES t
 CROSS APPLY (VALUES(STUFF((SELECT ',' + QUOTENAME(c.COLUMN_NAME)
...

Hi, I have a TVF that pulls column details from sys.tables so that it can produce some dynamic sql to generate a hashbyte.

This needs to be dynamic as it...

Wouldn't it be a hoot if the optimizer fooled everyone?  That IS the nature of CTEs.  No one will actually...

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 6 years, 8 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?