Viewing 15 posts - 25,171 through 25,185 (of 26,484 total)
Everyone has their own way of laying out code. This is how I like to do it using the example several have used in this thread:
SELECT
...
March 4, 2008 at 8:51 am
Guess I'll have to check this out from home. Can't view the site here at work.
😎
March 4, 2008 at 8:37 am
Time to ask a question, why the sub-total every 5 records? Seems to me this should probably be done on the application side, not the database side of things...
March 3, 2008 at 4:19 pm
The only gotcha I would warn about is regarding SSIS packages. When you create an SSIS package with a script task, be sure to select the option to precompile...
March 3, 2008 at 2:48 pm
Not that I am aware of, sorry. You can setup a DDL trigger to capture that event at a server level, or setup a trace to capture that as...
March 3, 2008 at 2:01 pm
I think the difference between a 5 of 10 and a 9 of 10 (to use a scale) isn't so much the amount of knowledge but more the intuitive thought...
March 3, 2008 at 1:39 pm
It isn't that we are trying to down play our knowledge, it just the more we learn, we learn that there is more we don't know.
Maybe I am better than...
March 3, 2008 at 1:24 pm
Life lesson -- There is always something new to learn, even when you think you know it all!
You can bury me when I stop learning.
March 3, 2008 at 12:56 pm
Actually, I haven't even thrown in SSIS, SSRS, or SSAS. If I added those in, my score would drop. On SSIS (2 or 3 of 10), SSRS (1...
March 3, 2008 at 12:49 pm
GSquared (3/3/2008)
Lynn Pettis (3/2/2008)
....
I appreciate the compliment. Now you've set the bar for me even higher. I would be lucky to put myself at 5 out 10...
March 3, 2008 at 11:25 am
You are even more limited if you are using the embedded version of SQL Server that is loaded in a single server install. We have two installations of Windows...
March 3, 2008 at 7:50 am
Okay, I feel even smaller now with all this praise. Jeff, the last word most people at work would use to describe me is humble. At work, yes,...
March 3, 2008 at 6:51 am
GilaMonster (3/2/2008)
Lynn Pettis (2/29/2008)
March 2, 2008 at 1:51 pm
pbushong (3/1/2008)
using select dbo.fn_BRound(5.344515,2) gives you 5.34 and not 5.35. Any clues on how I can get 5.35 from this number?:crying:
You won't. You are rounding to the 100ths...
March 1, 2008 at 1:08 pm
Viewing 15 posts - 25,171 through 25,185 (of 26,484 total)