Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,981 through 1,995 (of 59,067 total)

Reply To: How to append data to the previous row

David Burrows wrote:
Jeff Moden wrote:
As I said on another thread, I've never seen an "automatic bullshit grinder" before. 😀
Thats because you’ve not met me 😳
BWAAA-HAAA-HAAA!!! You're on my bucket list, Mr. Burrows!
--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)

February 7, 2023 at 11:50 pm

#4146789
Reply To: bcp is giving SQL State = 1000 Native error =0 SQL Server

surafeb7 wrote:
Thanks, Jeff, for your reply. The value will pass as a parameter, but the password will register as a **** in the log.
You don't understand that it's not 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)

February 7, 2023 at 11:48 pm

#4146788
Reply To: How to append data to the previous row

To me, it's really not surprising at how really bad it is. And to give it an authoritative "expert" tone on these code questions is one of the worst ideas...
--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)

February 7, 2023 at 11:42 pm

#4146786
Reply To: How to append data to the previous row

Jonathan AC Roberts wrote:
They have thumbs Up/Down buttons by each answer that you can click and leave feedback, which they supposedly look at in the aim of improving the system.
There are three...
--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)

February 7, 2023 at 7:59 pm

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

kaj wrote:
And now we're just waiting for Google's Bard chatbot to go to GA. Time will tell who is the more truthful chatterbox.
But Bard will probably not do any better,...
--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)

February 7, 2023 at 7:51 pm

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

And, I hit the "first post on the next page" problem with that so posting another so that it'll actually be visible.
--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)

February 7, 2023 at 7:28 pm

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

Worse than that, it apparently knows what is meant by "temp" table but still couldn't tie it together in the previous question. Or, if it did, it's seriously incorrect. Here's...
--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)

February 7, 2023 at 7:26 pm

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

kaj wrote:
Jeff Moden wrote:
It apparently cannot make the distinction between "temp tables" and "temporary tables". It's seriously incorrect for what most of us refer to as "temp tables" and seriously...
--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)

February 7, 2023 at 6:32 pm

#4146698
Reply To: Can an INSERT statement block SELECT statements?

Thom A wrote:
Jeff Moden wrote:
Thom A wrote:
Just to prove Grant's statement a little more, here's a quick demo.
As a bit of a sidebar, what did you use as a screen recorder?
On Windows, ShareX....
--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)

February 7, 2023 at 5:40 pm

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

That question is further proof that ChatGPT has been trained by people that don't have the correct knowledge in such matters. (and yes... I'm trying to soften my tone, lately,...
--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)

February 7, 2023 at 5:20 pm

#4146668
Reply To: Can an INSERT statement block SELECT statements?

Thom A wrote:
Just to prove Grant's statement a little more, here's a quick demo.
As a bit of a sidebar, what did you use as a screen recorder?
--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)

February 7, 2023 at 4:56 pm

#4146656
Reply To: Can an INSERT statement block SELECT statements?

Leticiagreen wrote:
No, an INSERT statement does not block SELECT statements. SELECT statements can run simultaneously with INSERT statements in most databases.
That's seriously true in Oracle (and some other databases) 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)

February 7, 2023 at 4:53 pm

#4146653
Reply To: bcp is giving SQL State = 1000 Native error =0 SQL Server

Of much larger concern, why on this good Green Earth would you even consider writing a command, any command, that has a user name and password in clear text? 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)

February 7, 2023 at 4:49 pm

#4146650
Reply To: Do entry-level cloud positions exist?

I think Frederico may have been correct about the nature of this thread. The second shoe dropped in the form of spam and the op has made no followup appearance.
--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)

February 7, 2023 at 4:45 pm

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

On that subject, I always leave the DROP TABLE IF EXISTS code in the proc but commented out. That way I don't have to add it back in when 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)

February 7, 2023 at 4:43 pm

#4146647

Viewing 15 posts - 1,981 through 1,995 (of 59,067 total)