Viewing 15 posts - 526 through 540 (of 607 total)
obligatory Oatmeal: http://theoatmeal.com/story/eat_horses
potentially NSFW, language.
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
June 8, 2017 at 12:41 pm
there's no false value at the end.
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
June 1, 2017 at 9:04 am
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")))
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 31, 2017 at 3:06 pm
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 31, 2017 at 2:55 pm
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...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 31, 2017 at 1:46 pm
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...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 25, 2017 at 12:10 pm
yeah, I'm on the dev side, so no. And no talking to my DBAs
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 25, 2017 at 8:19 am
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
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 25, 2017 at 8:09 am
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 25, 2017 at 7:22 am
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...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 25, 2017 at 6:27 am
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.
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 25, 2017 at 5:49 am
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...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 25, 2017 at 5:44 am
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...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 25, 2017 at 5:42 am
do the file formats differ? Or are they exactly the same column definitions, just different names?
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 25, 2017 at 5:39 am
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...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 25, 2017 at 5:37 am
Viewing 15 posts - 526 through 540 (of 607 total)