Viewing 15 posts - 1,201 through 1,215 (of 1,957 total)
Thanks for the article Phil.
I agree that bad criticism along the lines of "oh wow! look what this idiot did!" is not helpful and just shows you up as ignorant.
There...
November 13, 2011 at 5:58 pm
Hi, I assume (as you have not told us) that the problem is that when you roll back the transaction, you get an error
Msg 3609, Level 16, State 1,...
November 2, 2011 at 7:36 pm
Agreed, that FOR XML PATH is quickest.
Here is an alternative that is definitely slower and has it's own limitation.
CREATE FUNCTION [dbo].[_some_function]
(
@poolint,
@Eventint,
@delimiter varchar(100)
)
RETURNS TABLE
AS
RETURN
(
with base(value,line) as
(
SELECT T1.object_value
, row_number() OVER...
November 2, 2011 at 9:31 am
Jeff Moden (10/30/2011)
I tried turning it into an iTVF instead of a scalar function and it took twice as long to run.
I also tried and it took half as long....
CREATE...
October 31, 2011 at 9:34 am
maximation (10/20/2011)
October 20, 2011 at 8:26 am
You are only asking for one node "CostCenters"...
DECLARE @docHandle int
DECLARE @XmlDocument nvarchar(1000)
SET @XmlDocument = N'<?xml version="1.0" encoding="UTF-16"?>
<EventCostCenters xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns="http://www.tempuri.org/CostCenter.xsd">
<TranDate>2011-03-05</TranDate>
<CostCenters>
<CostCenter Allocation="50">
<JDEAccountCode>ABC.110</JDEAccountCode>
</CostCenter>
<CostCenter Allocation="51">
<JDEAccountCode>XYZ.110</JDEAccountCode>
</CostCenter>
</CostCenters>
</EventCostCenters>'
EXEC sp_xml_preparedocument @docHandle OUTPUT, @XmlDocument,
'<CostCenters xmlns:ns1="http://www.tempuri.org/CostCenter.xsd"/>'
SELECT * FROM--...
October 19, 2011 at 6:29 pm
Sorry, I hadn't taken in that you said "data driven subscription"...
October 13, 2011 at 6:48 pm
okbangas (10/13/2011)
October 13, 2011 at 3:30 am
Hi Ole,
I don't know if this works.... but have you tried creating linked reports with the parameters defaulted on each linked version to the different required values and see if...
October 12, 2011 at 5:03 pm
When you are designing the report in Visual Studion/BIDS, it stores a cache of the data in the same folder as the report - with an extension of ".data".
You can...
October 7, 2011 at 5:20 am
Hi jeffem,
Ok, so first the CTE: you have not "missed" anything really, but you have found one of the problems associated with using a recursive CTE for this type of...
September 29, 2011 at 5:26 pm
Which is more important to you ?
Learning about recursive CTEs
OR
Getting the required query results?
I ask because we can teach you about CTEs or we can show you the better...
September 29, 2011 at 12:03 pm
It's short months for sure.
If you add two months to 30th dec 1899 you get 28th feb 1900.
If you add two months to 31st dec 1899 you get 28th feb...
September 28, 2011 at 4:34 pm
Viewing 15 posts - 1,201 through 1,215 (of 1,957 total)