Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,176 through 5,190 (of 59,089 total)

Reply To: Tables are empty but catalog views show that they have rows

SQL Guy 1 wrote:
Tried TRUNCATE - no errors. Tried DELETE - 0 rows affected.
But I probably found the reason, this is likely to be a cloned database, that was created with DBCC...
--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 8, 2021 at 10:49 pm

#3893633
Reply To: HASHBYTES giving different resaults than yesterday

astrid 69000 wrote:
I tried, but we are still having records that are unmatched.
Then you have actually having records that don't match because the function is not capable of creating different outputs...
--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 8, 2021 at 6:36 pm

#3893558
Reply To: Convert string containing ''yyyyMMdd_HHmm' back to Datetime format (dd-mm-yyyy

Another way... the formula in the CROSS APPLY converts the substring to a DATETIME2 just in case you want to see how to do that. The WHERE clause ensures 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)

June 8, 2021 at 4:05 pm

#3893502
Reply To: How to convert characters or number to underscore and after that concatenate it

This seems to be really destructive. Are you just trying to do "Data Masking"?
https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking?view=sql-server-ver15
If you really do want what you've stated, then it's real simple (using the test table...
--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 8, 2021 at 1:30 pm

#3893419
Reply To: HASHBYTES giving different resaults than yesterday

I don't know of any such change. I'm thinking that there would be a million person march on Redmond if there were. Have you checked the raw data 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 8, 2021 at 1:03 pm

#3893399
Reply To: how to get the entire sql statement while sql statment is over 4000 characters

Considering that my last name contains only 5 letters and you couldn't even spell that right, I suspect a PICNIC problem on your part. The code runs nasty fast in...
--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 8, 2021 at 12:58 pm

#3893371
Reply To: Load folder full of csv files

Hang in there. I made some good progress (fully testing along the way) but I had another late work night and it's time for bed (01:49 AM). I'll work 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 8, 2021 at 5:50 am

#3893246
Reply To: SQL Injection using Varchar(15) - sending in much longer than 15 characters???

We're just guessing here... post the actual code for get_OrderVerified
--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 7, 2021 at 5:19 pm

#3893059
Reply To: Help with SUBSTRING CHARINDEX

DaveBriCam wrote:
I'm still getting the "Invalid length parameter passed to the LEFT or SUBSTRING function." error.
See the first link in my signature line below and provide the readily consumable format...
--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 7, 2021 at 5:14 pm

#3893057
Reply To: Recursive query problem - find ALL related records for a given record

CanuckBuck wrote:
Perhaps this diagram will help illustrate the situation. In any of the given scenarios I need to find ALL related nodes given the ID of any node in 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 7, 2021 at 5:10 pm

#3893056
Reply To: The Tech Blame Game

IMHO, the only thing that has changed in the "blame game" or even the "tech blame game" is that a whole lot more of it is seen by the public...
--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 7, 2021 at 3:49 pm

#3893027
Reply To: Scaling Deployment

I wish that people would start writing articles on "Scaling QUALITY". Actually, a lot of folks need to start on the 101 version of 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)

June 7, 2021 at 3:46 pm

#3893026
Reply To: Tables are empty but catalog views show that they have rows

One more shot in the dark. I'm actually following a thread of something kind of similar on another thread.
Since the tables are supposed to be empty and rowless, try doing...
--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 7, 2021 at 3:43 pm

#3893024
Reply To: Load folder full of csv files

Bruin wrote:
I was thinking on the table and I would like to make separate columns for Oven and Line..
Funny thing there... I figured that early on (part of "column normalization)...
--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 7, 2021 at 3:29 pm

#3893018
Reply To: Load folder full of csv files
Ok... We need some details...
1. Since the file names do NOT have any temporal indications in the names, what do you want to do with a file to move 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)
June 6, 2021 at 1:15 pm

#3892606

Viewing 15 posts - 5,176 through 5,190 (of 59,089 total)