Heh... mine has started off with a bit of a "well that sucks" factor.  Whole new time-keeping system where they want me to categorize virtually every aspect of what I...

Doing good, Jo.  Thanks for asking.

Same to you and yours.

BUT even if you DO get it on your screen, there are a LOT of typos in it which makes it impossible to copy-paste into SSMS UNLESS...

You are selecting from [@IND_ORLS] & joining [@IND_RLS1], but there are no table-valued-parameters w/ those names and no table types of those names declared & populated in the procedure. ...

Your findings don't appear to match your code where you say...

SET @Where = @Where + ' T0.U_DATE BETWEEN ''2021-03-01'' and ''2021-03-31'' '

I...

So, do you see anything at all in the printed SQL that could be causing a problem?  Like maybe in the FROM clause? and the JOIN table that follows that?

Once you assign an alias to a table, that alias is the only valid way to reference that table.  That's not a matter of preference or opinion.  It's a...

There is no question in my mind that the form of updating an alias and having a FROM clause is easier in a lot of respects.  I even said that...

You have to understand... I don't actually care what the question was.  This isn't stack overflow.  I was teaching about the proper forms and you don't need a FROM clause...

There is no need for the FROM clause in the first example.

I also prefer the second example because it's easy to change it to a SELECT to see...

Thank you for the help....

Here is what I finally came up with

DECLARE @startDate DATETIME;

DECLARE @endDate DATETIME;

--DECLARE @dateDiff INT;

SET @startDate = '2018-08-12';

SET @endDate = '2018-08-14';

SELECT TOP 10 [Last Name] AS...

There's also something crazy going on with this forum.  The timestamp on the original post is for today at 8:15 PM, which hasn't happened here yet.  I thought these things...

There is no need for the FROM clause in the first example.

I also prefer the second example because it's easy to change it to a SELECT to see what it's...

ALter PROCEDURE [dbo].[test] @frDate date, @toDate date, @VCode nvarchar(15) = null, @VName nvarchar(100) = null, @CCode nvarchar(15) = null, @CName nvarchar(100) = null, @CGroup nvarchar(15) = null as begin...

It's been a looooong time since I've had to ask for sql help...lol. I've added an attachement with some sample data. Sorry about that and thank you for taking...