Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,441 through 1,455 (of 59,082 total)

Reply To: Query to Insert Data Based on CustomerID from one table to another

If you'd take the time to convert the data for BaseTable_A into a "Readily Consumable" format (please see the article at the first link in my signature line below 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)

May 23, 2023 at 5:01 pm

#4195747
Reply To: Replace url with <a href="url">url</a> from a string using SQL

StillAlive wrote:
Thanks People! I was running out of time, so I had to drop the idea to do it using SQL.
What did you use instead?
--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)

May 23, 2023 at 3:00 am

#4195234
Reply To: Empathetic Design

I find that a serious percentage of front-ends qualify as "empathetic - em" design. For example, long gone are the days when the menu remained visible when scrolling down or...
--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)

May 22, 2023 at 6:03 pm

#4195001
Reply To: Simple script to de-identify data

Heh... "Just because you can do something in Python, doesn't mean you should". 😉
--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)

May 21, 2023 at 6:53 pm

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

Dennis Jensen wrote:
Okay if I understood your last post I will say -- (1) I do not make sarcastic comments without including an 😉 to let you know I am not...
--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)

May 21, 2023 at 6:12 pm

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

Dennis Jensen wrote:
No Jeff Moden I did not state that SQL was a dinosaur at all, I think I basically referred to others doing so with dynotopic languages such as Cobol....
--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)

May 21, 2023 at 1:06 am

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

As you said, I'm making sure of clarity. 🙂
With that, I'll say that you've just repeated yourself. You're insisting that SQL is a dinosaur here and the its technology is...
--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)

May 20, 2023 at 3:13 am

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

Dennis Jensen wrote:
Jeff Moden wrote:
Heh... there ya go again. 😉 You reworded it but your basically saying the same thing. 😉
Uh yes that was the point to reword what I had intially...
--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)

May 19, 2023 at 4:33 am

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

Deleting the duplicate post I made because of the "first post" syndrome. 🙁

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

May 19, 2023 at 3:52 am

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

Deleting the duplicate post I made because of the "first post" syndrome.
--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)

May 19, 2023 at 3:50 am

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

Dennis Jensen wrote:
Jeff Moden I did try to outline that in context. I was saying I have actually seen this before with a dynotopic language (aka Cobol) where the powers to...
--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)

May 19, 2023 at 3:48 am

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

I'm up to TimeStamp 00:40:00 in 'tube that Steve Collins just posted. The speaker, Adam Ralph, is doing a great job (well, except for using a laser pointer to point...
--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)

May 19, 2023 at 3:46 am

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

Dennis Jensen wrote:
Yes, why would anyone want to use that complicated futuristic hover car when we can spend 10 times the amount of resources to build a better dinosaur. I mean,...
--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)

May 19, 2023 at 2:21 am

#4192711
Reply To: How to Improve Database Design to Speed Up SQL Queries

MMartin1 wrote:
You have to have them fairly orderly because a sufficietly fragmented index is of no use.
I have to be a bit contrary there...
The fragmentation of an index means nothing...
--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)

May 19, 2023 at 2:04 am

#4192709
Reply To: How to capture sqlscript from a specific computer while using sqlserver profiler

892717952 wrote:
Jeffrey Williams wrote:
Or you need to include that information in the calls to SQL Server - as in a parameter to a stored procedure (e.g. User, UserID, etc.)
yes , this...
--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)

May 19, 2023 at 1:49 am

#4192693

Viewing 15 posts - 1,441 through 1,455 (of 59,082 total)