Viewing 15 posts - 1,381 through 1,395 (of 2,458 total)
tuktukg (6/5/2015)
gotcha.....but how do i set the parameter to be the correct agentname on that row then pass it to the agent report?T
Perhaps I'm missing your question and don't have...
June 5, 2015 at 12:59 pm
If you're using text box properties > action > go to report you have the option to include parameters.
June 5, 2015 at 11:01 am
RonKyle (6/5/2015)
Populating a date dimension can be done using a tally table. No loop necessary.
The code executes faster but it is also a LOT simpler to write than a loop.
The...
June 5, 2015 at 10:47 am
robert.sterbal 56890 (6/5/2015)
Most government jobs have published salaries.This is for Illinois teachers:
http://www.familytaxpayers.org/ftf/ftf_salaries.php
I found a spreadsheet for the city of Pittsburgh at:
https://docs.google.com/spreadsheets/d/1AgIDIpQ4B-u0C2RrnYFEgdnpJKlWH0qyBGkhRTiOK9A/edit?pli=1#gid=0
That's totally different because we, as tax payers, pay those...
June 5, 2015 at 9:36 am
steeleye1 (6/5/2015)
It seems to me that the only reason that it can be a "disaster" to share salary information is because of inequality.
I'm guessing that was in response to my...
June 5, 2015 at 9:32 am
Yes, and it's common to have machines with multiple instances. When you run the setup you have the option to add a new instance. You can have multiple instances of...
June 5, 2015 at 9:23 am
j-1064772 (6/5/2015)
[font="Comic Sans MS"]This also does not help with the added complexity of wanting it sorted up or down![/font]
Nope. And it can't. Perhaps I should have mentioned that. This is...
June 5, 2015 at 9:11 am
Jeff Moden (6/5/2015)
Alan.B (6/4/2015)
June 5, 2015 at 8:45 am
ukarjee (4/26/2012)
Can dynamic sql help?
yep.
Edit. Jeez, did not see that this article was a re-run. No coffee yet this morning.
June 5, 2015 at 7:25 am
RonKyle (6/5/2015)
cursors are there to be used for admin scripts to be executed manually
I like this caveat, especially as it now excuses my one use I have for looping in...
June 5, 2015 at 7:19 am
Dynamic SQL as Luis showed is the way to go here. I don't know if this helps; I used my own sample data. Just another way to go about this:
DECLARE...
June 4, 2015 at 9:50 pm
I had boss once, a VP, who was not all that bright and he would share his Outlook calendar; nothing wrong with that - we all shared our calendars (and...
June 4, 2015 at 9:33 pm
I have a get numbers function that I use for exactly this sort of thing. It comes in handy often...
IF OBJECT_ID('dbo.GetNumsAB','IF') IS NOT NULL
DROP FUNCTION dbo.GetNumsAB;
GO
CREATE FUNCTION dbo.GetNumsAB(@low int, @high...
June 4, 2015 at 6:17 pm
Grant beat me to it.
I only just started using extended events and have a lot to learn but I have found that querying the file directly has been pretty...
June 4, 2015 at 5:51 pm
HLogic (6/4/2015)
nycdotnet (6/18/2013)
Interesting article. Regarding the paradox of semicolons on CTEs - the rule is "the statement before the CTE has to end with a semicolon".
I believe...
June 4, 2015 at 9:44 am
Viewing 15 posts - 1,381 through 1,395 (of 2,458 total)