Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,041 through 5,055 (of 59,072 total)

Reply To: create total record in html email

Bruin wrote:
@jeff When I ran your code and seeing what @sql has in it, that's exactly what I was trying to achieve. How to you get that into an email...
--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)

June 25, 2021 at 2:52 am

#3900273
Reply To: create total record in html email

Bruin wrote:
Thanks to you BOTH for taking the time posting the code, lot to digest...
I just have a question, would it be possible to also include a row total 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)

June 25, 2021 at 2:49 am

#3900270
Reply To: Doing a select with dynamic columns

jcelko212 32090 wrote:
>> I have a query that produce a table where I have a list of columns. Then I choose check what columns are on the table excluding the column...
--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)

June 24, 2021 at 11:01 pm

#3900226
Reply To: about the concern about sp_updatestats

892717952 wrote:
Do I still need to run sp_updatestats if I execute DBCC DBREINDEX(tablename) for tables in database?
I think you should still use to run sp_updatestats as dbcc dbreindex doesn't 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)

June 24, 2021 at 10:57 pm

#3900225
Reply To: create total record in html email

First, here's a shorter way to provide the data in a readily consumable format. It's also better to do it in a temp table than a real table in most...
--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)

June 24, 2021 at 10:08 pm

#3900221
Reply To: TSV

Jeffrey Williams wrote:
@JeffModen - that would be great, except most don't even know what character 7 let alone 28 through 31 are or how they were used. Or why we used...
--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)

June 24, 2021 at 7:34 pm

#3900176
Reply To: Deleting folder on a drive

I figured. You can tell that's "never" happened to me before, right? 😀 Thanks for the feedback. Long live the command line! 😀

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

June 24, 2021 at 6:48 pm

#3900159
Reply To: TSV

It's a funny thing how people crab about the way Excel handles data that has a comma in a "field". It actually works exactly the way the CSV standards say...
--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)

June 23, 2021 at 8:08 pm

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

david.edwards 76768 wrote:
I've registered for the EightKB event, so I can tune in to Jeff's session. Had the confirmation email but no details on how to join. Are these sent closer...
--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)

June 23, 2021 at 7:44 pm

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

Heh... that reminds me of an old poem about denial...
Roses are Red,
Violets are Blue,
Some Poems Rhyme,
But this one don't.
😀
--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)

June 23, 2021 at 7:43 pm

#3899811
Reply To: Deleting folder on a drive

How are you checking that the folder still exists? I've been "caught" more than once by Windows Explorer still displaying the folder until I did a refresh.

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

June 23, 2021 at 6:53 pm

#3899794
Reply To: Powershell SFTP script not correctly pulling file

To be honest, it sounds to me that the file at the source is damaged.
--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)

June 23, 2021 at 6:36 pm

#3899792
Reply To: EightKB... I'm presenting! Bring your water-cooled helmet! :D

Thanks for the feedback, Tom. I love to teach and I really love teaching this one. It's a shame we can't do these in person because I'd love to see...
--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)

June 22, 2021 at 11:48 pm

#3899487
Reply To: Microsoft.ACE.OLEDB.16.0 Provider Is Not Registered

Maybe something has changed but, in the past, it wouldn't allow you (unless you knew the "silent" trick) to install the 64 bit version if 32 bit apps were on...
--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)

June 22, 2021 at 2:38 pm

#3899351
Reply To: Setting up and using dbt (Data Build Tool) with SQL Server

If you're serious, then instead of posting spam, contact the web master for this site.
--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)

June 22, 2021 at 2:34 pm

#3899349

Viewing 15 posts - 5,041 through 5,055 (of 59,072 total)