Forum Replies Created

Viewing 15 posts - 1,201 through 1,215 (of 1,957 total)

  • RE: Don't Criticize Code

    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...

  • RE: Error occurs when I add a rollback tran inside my trigger

    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,...

  • RE: a ITVF string concatenation without "FOR_XML"

    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...

  • RE: Strip HTML Tags

    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...

  • RE: Strip HTML Tags

    is it HTML or XHTML?

    also, +1 on Jeff's questions...

  • RE: Extracting data into Table using OpenXML

    maximation (10/20/2011)


    My actuall code is slightly different. The reason I need to use openXML is because I plan to automate this import as the XML content would be part of...

  • RE: Extracting data into Table using OpenXML

    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--...

  • RE: SSRS Caching

    Sorry, I hadn't taken in that you said "data driven subscription"...

  • RE: SSRS Caching

    okbangas (10/13/2011)


    In theory, this is fine. However, as the parameter list is dynamic this is not an option for me. Thanks for the response though, as this may be an...

  • RE: SSRS Caching

    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...

  • RE: Cleaning cash in Reporting Service

    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...

  • RE: Recursive CTE assistance

    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...

  • RE: Recursive CTE assistance

    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...

  • RE: DateAdd function returns wrong result

    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...

  • RE: XQuery xml.value help

    You are most welcome.

Viewing 15 posts - 1,201 through 1,215 (of 1,957 total)