Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,586 through 3,600 (of 59,098 total)

Reply To: How to add background color of row based to existing SP/query

Phil Parkin wrote:
Jeff, that's a rather useful link, thanks for posting.
Thanks for the feedback on that, Phil. I LOVE that site. T It also has one of the better beginner SQL...
--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 2, 2022 at 7:12 pm

#4025632
Reply To: Parse txt file

Bruin wrote:
Can't seem to get original file to process gets errors listed above.. sample file will process.
Any thoughts or suggestions?
Thanks again

Instead of making us go back an unknown number 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)

May 2, 2022 at 6:02 pm

#4025595
Reply To: How to add background color of row based to existing SP/query

I try to avoid the RGB notation because it makes troubleshooting a whole lot more difficult. If you go to the following link...
https://www.w3schools.com/tags/ref_colornames.asp
... and do a search for the #90EE90...
--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 2, 2022 at 6:00 pm

#4025593
Reply To: Parse txt file

Ok... no actual data. Moving on. Good luck. 😉
--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)

April 30, 2022 at 4:48 am

#4024590
Reply To: Getting rid of integers from the EmailAddress

How about it @Smash125? Why do you need this top be done?
--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)

April 29, 2022 at 11:17 pm

#4024474
Reply To: Getting rid of integers from the EmailAddress

Again, I'd like to know why we're perverting email addresses in such a fashion. There has to be a reason.
--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)

April 29, 2022 at 7:49 pm

#4024407
Reply To: Output of Pivot table in temp table
jsshivalik wrote:
Hi Thom
First i get data saved in Temp table like below
```
CodeNameQuantityDscription
32Rohan1        Item 1
32Rohan2      ...
```
--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)
April 29, 2022 at 7:44 pm

#4024406
Reply To: Parse txt file

Some real or better-simulated data for the file is absolutely necessary for us to help you here or the answer will be either to create a BCP format file 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)

April 29, 2022 at 5:55 pm

#4024371
Reply To: Date strange Behaviour

To go along with what Scott stated, when is the last time you rebuilt statistics on the date column? How many rows have been changed according to the modification_counter 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)

April 29, 2022 at 5:50 pm

#4024370
Reply To: Getting rid of integers from the EmailAddress

Smash125 wrote:
How to remove integers from the Email Id
aaron0@adventure-works.com
Please guide
WHY???? It seems to me that you're removing a necessary part of a correct email address. 🙁
--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)

April 29, 2022 at 5:02 pm

#4024337
Reply To: Script SQLCMD to create DB with a variable: How to set it up?

I have the same concerns about a PoSh script as I do with an SQLCMD script.
--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)

April 29, 2022 at 4:56 pm

#4024335
Reply To: Is Developer required a writing skills to become a expert?

I'll say, Absolutely. It's a very necessary form of communication no matter what you do in life but especially in the world of IT. And, it's not limited to just...
--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)

April 28, 2022 at 10:47 pm

#4023933
Reply To: The Craziness of Code

I REALLY enjoyed the "Programming Sucks" article you provided a link to, Steve. The funniest part about it is that it's all true! 😀
Shifting gears a bit, thank you 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)

April 28, 2022 at 10:15 pm

#4023932
Reply To: My calculation with a CASE statement isn\'t working

Melanie Peterson wrote:
Oh bless you, Scott Pletcher, this works wonderfully.
I have a question just out of curiosity... what are you going to do with the zeroes once you have the correct...
--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)

April 28, 2022 at 4:16 am

#4023435
Reply To: Which command will using to delete all rows from table truncate or delete ?

There are actually several massive differences between Truncate and Delete. You can read about most of them simply by looking up the commands and reading about them.
One not so well...
--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)

April 28, 2022 at 3:45 am

#4023413

Viewing 15 posts - 3,586 through 3,600 (of 59,098 total)