index

anonymous@undisclosed.example.com (Anonymous) — Tue, 20 Aug 2019 09:32:44 +0000

SQL Indexing SQL Query should use index seeks and not index scans. * * You can select the 'Display Estimated Execution Plan' (4 to the right of the '! Execute' button). * You can select 'Include Actual Execution Plan' (7 to the left of the '! Execute' button), so see exactly how the SQL was run, after you execute it.

pivot

anonymous@undisclosed.example.com (Anonymous) — Thu, 22 Sep 2022 12:21:28 +0000

SQL Pivots Reference: An Example The First Step is to get the Table in the format you need - so you can pivot it. Our Original Table SELECT CollectionID = CC.CollectionID, TransferCallType = TransferCallType, SUM(ISNULL(CTRT.RouterCallsQNow, 0)) AS CallsQueuedNow FROM dbo.Call_Type_Real_Time(nolock) AS CTRT INNER JOIN dbo.v_Collection_Calltypes AS CC WITH (nolock) ON CTRT.CallTypeID = CC.CallTypeID GRO…

orourke.tv - tech-notes:sql

index

pivot