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...
-- Itzik Ben-Gan 2001
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.
-- Itzik Ben-Gan 2001
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...
-- Itzik Ben-Gan 2001
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...
-- Itzik Ben-Gan 2001
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...
-- Itzik Ben-Gan 2001
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...
-- Itzik Ben-Gan 2001
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...
-- Itzik Ben-Gan 2001
June 5, 2015 at 9:11 am
Jeff Moden (6/5/2015)
Alan.B (6/4/2015)
-- Itzik Ben-Gan 2001
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.
-- Itzik Ben-Gan 2001
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...
-- Itzik Ben-Gan 2001
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...
-- Itzik Ben-Gan 2001
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...
-- Itzik Ben-Gan 2001
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...
-- Itzik Ben-Gan 2001
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...
-- Itzik Ben-Gan 2001
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...
-- Itzik Ben-Gan 2001
June 4, 2015 at 9:44 am
Viewing 15 posts - 1,381 through 1,395 (of 2,458 total)