Viewing 15 posts - 166 through 180 (of 4,079 total)
Jeff, I have to agree that if you're trying to do a large number of rows in a single merge, you need to jump through some hoops to set up...
September 26, 2016 at 12:09 pm
I have to ask... just what is a Data Therapist? 🙂
September 26, 2016 at 9:46 am
If you haven't read up on the MERGE operation in TSQL, be sure to do so. It allows you to insert and update (and d elete if need...
September 23, 2016 at 10:00 pm
Here's another vote for leaving .NET entirely out of it. You will get enormous throughput increases by just having SQL do this in a procedure. ...
September 23, 2016 at 9:55 pm
Just for what it's worth, we used to use the string splitter approach until the developers finally bit the bullet and learned to use table valued parameters. ...
September 23, 2016 at 10:24 am
Looking at what you *have* provided. I have a couple of questions:
Are you trying to develop on-hand amounts for all products, or one at a time, as...
September 23, 2016 at 10:21 am
Please provide create table statments and a small amount of sample data as described HERE[/url], and someone will be happy to help you. Be sure to include...
September 23, 2016 at 10:12 am
One more alternative (I think) to throw in the mix. Each phone model string is split into individual "words", which are then filtered out by an existence test...
September 23, 2016 at 9:30 am
Withdrawn. I'm being critical. Is it Friday yet?
September 22, 2016 at 2:45 pm
Brandie Tarvin (9/22/2016)
The Dixie Flatline (9/15/2016)
September 22, 2016 at 2:30 pm
Patrick, if you think this is about competition, then you totally misunderstand me. The only thing I'm concerned about here is teaching newcomers to SQL good habits...
September 20, 2016 at 3:10 pm
Patrick,
Sorry if I misunderstood, but your initial post didn't contribute anything to the discussion here. It simply said "Look at mine too." with no mention of what...
September 20, 2016 at 2:45 pm
Patrick: Thank you for advertising your own article here. I did in fact read it and it does contain quite a few columns missing from my article...
September 20, 2016 at 1:10 pm
BWFC: I saw a comment this week that said "If you never look back over your old code and see things you could do better, it means...
September 20, 2016 at 8:40 am
GPO, you're absolutely right. There is no need for a holiday table when you are querying the calendar itself. In the situation you describe, flagging...
September 19, 2016 at 4:48 pm
Viewing 15 posts - 166 through 180 (of 4,079 total)