Viewing 15 posts - 16,786 through 16,800 (of 59,067 total)
astrid 69000 (9/18/2016)
Select
t.dates, t.customer, t.ind_1, t.ind_2, t.ind_3, t.ind_4,
ind_1_yearafter=(
...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 18, 2016 at 5:34 pm
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
Change is inevitable... Change for the better is not.
September 18, 2016 at 5:24 pm
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
Change is inevitable... Change for the better is not.
September 18, 2016 at 4:17 am
Yes. Try the methods in the following article.
http://www.sqlservercentral.com/articles/Crosstab/65048/ (Dynamic CrossTabs).
--Jeff Moden
Change is inevitable... Change for the better is not.
September 17, 2016 at 3:57 pm
As a, perhaps, easier alternative, fire up SQL Server Profiler and look for RPC complete for the login of the app.
--Jeff Moden
Change is inevitable... Change for the better is not.
September 17, 2016 at 3:30 pm
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
Change is inevitable... Change for the better is not.
September 17, 2016 at 3:01 pm
FrancoisFLageole (9/16/2016)
I use English rarely!
Heh... a lot of us in the U.S.A. have the same problem. 😀
--Jeff Moden
Change is inevitable... Change for the better is not.
September 17, 2016 at 2:32 pm
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
Change is inevitable... Change for the better is not.
September 17, 2016 at 12:19 pm
Step one would be to learn how to return the bloody current date and time using T-SQL. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
September 16, 2016 at 10:35 pm
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
Change is inevitable... Change for the better is not.
September 16, 2016 at 10:33 pm
imani_technology (9/16/2016)
Sue_H (9/15/2016)
imani_technology (9/15/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
September 16, 2016 at 10:31 pm
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
Change is inevitable... Change for the better is not.
September 16, 2016 at 10:26 pm
erouse (9/16/2016)
This is my data now.
LABORLC
152685A B C D E
152969A B
This is what I would like...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 16, 2016 at 10:02 pm
TheSQLGuru (9/16/2016)
The OP stated this database was to be promulgated to developers...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 16, 2016 at 9:59 pm
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
Change is inevitable... Change for the better is not.
September 16, 2016 at 4:47 pm
Viewing 15 posts - 16,786 through 16,800 (of 59,067 total)