Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,996 through 8,010 (of 59,072 total)

Reply To: Temporal Table Columns

Bah! It's just not worth it. You can't add a default column to Temporal Tables. You can't add a column to the History table without adding it to the main...
--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)

December 31, 2019 at 4:39 am

#3711367
Reply To: Temporal Table Columns

Crud. I was afraid of that. The dynamic SQL cannot see the INSERTED/DELETED tables, either. I could copy the INSERTED table to a temporary table or table variable but that's...
--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)

December 31, 2019 at 2:26 am

#3711365
Reply To: Temporal Table Columns

p.s. I wish they'd fix the bloody code windows for color on SSC. It would be better if they simply rendered out as all black rather than serious color mistakes...
--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)

December 31, 2019 at 1:51 am

#3711362
Reply To: Temporal Table Columns

That works great but only if that's the only UPDATE trigger on the table. Here's a test that shows that even though the value of some columns hasn't been changed,...
--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)

December 31, 2019 at 1:49 am

#3711361
Reply To: Creating new database from another database scripts

If I had to do this on a regular basis and couldn't simply do a restore (because of PII of the data simply being too large for a Dev environment,...
--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)

December 30, 2019 at 6:12 pm

#3711250
Reply To: Importing a CSV files in SSMS

My apologies. You're correct. You didn't mention Excel anywhere. My old sometimes caffeine deprived eyes misread it that way.
Going back to the beginning, you stated that the file had both...
--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)

December 30, 2019 at 6:05 pm

#3711249
Reply To: Temporal Table Columns

My apologies, Scott. I wasn't clear. In this particular case, I was referring mostly to solving the problem of having a column that identifies who did the update without 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)

December 30, 2019 at 5:46 pm

#3711244
Reply To: T-SQL Query Help

@rocky_498 ,
Trying to get this thread back on track for your original question... is there an answer to my inquiry so we can get busy with answering your question with...
--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)

December 30, 2019 at 4:36 pm

#3711224
Reply To: T-SQL Query Help

oogibah wrote:
Can confirm with Jeff, sorry if I sounded a bit salty up there 🙂
You have nothing to apologize about. I appreciated the humor about the # sign. I've never...
--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)

December 30, 2019 at 4:33 pm

#3711223
Reply To: Temporal Table Columns

ScottPletcher wrote:
I've had to use "extension" tables here a few times too, for various reasons.
If you have an identity column present, do remember / be aware of the issues with...
--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)

December 30, 2019 at 4:19 pm

#3711210
Reply To: T-SQL Query Help

rjhare wrote:
Thanks Neil,
I assumed this level of disdain, to those less experienced, had disappeared twenty years ago from technical forums - apparently not.
I will not be asking too many questions...
--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)

December 30, 2019 at 4:12 pm

#3711209
Reply To: SQL Newbie Help

jcelko212 32090 wrote:
>> Why can I not create a new column and add 90 days to the date in column P_INDATE in MS SQL Server? <<
Why don't you put this computation...
--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)

December 30, 2019 at 5:07 am

#3711090
Reply To: Importing a CSV files in SSMS

Ah... and just noticed... you said your boss is using the import EXCEL wizard in your last post, which is different than your first post. Which is it??? EXCEL 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)

December 30, 2019 at 4:45 am

#3711087
Reply To: Importing a CSV files in SSMS

What you have posted in the image of your original post should do it. I'm kind of confused, though. You were right there or you wouldn't have been able to...
--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)

December 30, 2019 at 4:43 am

#3711086
Reply To: Importing a CSV files in SSMS

I'll be back.
--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)

December 30, 2019 at 4:01 am

#3711081

Viewing 15 posts - 7,996 through 8,010 (of 59,072 total)