Viewing 15 posts - 2,311 through 2,325 (of 2,771 total)
I actually did end up putting something together that works.
Here's what I ended up doing.
I first did a simple count on the inserted and deleted tables in the trigger. ...
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
August 18, 2010 at 7:32 am
procrastination
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
August 18, 2010 at 7:14 am
Ack . . . I just read you were asking about SSRS. For some reason, I was thinking SSMS.
Sorry. My bad. :blush:
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
August 17, 2010 at 3:04 pm
Going to need some time to digest this code, but yes, I do think this will be helpful.
Thanks!
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
August 17, 2010 at 2:21 pm
"The Giants win the pennant!!! The Giants win the pennant . . . !!!"
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
August 17, 2010 at 1:26 pm
Brandie Tarvin (8/17/2010)
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
August 17, 2010 at 11:49 am
Brandie Tarvin (8/17/2010)
Does it have to be a trigger?
If you're asking if my code has to be in a trigger, then no, it doesn't. In fact, the original version...
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
August 17, 2010 at 11:30 am
Okay, I think I see what you're saying. Let me make sure I'm following this correctly.
Get...
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
August 17, 2010 at 11:22 am
Steve Jones - Editor (8/17/2010)
This help?
Somewhat. One thing that's confusing me: is OUTPUT only limited to storing in a table variable, or is there a way for me to...
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
August 17, 2010 at 11:05 am
Dan H. (8/17/2010)
Woot....so by my count, that's 13 of us (if Ray K. is in)
Oh, what the heck. Go ahead and count me in.
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
August 17, 2010 at 10:59 am
Hi guys -- I could use some help on my question over here, if anyone has any thoughts!
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
August 17, 2010 at 10:55 am
HJC36 (8/17/2010)
A) = Total Qty on Hand (IC_QUANTITY)
B) = Sum of demand for that inventory (sum(Fields!INPUT_QTY_STD.Value))
C) = sum of the amount of that inventory...
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
August 17, 2010 at 9:49 am
Can you provide some sample data -- what you're working with, and how you want it to look?
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
August 17, 2010 at 9:14 am
Impervious
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
August 17, 2010 at 7:06 am
dbowlin (8/16/2010)
Ray K (8/16/2010)
dbowlin (8/16/2010)
The real problem with Friday the 13th, is Monday the 16th. Argh!
Hey Dan, I went to the ValleyCats game on Saturday, and they showed your...
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
August 16, 2010 at 12:50 pm
Viewing 15 posts - 2,311 through 2,325 (of 2,771 total)