Viewing 15 posts - 556 through 570 (of 1,957 total)
Not entirely clear what you want, but it sounds like you want to get the stored procedure you are calling to handle this rather than using parameters in the report...
e.g....
February 23, 2014 at 5:05 pm
GilaMonster (2/12/2014)
http://thomaslarock.com/2013/05/top-3-performance-killers-for-linked-server-queries/
Thanks Gail, I did wonder if permissions on statistics was at play - (the other two scenarios in that article don't apply for me)
I can't run a profiler on...
February 12, 2014 at 5:15 am
Phil Factor (2/6/2014)
I really think there isn't any further need for the old number-table version of the string-split.
Phil, did you do any comparable testing between DelimitedSplit8k and XML based attribute...
February 6, 2014 at 5:15 pm
Hey George,
Any chance you could attach a sample report that demonstrates what you are trying to achieve?
See the link in my signature[/url] if you are not sure how to do...
February 6, 2014 at 4:28 pm
Borrowing Vijay's fine setup code for the sample data...
Here is a multiple CTE version, with no explicit temp tables (but the possibility of spilling into tempdb for large data sets)
with...
January 30, 2014 at 6:39 am
Nice job Jeff!
January 30, 2014 at 4:19 am
declare @x xml = '<event name="blocked_process_report" package="sqlserver" timestamp="2014-01-28T22:13:03.814Z">
<data name="duration">
<value>18655000</value>
</data>
<data name="database_id">
<value>2</value>
</data>
<data name="object_id">
...
January 28, 2014 at 5:54 pm
I would go one step further and say don't do anything to your year, month and day columns in the WHERE clause.
Use something like this instead:
WHERE year=? AND month=? AND...
January 28, 2014 at 5:46 pm
Lisa Slater Nicholls (1/28/2014)
In the case where you cannot post, you just need to be as precise as possible with your description and hope people understand.
MM I would agree with...
January 28, 2014 at 2:56 pm
Miles Neale (1/28/2014)
Oh Magoo, you've done it again! - Excellent piece of work!M.
Thank you so much for your kind words.
January 28, 2014 at 2:55 pm
Jeff Moden (1/28/2014)
January 28, 2014 at 9:12 am
andrew.edgar (1/28/2014)
Most organisations I have worked for would take disciplinary action against any employee who was found to be posting source code from within the organisation, so best...
January 28, 2014 at 6:22 am
So you didn't get them to explain the rules for a successful quirky update then I guess?
January 27, 2014 at 12:48 pm
Well. if you need help with that, could you please post some table creation scripts and sample data, along with the new view definition.
January 23, 2014 at 9:39 am
thomaslee2020 (1/23/2014)
this result i need to present out at C1ReportDesigner
I don't know the details of their report designer, but assuming it can generate a matrix style report like SSRS, I...
January 23, 2014 at 2:33 am
Viewing 15 posts - 556 through 570 (of 1,957 total)