Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,816 through 16,830 (of 59,101 total)

RE: Are the posted questions getting worse?

More like "people" season. Some people just don't get it. See the following where what someone is doing actually could kill people. I've confirmed Sergiy's findings 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)

September 19, 2016 at 12:43 pm

#1901718
RE: View for real-time list pulls in an OLTP

vilyana (9/19/2016)
Sergiy (9/19/2016)
It seems the design is faulty.
PatientMedicationCourse must be allocated to PatientTherapyCourse, not directly to PatientTreatment.
Medications prescribed for one Therapy Course must not be mixed with medications for another...
--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 19, 2016 at 12:37 pm

#1901713
RE: The Danger of xp_cmdshell

Stefan LG (9/18/2016)
I must admit I am a big fan of xp_cmdshell!
I have been using it for many years now, without any problems (security or otherwise). I suppose there are...
--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 19, 2016 at 1:29 am

#1901562
RE: View for real-time list pulls in an OLTP

I agree with what Sergiy stated. There's a pretty easy solution to this request (I just wrote it and tested it) but found a similar horrible problem to 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)

September 19, 2016 at 1:25 am

#1901561
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

Viewing 15 posts - 16,816 through 16,830 (of 59,101 total)