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
#1378489
Cold comfort knowing that I chose the most frequently selected INCORRECT answer! 😛
September 6, 2011 at 6:20 am
#1377332
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
#1374467
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
SanDroid (8/23/2011)
Good question
Good point! Not for me though. 😛
August 25, 2011 at 6:25 am
#1373082
Basics is just what I need. My SQL career is still an infant. 😛
August 25, 2011 at 6:16 am
#1373072
Learning more and more each day! Thanks!
August 25, 2011 at 6:10 am
#1373069
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
#1369540