Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,261 through 1,275 (of 59,065 total)

Reply To: I have string data in a column and i need to strip out parts of it.

Ah... my apologies, James. Based on your request (repeated below), I interpreted it as there would be 1 to 4 "numbers" in a single row. What you meant was "one...
--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)

July 25, 2023 at 3:41 pm

#4244235
Reply To: SQL Query
Steve Collins wrote:
Thanks to ChatGPT for creating the temp table
```
DROP TABLE if exists #TempTable;
go
CREATE TABLE #TempTable
(
    ID INT,
    flag int,
  ...
```
--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)
July 25, 2023 at 4:40 am

#4243718
Reply To: SQL Query

Steve Collins wrote:
Thanks to ChatGPT for creating the temp table
Let's see what the actual prompt for that was, please.
For those interested, here's a link to the prompt that I used and...
--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)

July 25, 2023 at 4:05 am

#4243708
Reply To: SQL Query
Priyanka Chouhan wrote:
You can get it via this SQL code:
```
SELECT t.ID, t.flag, t.name
FROM your_table_name t
WHERE 
    (t.flag = 0 AND NOT EXISTS (
  ...
```
--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)
July 25, 2023 at 4:04 am

#4243707
Reply To: I have string data in a column and i need to strip out parts of it.

James Reed wrote:
How can i adjust the substring to grab from 1 to 4 numbers in the UISeq?
SELECT UIMth = substring(t.yourcolumn, 8, 8) , UISeq = substring(t.yourcolumn, 24, charindex(' ', t.yourcolumn,...
--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)

July 25, 2023 at 3:57 am

#4243695
Reply To: Not a question - Just making sure everyone knows.

Grant Fritchey wrote:
Nothing, anywhere, is perfectly secure. There are always vulnerabilities. We just don't always know what they are until it's far too late.
However, I still land where I always land...
--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)

July 24, 2023 at 1:53 pm

#4243182
Reply To: Achieving More Autonomy At Work

There are also hidden dangers to "Autonomy" and that is the danger of being "forgotten" or "pigeon-holed" or coming across as a bit arrogant. For example, if you answer 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)

July 24, 2023 at 3:30 am

#4242779
Reply To: A Overview of Amazon Redshift

This is a beautifully written article and the order of revelation is spot on. Of course, I cannot be sure but it looks like something that AI would write (and,...
--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)

July 24, 2023 at 2:58 am

#4242768
Reply To: The Choice of SQL Server Version

One of the things that people seem to forget it that it was almost 2023 by the time 2022 came out. It may have gone past the "plan the funding...
--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)

July 22, 2023 at 11:06 pm

#4242033
Reply To: How to import csv file into a sql table and include filename

shogunSQL wrote:
Thank you so much, Jeff! I was looking for something like xp_DirTree. Will try it out. Thanks.
Although it's more than a decade old, good things don't need to change...
--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)

July 22, 2023 at 10:48 pm

#4242010
Reply To: How to import csv file into a sql table and include filename

shogunSQL wrote:
Hi everyone,
I have a directory of many csv files such as
C:\Temp\NP-001.csv
C:\Temp\NP-002.csv
C:\Temp\NP-003.csv
In each csv file, there are 5 columns: Name, DOB, MemberID, Address, Email
We need to somehow loop through each...
--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)

July 21, 2023 at 7:24 pm

#4241233
Reply To: Select from view on FileTable throws error
pdanes wrote:
But it blows up when I try:
Select * From Query1 Where tmpResult1 = 'D'
That, good Sir, is what I'm talking about being the problem. That is...
--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)
July 21, 2023 at 7:13 pm

#4241232
Reply To: Select from view on FileTable throws error

pdanes wrote:
I still think it's screwy that SQL Server made a query plan that does column computations BEFORE removing rows according to conditions in the Where clause.
In calculated columns...
--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)

July 21, 2023 at 2:40 pm

#4241094
Reply To: Invoke-DbaQuery in Powershell 7.2 not working

I think you may have correctly identified the problem... Someone who is more knowledgeable about PoSh than I may have a bit of magic that I don't know about but...
--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)

July 21, 2023 at 12:36 am

#4240585
Reply To: Select from view on FileTable throws error

If I'm reading all of this correctly, another issue with filtering the calculated columns of a view is that all of the rows must first be materialized and then 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)

July 21, 2023 at 12:27 am

#4240560

Viewing 15 posts - 1,261 through 1,275 (of 59,065 total)