Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,171 through 4,185 (of 59,067 total)

Reply To: Change ANSI_NULLs option for a table

MMartin1 wrote:
Maybe the best thing is to leave out the filter part of the index to avoid this whole situation.
Unfortunately, I have to agree with 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 19, 2021 at 3:23 am

#3965178
Reply To: Count based on condition

This is pretty simple but you've been asked to provide readily consumable data before and it would mighty nice if you'd start to help us help you.
Without such readily consumable...
--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 19, 2021 at 3:01 am

#3965174
Reply To: sql ocde picking last date of month value

kaj wrote:
Windler wrote:
The EOMONTH() function returns the last day of the month of a specified date, with an optional offset. The EOMONTH() function accepts two arguments: start_date is a date expression that evaluates to a date. The EOMONTH() function returns the last day...
--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 18, 2021 at 7:43 pm

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

rajemessage 14195 wrote:
we tried to upgrade to 2019, but unfortunately, MS has put some restrictions like they have converted scalar functions to inline function by default and that throws an error,...
--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 18, 2021 at 7:38 pm

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

David Burrows wrote:
Jo Pattyn wrote:
How's everybody? Wishing a good 2022
Same to you and everyone here 🙂
For me, 2022 brings change, after 38 years in this job, it officially ends 31st March 2022...
--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 7:43 pm

#3964914
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

Viewing 15 posts - 4,171 through 4,185 (of 59,067 total)