obligatory Oatmeal: http://theoatmeal.com/story/eat_horses

potentially NSFW, language.

there's no false value at the end.

I think they're usually csv, have you tried:

=iif(Parameters!vType.Value = "Red", "Red", iif(Parameters!vType.Value = "Green", "Green", iif(Parameters!vType.Value = "Yellow", "Yellow", "Red,Green,Yellow")))

Steve, https://www.sqlservercentral.com/Forums/1878981/How-can-I-create-a-report-from-the-supplied-table has PHI posted, in some cases it looks like they tried to de-identify, but I can clearly see age/gender and find a real doctor's name. Please scrub that...

check out some options online: https://gallery.technet.microsoft.com/scriptcenter/c0c57332-8624-48c0-b4c3-5b31fe641c58 or https://stackoverflow.com/questions/436351/how-do-i-find-a-value-anywhere-in-a-sql-server-database, I ended up having to do this very thing today and was working on rolling my own, but these...

yeah, I'm on the dev side, so no. And no talking to my DBAs

any chance you can combine the data in your data pull before you return it as a dataset? make it look the way you want, then retrieve it

cleaning up someone else's code is always fun. modifying something to work for all states instead of the one, and whoever wrote this one put (NOLOCK) after every local temp...

is the salary annualized? If so, you'll want to find the monthly amt ((gross+skill)/12) and add up the months at that level, will change your avg.

if you haven't done anything with it, then I would agree, it's not eating resources. If you opened it, generated a temp table with 1 million rows, then didn't drop...

haven't tried it, but does the visibility property allow you to achieve this by only being true if it's one of those dates?

alternatively, have a chart that summarizes...

do the file formats differ? Or are they exactly the same column definitions, just different names?

normalize your salesman table, first. you shouldn't have multiple concepts in one column. Then you'd have to check to see whether you're searching for a manager level or sales rep...