Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,311 through 8,325 (of 59,072 total)

Reply To: It Just Works

While I agree that Access has some connection limitations, I wouldn't by any means say that it's "a one file solution, designed for a single user with a desktop". I'm...
--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)

November 20, 2019 at 6:26 pm

#3699296
Reply To: Replace TABLE with STAGING_TABLE. Approach?

JJR333 wrote:
Great, works like a charm!
Thank you Jeffrey and Jeff.
FWIW:
IF EXISTS keeps returning an error (SS 2008 R2),
DROP SYNONYM sBewoners, does not.
Swapping the view Clients (I prefer to distinguish names...
--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)

November 20, 2019 at 2:33 pm

#3699207
Reply To: Turn If statement into Case

GrassHopper wrote:
Jeff Moden wrote:
I have to ask... what are you pasting the code from?
Jeff, I copied it from SQL studio to notepad and then here. I'm not sure why 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)

November 20, 2019 at 12:53 pm

#3699168
Reply To: Running Totals by Date and Account

No problem... Here's the code (below) to build a simple table with 1,000 accounts of 10,000 rows each of constrained random data for a total of 10 million rows. I...
--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)

November 20, 2019 at 6:03 am

#3699098
Reply To: Turn If statement into Case

I have to ask... what are you pasting the code from?
--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)

November 20, 2019 at 2:50 am

#3699078
Reply To: Running Totals by Date and Account

Jonathan AC Roberts wrote:
Jeff Moden wrote:
I do have a way to avoid that problem that will blow the doors off of most other methods for calculating running totals but it does take a...
--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)

November 20, 2019 at 2:48 am

#3699074
Reply To: Hidden RBAR: Triangular Joins

Cody Konior wrote:
I'm 7 years late but that last bit of sample code is referencing a non-existent field SomeVal instead of RowNum created in the table just prior 🙂
Heh... and I'm...
--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)

November 19, 2019 at 7:45 pm

#3698968
Reply To: Running Totals by Date and Account

pgainer wrote:
Jonathan, Drew and ZZartin,
Wow, that was fast!
Thank you very much. The 2nd method provides me with what I need.
Phil...
Be careful here. It looks to me that the CROSS APPLY...
--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)

November 19, 2019 at 7:31 pm

#3698965
Reply To: I am new to SQL world

Just remember that the YYYY-MM-DD formats aren't actually followed as ISO in SQL Server even though it is a valid ISO format. For example, if you set the language =...
--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)

November 19, 2019 at 7:20 pm

#3698962
Reply To: Replace TABLE with STAGING_TABLE. Approach?

JJR333 wrote:
Thanks Scott. Will look into this.
J.
If you used a synonym instead of a view, it would be even easier because you could read what it was pointing at from...
--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)

November 19, 2019 at 7:17 pm

#3698961
Reply To: Why no posts?

Awesome! I think you're the first person I've talked to that's actually using it for something that I think it's useful for. As soon as you said that you work...
--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)

November 19, 2019 at 7:07 pm

#3698956
Reply To: Maintenance Window for SQL Server Critical Alerts

Heh... I just let the alerts fly... it's a great monthly test/confirmation for the alerts and the jobs that some of them run. The auditors love it because it shows...
--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)

November 19, 2019 at 2:45 pm

#3698838
Reply To: Trigger store procedure with a file in SQL Server

You allow an app to write files to your SQL Server? I don't allow that. It have people write their files to a different box and then give 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)

November 19, 2019 at 2:39 pm

#3698835
Reply To: Why no posts?

xsevensinzx wrote:
I've been highly inactive for like a year it seems, but here is my input.
I am still 100% invested in Azure Data Warehouse and Azure Data Lake Store 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)

November 19, 2019 at 2:33 pm

#3698833
Reply To: missing storage space

Uh... I just noticed... the first script doesn't even report sizes... so I'm confused as to what you found the problem to actually be.
--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)

November 19, 2019 at 2:26 pm

#3698828

Viewing 15 posts - 8,311 through 8,325 (of 59,072 total)