Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,131 through 2,145 (of 59,067 total)

Reply To: Ethical Hacking Tutorial

Heh... there's definitely a need for the art. Here are some folks that prove that...
https://samcurry.net/web-hackers-vs-the-auto-industry/
Spooky stuff.
--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)

January 7, 2023 at 8:07 am

#4134844
Reply To: The Cost of Employee Turnover

And then, there are things like this...
https://www.itprotoday.com/career-development/amazon-slash-more-18000-jobs-escalation-cuts
I know stuff like this happens but this smacks of poor management and "over-hiring" practices.
--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)

January 7, 2023 at 8:03 am

#4134843
Reply To: The Cost of Employee Turnover

Eddie Wuerch announced on LinkedIn that he got his notification that he'd been laid of from SalesForce when he tried to login. That's definitely NOT the way to do proper...
--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)

January 7, 2023 at 7:11 am

#4134826
Reply To: Generation of Auto Series based on logic

ScottPletcher wrote:
Nor trying to be difficult, but that just lists the values, it doesn't assign them as the table ID in the existing table, as stated in the OP.
Agreed. Do...
--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)

January 6, 2023 at 11:35 pm

#4134749
Reply To: Generation of Auto Series based on logic

In order to do what Scott suggests, you'd need to make a SEQUENCE that counts from 1 to 999 and then recycles back to 1. The formula to convert that...
--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)

January 6, 2023 at 10:53 pm

#4134717
Reply To: Generation of Auto Series based on logic
Just a tiny simplification of what Jonathan posted and it starts with the "B" series like you wanted...
```
 SELECT TOP 6500
      ...
```
--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)
January 6, 2023 at 10:32 pm

#4134714
Reply To: Parsing XML data into multiple Datasets

Aye... thanks for posting the link for that. Much appreciated.
--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)

January 6, 2023 at 5:54 pm

#4134626
Reply To: Generation of Auto Series based on logic

Jeff Moden wrote:
@ kirti ,
What do you want it to do when you go to 1 more than 10.Z999 ?
@ kirti ,
If you could answer the question above, I can make...
--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)

January 6, 2023 at 5:49 pm

#4134625
Reply To: Generation of Auto Series based on logic

@ kirti ,
What do you want it to do when you go to 1 more than 10.Z999 ?

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

January 6, 2023 at 3:58 pm

#4134590
Reply To: BCP OUT xp_cmdshell errors out maximum column

Saran wrote:
Hi All,
I am doing BCP out the table having 175 columns. For small table columns it works fine.
It errors out for this big column table.
EXECUTE master.dbo.xp_cmdshell 'bcp "SELECT col1...col175...
--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)

January 6, 2023 at 3:54 pm

#4134587
Reply To: Split One Column into Multiple that uses / as the delimiter

Jeff Moden wrote:
Luv SQL wrote:
I've been researching this for over 3 hours and none of the syntax I've found works. I have a column with data that's been merged from various other...
--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)

January 6, 2023 at 3:27 pm

#4134558
Reply To: The SPU

Heh... and still have everything run single threaded because of the way people wrote the code. 😀
--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)

January 5, 2023 at 10:23 pm

#4134242
Reply To: Create a Job Schedule that runs on the 1st of month only if it falls on a Sunday

cyrusbaratt wrote:
Very simple example:
sqlcmd -S <ComputerName>\<InstanceName> -i <MyScript.sql> -o <MyOutput.rpt>
Just use a sqlcmd SQL script with the function below using a windows scheduled task in a batch file:
If datepart(dw,getdate()) =...
--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)

January 5, 2023 at 10:12 pm

#4134241
Reply To: The Tech That is Gone

skeleton567 wrote:
Jeff Moden wrote:
Some old tech that I wish would come back is people that actually know how to ask a question and then read the answer and act upon it...
--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)

January 5, 2023 at 10:04 pm

#4134238
Reply To: Execution of SP

I would ask an "sqlguru". 😉
--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)

January 5, 2023 at 2:18 pm

#4134051

Viewing 15 posts - 2,131 through 2,145 (of 59,067 total)