Jeff Moden

Forum Replies Created

Viewing 15 posts - 226 through 240 (of 59,099 total)

Reply To: Temp Tables not clearing

It's better to NOT drop TempTables. The "schema" can be reused even though they go out of scope and "disappear" at the end of each session.
--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)

January 16, 2025 at 10:06 pm

#4517162
Reply To: Help with parent/child query please

This is a parent/child list. There's a whole lot more that can be done with it if it's recognized for what it can do including but not limited to "Nest...
--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)

January 16, 2025 at 9:32 pm

#4517158
Reply To: How to Avoid Incorrect Results When Using T-SQL Trigonometric Functions in SQL Server

Wouldn't it be nice if Microsoft finally figured out that there's been math co-processors built into CPU chips since the mid-'90's??? Even the decimal datatype had issues with resetting the...
--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)

January 13, 2025 at 5:24 pm

#4514872
Reply To: Using ROW_NUMBER() to increment every time a value occurs

Just so people can play if they want, here's all the code I played with.
My findings are that if you can have a Clustered Index on the RowNumber column of...
--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)

January 12, 2025 at 1:52 am

#4514011
Reply To: Using ROW_NUMBER() to increment every time a value occurs

Chrissy321 wrote:
Thanks Jeff, Here is more realistic data. Won't work when there are more than 5 rows.
Ah... My apologies, Chrissy. When you said you could "guarantee the order", I mistook...
--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)

January 12, 2025 at 12:32 am

#4514002
Reply To: Using ROW_NUMBER() to increment every time a value occurs

ScottPletcher wrote:
so many people here obsess over every microsecond
It's frequently obvious when code is not written by such folks when the OP comes back in a few months saying 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)

January 11, 2025 at 6:29 pm

#4513900
Reply To: SQL Server Data...is it encrypted?

My suggestion is that you need to stop taking chances and hire a consultant to set you up correctly because it sounds like you're not just storing personal data (which...
--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)

January 11, 2025 at 5:59 pm

#4513892
Reply To: SQL Server Setup

JP789 wrote:
Is there anything else I'm missing that I should consider?
Yes. It sounds to me that you're using the "Developer" Edisition to do "production work"... which goes against the licensing...
--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)

January 11, 2025 at 5:56 pm

#4513891
Reply To: Using ROW_NUMBER() to increment every time a value occurs

It would be easier if the first row were numbered "0" instead of 1 so that we could use modulo all by itself to do this but, it can still...
--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)

January 10, 2025 at 10:32 pm

#4513530
Reply To: Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets

AnzioBake wrote:
@jeffmoden I have not spent much time on SSC for a good few years. Searching for something else, I came across this article (and the follow up) written by...
--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)

January 10, 2025 at 4:36 pm

#4513338
Reply To: Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets

Y.B. wrote:
isaac.arellano wrote:
Hi, excellent post, I have taken it and put it into practice, and it works very well for me to redo the whole nested set, But I want...
--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)

January 10, 2025 at 4:34 pm

#4513335
Reply To: Count of Total Appointments within 30 days of each Appointment Date

Just to ask the question, I haven't tested any of the solutions and so this question is directed at Reh23 ...
Do any of the solutions, so far, do what you...
--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)

January 10, 2025 at 4:18 pm

#4513324
Reply To: Count of Total Appointments within 30 days of each Appointment Date

Jeff Moden wrote:
First of all, please stop posting graphics for the test data. See the article at the first link in my signature line below for why and one method for...
--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)

January 10, 2025 at 4:17 pm

#4513323
Reply To: Count of Total Appointments within 30 days of each Appointment Date

Reh23 wrote:
Thanks Jeff. Its SQL Server 2017.
Your other post is on an SQL Server 2022 forum.
--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)

January 10, 2025 at 4:13 pm

#4513322
Reply To: The Lesser Used Functions

Just to be sure, I would never obfuscate numeric data. If it's worth protecting, it's worth being properly encrypted.

--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)

January 10, 2025 at 4:11 pm

#4513321

Viewing 15 posts - 226 through 240 (of 59,099 total)