Viewing 15 posts - 16 through 30 (of 130 total)
<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<Body>
<ReportItems>
<Tablix Name="table1">
<TablixBody>
...
November 21, 2015 at 9:29 am
Thanks much PietLinden!!!
Wonderful and simple solution!!!
Thanks for your tolerance of my output error, I made it manually so make typo.
My overnight learning produces that Report2.rdl which uses Recursive Parent option,...
November 21, 2015 at 9:28 am
Thanks Bill,
so it will work then,
what if I don't need B.*, I'll be fine with only A.* can it be done without JOIN?
M
September 28, 2015 at 11:32 am
Tx Much, Dohsan!
September 16, 2015 at 9:21 am
NTILE(4) OVER ( ORDER BY perc desc) RN
Bingo !!! thanks much Jacob !!!
M
July 13, 2015 at 5:00 pm
Gracias Luis
so we can call it SSIS language... -). I though it will be something like from SSRS.
Best
M
July 10, 2015 at 12:17 am
I finished handling that WHEN '' then NULL in Source SQL, could not find how to code this expression in derived column, is this syntax same like SSRS (VBA)...
July 9, 2015 at 5:33 pm
Tx, Ten
Did you mean that SQL snippet?
It's still not, there is SSRS rdl somewhere in hyperspace with 5 or so reports which do all this stuff interactively with bunch of...
June 20, 2015 at 9:22 pm
Tx, I saw this sql snippet.
but I meant diff it's copmlete .rdl open source which have set of ssrs reports to run all kind of stats for reports usage, very...
June 20, 2015 at 5:39 pm
Now expanded my test into xml with multiple <testsuit>s and ran into small issue, I have same attribute name <name> for <testsuit> node and <testcase> node so produce...
May 5, 2015 at 9:58 am
Does anybody knows is it possible to break this sample file (attached in fist step) by whole node = testcase ?
Thanks
Mario
May 4, 2015 at 2:59 pm
Thanks again Erland for you help and jumpstart,
I finished writing loop sp and dynamic sql that will go over that xml to produce what I need
SELECT
c1.value('(testsuite/testcase/@internalid)[1]',...
May 4, 2015 at 1:17 pm
Viewing 15 posts - 16 through 30 (of 130 total)