Viewing 15 posts - 166 through 180 (of 4,080 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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 26, 2016 at 12:09 pm
I have to ask... just what is a Data Therapist? 🙂
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 23, 2016 at 9:30 am
Withdrawn. I'm being critical. Is it Friday yet?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 22, 2016 at 2:45 pm
Brandie Tarvin (9/22/2016)
The Dixie Flatline (9/15/2016)
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 19, 2016 at 4:48 pm
Viewing 15 posts - 166 through 180 (of 4,080 total)