Viewing 15 posts - 1,531 through 1,545 (of 4,080 total)
The key thing to remember is that a multi-row insert is a single transaction and your trigger will fire only once for the set of rows, not once for each...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 5, 2010 at 11:14 am
One thing to be aware of when doing this on a large scale is that you have no suitable column to ORDER BY on. Ordering by name will...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 3, 2010 at 2:48 pm
I'm afraid I really don't understand your question. Could you possibly supply a little more detail? What do you mean by "practical"? Some...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 3, 2010 at 1:47 pm
Here are another couple of CTE-based variations. They may be easier to read and understand. Basically each does a summary query to total the...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 3, 2010 at 8:23 am
This question is a common one. You can find a lot of different approaches if you will search this site using the keywords "PARSE" and "DELIMITED".
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 2, 2010 at 2:03 pm
There are lots of variations that will work.
Here's another that gives you a six-character string in the format YYYYMM.
...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 2, 2010 at 1:57 pm
Let's all do the Canadian National Cheer !!
Gimme a "C"
eh?
Gimme a "N"
eh?
Gimme a "D"
eh?
What's it spell?
CehNehDeh!!!!
😀
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 1, 2010 at 4:44 pm
I'm just brown-nosing. 😉
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 1, 2010 at 3:39 pm
Lets not forget to congratulate Steve too.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 1, 2010 at 3:01 pm
Tony,
It's a good solution because it gets you past the problem of not being able to use a db-qualified procedure name in the CREATE PROCEDURE Statement. I'm not...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 1, 2010 at 8:55 am
An odd fact about inline table valued functions is that you can run inserts, updates, and deletes against them. They really are treated like parameterized views.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 1, 2010 at 8:53 am
I like a little cheese with my whine.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 29, 2010 at 9:04 pm
I refrained from joining in the debate over in The Thread. I agree with you though that a little tech could go a long way at that...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 28, 2010 at 4:24 pm
Steve Jones - Editor (6/28/2010)
vo-confused-erous
You or the officials?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 28, 2010 at 4:08 pm
vociferous
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 28, 2010 at 3:41 pm
Viewing 15 posts - 1,531 through 1,545 (of 4,080 total)