Viewing 15 posts - 541 through 555 (of 607 total)
To Steve's point in that article, most of the time set-based code will perform better than trying to "divide and conquer", but he was dealing with a trigger which meant...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 25, 2017 at 5:29 am
yeah, or sys.syscomments. Chris, any idea what the difference is between sql_modules and syscomments? I'm trying to read BOL to understand, but to me it looks like it would be...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 24, 2017 at 2:20 pm
Thom, I'm not sure I'm totally following you, and you are just now clueing me into graphs, but can you show me how you're comparing the graph syntax to the...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 24, 2017 at 1:42 pm
I don't think we know enough to know how to answer you. It is possible to have charts with three series, but I don't think that's what you mean. Can...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 24, 2017 at 12:57 pm
Nice Joe! We have a function to do this, sourced from Jeremiah Peschka (http://facility9.com/2010/02/24/rounding-to-the-nearest-x-minutes), which works nicely when we need it, and allows for choosing your interval a...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 24, 2017 at 12:49 pm
I can't imagine it would be efficient, but you could look through the INFORMATION_SCHEMA views to do this, if you have to recreate it. that in combination with SP_MSFOREACHTABLE might...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 24, 2017 at 12:45 pm
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 24, 2017 at 11:11 am
Email server's down, I sent you an email about it.
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 17, 2017 at 9:09 pm
running it across servers and need to use OPENQUERY() to make it work in a reasonable timeframe. so I'm cheating, pulling one record over to create a local mirrored table,...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 12, 2017 at 9:49 pm
...and now I'm wondering if I can't buy a Leap controller and a wand and program some shortcuts so I can code like a wizard....already use Dasher (http://www.inference.phy.cam.ac.uk/dasher/) to...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 12, 2017 at 12:34 pm
My code from today included the following comments:
--copy table values into new table, just to get columns...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 12, 2017 at 12:30 pm
I forgot you wanted to conditionally look for something or NULL. I think this is the CASE you wanted, replace the guts of the proc above with this:
[code...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 11, 2017 at 9:37 pm
I'm not entirely sure why you want a view here, if this is a recordset that you want to use regularly and JOIN to it, then you probably want to...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 11, 2017 at 9:17 pm
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 11, 2017 at 11:47 am
Made a recent change to code and am now unit...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 11, 2017 at 11:41 am
Viewing 15 posts - 541 through 555 (of 607 total)