Something like this ...

WITH cteWindows AS (
  SELECT c.MonthStart
       , windowStart = DATEADD(mm, -2, c.MonthStart)
     ...

Something like this ...

DECLARE @StartOfCurrentWindow date = '2024-10-01';
DECLARE @StartOfNextWindow    date = DATEADD(MONTH, 3, @StartOfCurrentWindow);

WITH cteBase AS (
  SELECT c.MonthStart
    ...

She did have a shedload of LIKEs.  The "upgrade" on the site years ago hasn't...

Congratulations @jeff-moden

Finally overtook the high priestess on the SSC overall leaderboard.

Come on @jeff-moden.  One more post ....

SELECT DISTINCT tp.client_id AS Member_ID
     , tp.PaidDate AS Paid_Date
     , tp.DOS
FROM #ins_temp tp
WHERE (@dateChoice = 'Paid_Date' and tp.PaidDate...

You could use dynamic SQL

DECLARE @SQL nvarchar(MAX);

SELECT @SQL = N'
SELECT  DISTINCT
        Member_ID = tp.client_id
     ...

This is a similar query that might perform differently.  You need to test

SELECT  i.ItemID
      , i.ItemName
     ...

It is difficult to design any queries without knowing anything about your tables and their indexes.

That said, this might help.

SELECT i.ItemID
     , i.ItemName
...

You could do something like this

SELECT src.AssessmentCode, src.AssessmentDescriptio, m.Mark
FROM YourSchema.YourTable AS src
CROSS JOIN (VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10)) AS m(Mark)

Based on your provided sample data, this query will produce the correct result.

WITH cteCrossTab AS (
  /* Use a Cross-Tab query to get the data in...

Based on your provided sample data, this query will produce the correct result.

WITH cteBase AS (
  SELECT t0.*, rn = ROW_NUMBER() OVER (PARTITION BY t0.uniqueid, t0.[level]...

• This reply was modified 1 month, 2 weeks ago by  DesNorton.

Without test data we are just guessing.

Maybe this will do the trick

DECLARE @SearchDate date = CONVERT(date, '12/29/2024', 101);

SELECT *
FROM DueDates
WHERE CONVERT(date, textDate , 1) > @SearchDate
ORDER BY...

Maybe your "date" needs quotes

CONVERT(date, textDate , 1) > CONVERT(date, 'mm/dd/yy', 1)

You can convert it to a date/datetime with

CONVERT(date, '12/31/24', 1)

https://learn.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-ver16