Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,786 through 16,800 (of 59,067 total)

RE: finding max value between dates

astrid 69000 (9/18/2016)
i wrote this, what do you think?
Select
t.dates, t.customer, t.ind_1, t.ind_2, t.ind_3, t.ind_4,
ind_1_yearafter=(
...
--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)

September 18, 2016 at 5:34 pm

#1901546
RE: Better query to accomplish this?

That looks just fine, Jeff. The "pre-aggregation" method would add nothing here because each feeder only has one entry per hour (according to the data you've shown in your...
--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)

September 18, 2016 at 5:24 pm

#1901545
RE: Better query to accomplish this?

Jeff Teel (9/17/2016)
I spent some more time with your tutorial and finally figured out a solution. Thanks very much for your help. Much more readable and much better performance.
Very cool....
--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)

September 18, 2016 at 4:17 am

#1901518
RE: Better query to accomplish this?

Yes. Try the methods in the following article.
http://www.sqlservercentral.com/articles/Crosstab/65048/ (Dynamic CrossTabs).
--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)

September 17, 2016 at 3:57 pm

#1901513
RE: Observe db field changes for reporting

As a, perhaps, easier alternative, fire up SQL Server Profiler and look for RPC complete for the login of the app.
--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)

September 17, 2016 at 3:30 pm

#1901512
RE: Observe db field changes for reporting

Create a "universal" trigger to capture the table schema name, the table name, the PK column(s) value(s), and the value of the COLUMNS_UPDATED(). Translate the values of COLUMNS_UPDATED() after...
--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)

September 17, 2016 at 3:01 pm

#1901511
RE: The Danger of xp_cmdshell

FrancoisFLageole (9/16/2016)
I use English rarely!
Heh... a lot of us in the U.S.A. have the same problem. 😀
--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)

September 17, 2016 at 2:32 pm

#1901510
RE: Data Science Education

Gary Varga (9/17/2016)
Jeff Moden (9/16/2016)
Step one would be to learn how to return the bloody current date and time using T-SQL. 😉
Maybe some of us would have paid attention if...
--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)

September 17, 2016 at 12:19 pm

#1901509
RE: Data Science Education

Step one would be to learn how to return the bloody current date and time using T-SQL. 😉
--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)

September 16, 2016 at 10:35 pm

#1901495
RE: How to load Query results into SSIS Package

You're using T-SQL for the query. Why do you think you need SSIS to bring the results into a staging 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)

September 16, 2016 at 10:33 pm

#1901494
RE: Return Code from OSQL

imani_technology (9/16/2016)
Sue_H (9/15/2016)
imani_technology (9/15/2016)
I have the following statement in a batch file. However, how can I get a return code to let me know the SQL Agent job ran...
--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)

September 16, 2016 at 10:31 pm

#1901493
RE: % of total count

What you have to remember is, all of the costs are estimates. The only thing that ultimately matters is the actual performance.
Here's my favorite example on performance. ...
--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)

September 16, 2016 at 10:26 pm

#1901492
RE: Rows to Columns

erouse (9/16/2016)
Can somebody please help? Is there a fairly simple way to do this?
This is my data now.
LABORLC
152685A B C D E
152969A B
This is what I would like...
--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)

September 16, 2016 at 10:02 pm

#1901491
RE: Shrinking a large DB

TheSQLGuru (9/16/2016)
I will disagree with others about reducing the data being a good thing. Obfuscation sure, but ONLY where REQUIRED.
The OP stated this database was to be promulgated to developers...
--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)

September 16, 2016 at 9:59 pm

#1901490
RE: The Danger of xp_cmdshell

Indianrock (9/16/2016)
...but I think it's safe to say it would be considerably more difficult.
No... It's not safe to say that. As with all else having to do with computers,...
--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)

September 16, 2016 at 4:47 pm

#1901483

Viewing 15 posts - 16,786 through 16,800 (of 59,067 total)