Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,201 through 4,215 (of 59,087 total)

Reply To: Error Must Declare scalar variable @frDate

@jagjitsingh,
When I run into problems like the one's you're having, I go back to the basics.
The first step is to get out of the dynamic SQL world and get some...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 17, 2021 at 4:36 pm

#3964875
Reply To: Error - Column '@IND_RLS1.U_VendCode' is invalid in the select list

@jagjitsingh,
When I run into problems like the one's you're having, I go back to the basics.
The first step is to get out of the dynamic SQL world and get some...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 17, 2021 at 4:35 pm

#3964874
Reply To: case Statement with Cte

@jagjitsingh,
When I run into problems like the one's you're having, I go back to the basics.
The first step is to get out of the dynamic SQL world and get some...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 17, 2021 at 4:35 pm

#3964873
Reply To: Ambigious Column Name U_Date

@jagjitsingh,
When I run into problems like the one's you're having, I go back to the basics.
The first step is to get out of the dynamic SQL world and get some...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 17, 2021 at 4:35 pm

#3964872
Reply To: how to make comm seprated list with control break. in sql 2012

See the following where Wayne Sheffield teaches the ropes on how to do this prior to having String_Agg() available.
https://www.sqlservercentral.com/articles/creating-a-comma-separated-list-sql-spackle
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 17, 2021 at 4:31 pm

#3964866
Reply To: sp_BlitzFirst takes too long to complete

Go look at the code itself. It getting hungup on something of yours might be an indication of something you've done seriously wrong to begin with.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 17, 2021 at 4:27 pm

#3964857
Reply To: Error - Must declare the scalar variable "@frDate"

@jagjitsingh,
When I run into problems like the one's you're having, I go back to the basics.
The first step is to get out of the dynamic SQL world and get some...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 17, 2021 at 4:21 pm

#3964855
Reply To: Are the posted questions getting worse?

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 17, 2021 at 3:47 pm

#3964847
Reply To: Are the posted questions getting worse?

Jo Pattyn wrote:
How's everybody? Wishing a good 2022
Doing good, Jo. Thanks for asking.
Same to you and yours.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 17, 2021 at 3:35 pm

#3964845
Reply To: Error - Must declare the scalar variable "@frDate"

Phil Parkin wrote:
Mr. Brian Gale wrote:
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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 17, 2021 at 3:32 pm

#3964844
Reply To: Error - Must declare the scalar variable "@frDate"

ratbak wrote:
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. ...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 17, 2021 at 3:32 pm

#3964843
Reply To: Ambigious Column Name U_Date
jagjitsingh wrote:
How i can resolve it
Thanks
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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
December 17, 2021 at 2:16 am

#3964625
Reply To: Ambigious Column Name U_Date

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?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 17, 2021 at 1:23 am

#3964614
Reply To: Update alias or update tablename when from clause is specified

ScottPletcher wrote:
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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 17, 2021 at 12:36 am

#3964609
Reply To: Update alias or update tablename when from clause is specified

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 16, 2021 at 10:34 pm

#3964586

Viewing 15 posts - 4,201 through 4,215 (of 59,087 total)