Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,111 through 4,125 (of 59,101 total)

Reply To: ownership chain

You've been here for more than 12 years. Please learn how to post code in a code window so that it's easier to read. Here's the key when you're creating...
--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 12, 2022 at 11:46 pm

#3972581
Reply To: Complicated Insert SQL with Calculations

"It Depends", Joe. Why recalculate something perhaps thousands of times per day if the answer isn't going to change that day? It's called "caching" and it's a time honored method...
--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 12, 2022 at 11:32 pm

#3972579
Reply To: The same value across 5 or more columns in a table , How can I write a query

jcelko212 32090 wrote:
>> I got a table with 5 integer columns and one varchar(100) column. <<
Where is the DDL? I guess you want us to do everything for you , including...
--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 12, 2022 at 11:07 pm

#3972572
Reply To: Where did the 'Insert Code' toolbar go?

Also, please check to see if you got an email about me responding on this thread.

--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 12, 2022 at 6:09 pm

#3972477
Reply To: Where did the 'Insert Code' toolbar go?
Testing the code window and paste from firefox... you can ignore this post...
Code Window and paste
```
-- Edit test here
DROP TABLE IF EXISTS #Result
GO
CREATE TABLE #Result(
EmpNr nvarchar(10) NOT...
```
--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 12, 2022 at 5:45 pm

#3972469
Reply To: Where did the 'Insert Code' toolbar go?

Heh... I just went to the thread to post a point so people knew and the toolbar seems to have come back. What was cool was it actually took me...
--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 12, 2022 at 5:41 pm

#3972466
Reply To: Where did the 'Insert Code' toolbar go?

I had noticed the same thing yesterday. I send Steve and WebMaster@SQLServerCentral.com and email outlining the symptoms. Steve emailed me that a ticket has been opened and the right folks...
--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 12, 2022 at 5:36 pm

#3972463
Reply To: Loading x number of CSV files into x number of unique tables of a database

Phil Parkin wrote:
masterelaichi wrote:
hmm.. for some reason it says that the last post by me but I can't see it
UPDATE: weird.. I could see only 3 pages and once I posted...
--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 12, 2022 at 12:49 am

#3972178
Reply To: Multiple Date rows into One single Date row(date range)

skiper wrote:
Oops, my bad, I am posting again new spread sheet to clarify
Please have a look at it now, if its better explained now , however if there are more...
--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 11, 2022 at 5:42 pm

#3972068
Reply To: The same value across 5 or more columns in a table , How can I write a query
ZZartin wrote:
What's wrong with just?
COL_ONE = COL_TWO AND COL_ONE=COL_THREE etc....
Any other "clever" solution is almost certainly going to be more code.
And, usually slower. I haven't tested...
--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 11, 2022 at 6:18 am

#3971876
Reply To: Complicated Insert SQL with Calculations

So, enquiring minds want to know... did that latest code help?
--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 11, 2022 at 6:13 am

#3971874
Reply To: Issue with Leading 0

My guess would be that it cannot be YYYYDDD because the first D is always a 0. Perhaps YYYYoWW but why the bloody zero?
Now, if we could just get mcfarlandparkway...
--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 10, 2022 at 3:48 am

#3971416
Reply To: Issue with Leading 0

The only reason I didn't use STUFF is because if you DO use the code on data that has already been modified by the use of STUFF, then it's going...
--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 9, 2022 at 3:23 pm

#3971346
Reply To: How to allow multi user work on same table without any issue of interact data ?

Another good link can be found here.
https://www.sqlshack.com/introduction-to-row-level-security-in-sql-server/

--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 9, 2022 at 3:12 pm

#3971342
Reply To: Where the World Takes You

Back in the 80's, I was teaching people how to use these new fangled things called "PC's". We had Lotus 123 and WordPerfect. I had quickly become one of 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)

January 9, 2022 at 3:36 am

#3971268

Viewing 15 posts - 4,111 through 4,125 (of 59,101 total)