Forum Replies Created

Viewing 15 posts - 3,241 through 3,255 (of 5,502 total)

  • RE: Convert CSV values in three columns to rows

    Jeff Moden (6/27/2010)

    ...

    Yes... you are correct... the search capabilities on this forum suck. I'm sure that Lutz will be back soon with his split function.

    That's something I cannot confirm...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    June 28, 2010 at 12:09 pm

    #1185955

  • RE: Are the posted questions getting worse?

    Lynn Pettis (6/27/2010)

    I will agree that there have been some bad calls, some made and some that should have. Over all, however, I think the officiating has been good....


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    June 28, 2010 at 11:33 am

    #1185941

  • RE: Insert 1,000 records in one second

    Hmmm, I'm curious what the OP think about the responses...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    June 28, 2010 at 11:04 am

    #1185936

  • RE: Are the posted questions getting worse?

    Matt Miller (#4) (6/27/2010)

    ...

    It's hard to even support that claim (the "dodgy decision" one). I can't believe FIFA actually tolerates the shoddy refereeing that's being shown. It seems like...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    June 27, 2010 at 4:45 pm

    #1185453

  • RE: Convert CSV values in three columns to rows

    Here's how I'd do it:

    Step 1: UNPIVOT the data to get a more normalized data structure.

    Step 2: Apply the string split function (side note: you might want to either search...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    June 27, 2010 at 3:38 pm

    #1185446

  • RE: Insert 1,000 records in one second

    irmorteza2000 (6/27/2010)

    Hi

    Suppose we have a website with 1,000 viewers each second. And we want to insert the viewer’s information(for example) to the SQL database. So we must insert 1,000 records...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    June 27, 2010 at 2:58 pm

    #1185443

  • RE: Are the posted questions getting worse?

    To all UK soccer fans:

    I'm truly sorry for having such a blind (assistant) referee! The "Wembley-like" English goal was clearly in... At least this time (I'm not talking about '66...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    June 27, 2010 at 9:04 am

    #1185429

  • RE: Create Monthly Difference Report from One Table

    kpsr_kpsr 63487 (6/25/2010)

    Hey did u get the solutions for that man?, if u not plz ping me, then i will give idea,whether it works or not, I tried same scenario...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    June 25, 2010 at 4:18 am

    #1184898

  • RE: find the percentage of two column value with grouping records

    You could use CTE's

    Something like

    ;

    WITH cte1 as

    (

    select zone, count([incident id]) as cnt1

    from incident_detail

    group by zone

    ), cte2 as

    (

    select zone, count([incident id]) as cnt2

    from incident_detail

    ...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    June 25, 2010 at 4:17 am

    #1184896

  • RE: better approach for incremental loading in ssis

    duplicate post.

    Please reply here.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    June 25, 2010 at 4:11 am

    #1184894

  • RE: Help with (probably simple) query

    Here's my approach:

    ;WITH cte AS

    (

    SELECT

    relationid,

    ROW_NUMBER() OVER(PARTITION BY ProductId

    ORDER BY CASE WHEN XAML IS NULL THEN 2 ELSE 1 END, DateRelated DESC) AS ROW

    FROM ...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    June 25, 2010 at 4:05 am

    #1184890

  • RE: Stop users using SET LANGUAGE

    Jinx-640161 (6/25/2010)

    ...

    Does this make sense?

    I did suggest a change to the way the apps generate the inserts (by as you suggested removing the '-'), but they just stared at me...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    June 25, 2010 at 3:55 am

    #1184881

  • RE: XML Query Help

    Ray's approach won't give you the requested result since it will always return all rows. Just test it with rows holding an XML string without the Location element or with...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    June 25, 2010 at 2:36 am

    #1184861

  • RE: Error Converting Varchar to Decimal Strange Behavior

    It's a common misinterpretation to assume ISNUMERIC() will work like "OnlyNumbers".

    Here's an alternative:

    DECLARE @a VARCHAR(10)

    SET @a='1e10'

    SELECT ISNUMERIC(@a)

    IF @a NOT LIKE '%[^0-9]%'

    SELECT 'numeric'

    ELSE SELECT 'not numeric'

    You could also search this site...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    June 25, 2010 at 1:55 am

    #1184837

  • RE: Stop users using SET LANGUAGE

    If you're able to remove the dashes prior or during insert it will work independend of any language setting, since SQL Server will identify '20100625' as YYYMMDD.

    Could you describe a...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    June 25, 2010 at 1:39 am

    #1184830

Viewing 15 posts - 3,241 through 3,255 (of 5,502 total)