Viewing 15 posts - 2,866 through 2,880 (of 4,820 total)
If you're talking about a single row insert, then adding the sproc just adds unnecessary overhead, unless you have an environment that requires the sprocs to do it because they're...
February 15, 2017 at 1:57 pm
HashKeys can be "compute-expensive", so constantly computing these values could be a severe performance problem for a tightly managed or capacity limited OLTP environment. On the other hand, if you've...
February 15, 2017 at 1:54 pm
February 15, 2017 at 1:32 pm
FYI, do you realize that the same child WO appears as a child to more than one parent ??? This is not a good idea. Once a sizable number of...
February 15, 2017 at 1:23 pm
FYI, your code, as posted above, and then corrected by me only for the use of the temp table and the spelling of one of the field names (Production_Qty instead...
February 15, 2017 at 12:47 pm
February 15, 2017 at 12:18 pm
February 15, 2017 at 11:47 am
I will give this a try, and yes, I could do it in batches, thanks! ...
February 15, 2017 at 11:30 am
Also, to Jeff Atherton's point, is this a one-time thing or an ongoing need? The reason is because there are some great ways to automate this process, involving potentially SSIS...
February 15, 2017 at 10:55 am
I will give this a try, and yes, I could do it in batches, thanks! ...
February 15, 2017 at 10:53 am
February 15, 2017 at 9:29 am
I have the list as "text" values, currently in a spreadsheet. Yes, I can convert...
February 15, 2017 at 9:11 am
I guess it depends on what you're looking to accomplish, exactly. I don't have an entirely clear picture of what you need to do beyond your need to split a...
February 15, 2017 at 8:32 am
February 15, 2017 at 7:41 am
Jeff Moden - Tuesday, February 14, 2017 6:26 PMThe next level of simplification exists in the following command... have a look.
https://technet.microsoft.com/en-us/library/cc753551(v=ws.11).aspx
Yep......
February 14, 2017 at 7:47 pm
Viewing 15 posts - 2,866 through 2,880 (of 4,820 total)