Viewing 7 posts - 166 through 172 (of 172 total)
Here are a couple that I use.
Common SSRS expression would be
=IIf(Fields!qty.Value is nothing, 0, Fields!qty.Value) - swap single null with 0
=IIf(Fields!qty.Value is nothing, Fields!qty2.Value, Fields!qty.Value) - swap null with another...
September 8, 2011 at 6:38 am
Cold comfort knowing that I chose the most frequently selected INCORRECT answer! 😛
September 6, 2011 at 6:20 am
Very nice! I will definitely find the STUFF fuction useful. Learning more and more each day thanks to you all! 🙂
August 29, 2011 at 6:55 am
OzYbOi d(-_-)b (8/23/2011)
SanDroid (8/23/2011)
On top of that, didn't it say to consider the code, not run it?!? 😀 😛 :hehe:Good question
Good point! Not for me though. 😛
August 25, 2011 at 6:25 am
Basics is just what I need. My SQL career is still an infant. 😛
August 25, 2011 at 6:16 am
I was also thinking you could periodically load data using a scheduled task that executes a stored procedure to "refresh" the data, or perhaps add more data based on transaction...
August 17, 2011 at 6:22 am
Viewing 7 posts - 166 through 172 (of 172 total)