To add to what ratbak and Grant have stated, the other thing that paying attention to the order of the criteria in the WHERE helps with troubleshooting.  Yeah... I know...

No: "Scalar functions must be invoked by using at least the two-part name of the function (<schema>.<function>)"

Why are you even trying to work around this? You should preface...

@thisisfutile

I'm truly humbled by your thoughtful comments and the references to a couple of articles.  I really appreciate the feedback and... I'm glad I could make you laugh! 😀  I'm...

How to loop the data based on start and end dates below?

Declare @StartDate Datetime Declare @EndDate Datetime

Select @StartDate = '20220611' SET @EndDate = GETDATE()

WHILE @StartDate < = @EndDate BEGIN...

Thanks for the feedback Steve.

@mcfarlandparkway

Did that work for you?

Afaik this actually produces the desired output.  Should work with SQL 2014.  It uses the ordinal splitter DelimitedSplit8K_Lead.  The query: splits the input string on '_' underscore, finds the...

At least it produces the correct output when using...

Example - When i run the query today 7/13/2022

I am looking for start and end dates to be June 11, 2022 that is saturday to July 9, 2022 saturday....

@dba-2.k ,

Look again. None of the code posted actually produces the desired output that you posted.  "Must look eye".

With the understanding that I've not done any deep analysis on any of the code posted and going only on what I've seen in the past, the nested...

I don't know much about your issue but... are you saying that it won't even let you build a linked server and does your linked server cite a specific file?

In...

Awesome feedback, Tom.  Thank you both for the read and the feedback.  I really appreciate it.

Thanks for the feedback, especially on the experiences you've had in the past and especially about the "Middle of Week" thing.

Of course, many thanks for the catch on the typo. ...

Heh... I get that same response (none) to that question a whole lot. 😀