Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,371 through 2,385 (of 59,086 total)

Reply To: Are the posted questions getting worse?

Dupe post so the forum software would actually let people see this page. 🙁

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

November 30, 2022 at 6:04 am

#4119868
Reply To: Are the posted questions getting worse?
DesNorton wrote:
Your fingers might get considerably shorter, but you could always add a lot of these ...
```
IF UPDATE (colName )
BEGIN
  -- Add your column to DSQL...
```
--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)
November 30, 2022 at 6:02 am

#4119867
Reply To: Find Guest user access level in all databases

Daniel Adeniji-180202 wrote:
Jeff Moden:-
Yes, that was my exact test.
I have attached a test sql code.
Jeff, thanks for being a real one.
Sacrificing your soul to make sure that everyone gets a lot...
--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)

November 30, 2022 at 2:59 am

#4119807
Reply To: Find Guest user access level in all databases

@MannySingh... despite what was found on script 2, thanks for stepping up to the plate to teach.
--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)

November 30, 2022 at 2:53 am

#4119806
Reply To: Backup progress

If it were me, I'd get on the phone with Veritas .
--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)

November 30, 2022 at 1:48 am

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

Thanks, Steve.
It's a tougher question than I thought.
All I want to do is add an Instead Of Update trigger to a table, do a small task, and then do an...
--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)

November 30, 2022 at 1:43 am

#4119787
Reply To: Cloud First Software

From the article:
"The last few years, however, it seems that ASD is getting features first, which then slip into a release that I can download and run locally."
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)

November 30, 2022 at 12:58 am

#4119776
Reply To: Get Date Monday Show results for weekend and then else 24 hours

@dmcmorriswelcom-co-uk ,
Are you all set now?
--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)

November 29, 2022 at 10:57 pm

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

Steve Collins wrote:
Jeff Moden wrote:
SGAB, does any one have a decent example of an Instead Of Update trigger that will handle more than one bloody row at a time and also ONLY...
--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)

November 29, 2022 at 10:50 pm

#4119707
Reply To: should atemp table be used from looping even when single table is used in a loop

rajemessage 14195 wrote:
hi,
We have a master table, single table which I loop thought, to do some task, the master table is very rarely changed.
So while looping through , I put 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)

November 29, 2022 at 10:43 pm

#4119706
Reply To: Find Guest user access level in all databases
Daniel Adeniji-180202 wrote:
Manny:-
I do not think example 2 actually works.
Here is your SQL Statement for Example 2:-
```
Declare @holdname sysname
Declare getdbname cursor for
Select name from master.sys.databases order by name
Open...
```
--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)
November 29, 2022 at 10:33 pm

#4119705
Reply To: Copy backup to not destroy backupchain

K. I was just checking. To paraphrase "Red Green", "We're all in this together and I'm pullin' for ya."
--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)

November 29, 2022 at 10:13 pm

#4119698
Reply To: DateTime Format Conversion AM/PM

HeftSteady wrote:
Your solution did not convert to 12 hour or include AM PM designation.
Ha, I know you suggested against using FORMAT but that is what I ended up doing .
FORMAT(CAST(field_here...
--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)

November 29, 2022 at 10:09 pm

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

SGAB, does any one have a decent example of an Instead Of Update trigger that will handle more than one bloody row at a time and also ONLY update 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)

November 29, 2022 at 4:14 am

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

Ok... they've fixed the notifications issue and it appears have been doing things correctly for a while now. Does anyone have any more problems with that issue?
--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)

November 29, 2022 at 4:10 am

#4119265

Viewing 15 posts - 2,371 through 2,385 (of 59,086 total)