Your fingers might get considerably shorter, but you could always add a lot of these ...

IF UPDATE (colName )
BEGIN
  -- Add your column to DSQL ...
END;

Something like this

DECLARE @Year int = 2022;

WITH cteMonthStarts AS (
  SELECT FebStart =  DATEADD(mm, (@year-1900)*12 +1, 0)
       , AugStart...

You are creating a "Catch-All" query.  The pattern used in your WHERE clause is non-sargeable, forcing SQL to do a full scan.

With the following pattern,

AND (ISNULL(@email,'') =...

Assuming that all of the other 20 subqueries are based on the same pattern in tblPolSpec, you will probably get better performance if you use a CROSS-TAB query like this

My code works with the data that you provided.  I cant test against the unknown

Simply include the...

Setting Consumable data

IF OBJECT_ID(N'tempdb..#DocData', N'U') IS NOT NULL DROP TABLE #DocData;

CREATE TABLE #DocData (
    RefDocNum   char(10)      NOT...

• This reply was modified 2 years, 3 months ago by  DesNorton.

Spam incoming .....

I'm having an issue on 2016 and 2017... If you have 2019 or any version prior to 2016, would you run the following code, please, and let me know...

I dont have access to SQL22, but looking at GREATEST/LEAST, I assume that using them in a WHERE clause will make the query NON-SARGEABLE.

SELECT P.Name, P.SellStartDate, P.DiscontinuedDate,...

Is it possible use case more than once in an expression? I have a query tha calculates the cost of insurence. but i need to see if i can...

What is the error?

Take a look at this post

http://stackoverflow.com/questions/10404348/sql-server-dynamic-pivot-query

Your sample data did not contain any duplicate companies.

To cater for duplicates, wrap each CASE ... END statement in a MAX(CASE ... END)

and add a GROUP BY src.CoName

This SQL will achieve the required results

SELECT Company = src.CoName
    , aaa = CASE WHEN src.Class = 'aaa' THEN 'Yes' ELSE '' END
 ...