So, although my prev code produced the correct results, it was clunky at best. Here is a cleaned up version of the code

CREATE FUNCTION dbo.MonthStartEnd( @DateInMonth...

Finding this a bit amusing,  "The criteria is that if the 1st of the Month is a Monday then use that Date otherwise use the last Monday of the previous...

This should do, short and simple 😉 😎

USE TEEST;
GO
SET NOCOUNT ON;
GO
DECLARE @MYDATE DATE = '20190101';
;WITH TDATES AS 
(
SELECT DATEFROMPARTS(
      ...

• This reply was modified 6 years, 4 months ago by Eirikur Eiriksson.

Hello, What is a good design to store unit of measures ? We have a measure dimension with all the measures and we are building a scorecard fact table...

This should do, short and simple 😉

😎

USE TEEST;
GO
SET NOCOUNT ON;
GO
DECLARE @MYDATE DATE = '20190101';
;WITH TDATES AS 
(
SELECT DATEFROMPARTS(
       DATEPART(YEAR,@MYDATE)
  ...

Your post is a little baffling, no relation to the OP!

😎

Further, for any...

This to me, just like Jason said earlier, looks like a perfect case for a set based trigger

😎

Further...

Good stuff and thanks for the feedback!

😎

Has the storage team provided any evidence on PURE STORAGE ARRAY  efficiency and edge over the native SQL Server data compression? Would be very...

Depending on the table structure and the business requirements, I would go for almost anything but a scheduled job, can you please share more details?

😎

The answer  is simple, just alter the table and set compression = NONE

😎

Quick question, have you seen any evidence supporting this claim? "Better at the job" does not necessarily mean...

That is just what you need on a Friday 😉

😎

Maybe not the best query, but here's a test. Query embedded in the --ACT section.

CREATE OR ALTER PROCEDURE tsqltests.[test calendarsales]
AS
BEGIN
    ---------------
  ...

My guess would be that the cost for parallel is set too low and the non UDF query is running with a parallel plan, the UDF version does not run...

Now you just have to make Jeff's day and ping him a message

😎

Here is a quick example

😎

USE TEEST;
GO
SET NOCOUNT ON;
DECLARE @TSTR VARCHAR(50) = '.....SSMS.....';
SELECT 
    STUFF(@TSTR,1,PATINDEX('%[^\.]%',@TSTR) - 1,'') AS TRIM_LEFT
   ,LEFT(@TSTR,(1 + DATALENGTH(@TSTR) -...