Forum Replies Created

Viewing 15 posts - 3,841 through 3,855 (of 5,502 total)

  • RE: Recursive cross join to get all available combinaisons

    I'm not sure if I fully understood the requirement...

    But I would consider building a permanent table holding all variations and query that one based on the number of shippings.

    Maybe the...


    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]

    April 7, 2010 at 3:45 pm

    #1147815

  • RE: Are the posted questions getting worse?

    Tom.Thomson (4/6/2010)

    You know, the first time I played with a computer was in 1966 (it was the Ferranti-Packard Orion II at RHEL) and by the middle of 1970 I had...


    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]

    April 7, 2010 at 2:32 pm

    #1147772

  • RE: Two job offers..two different companies

    That's easy: It depends 😀

    You need to think about what's best for YOU. It's not relevant what we think would be best for us. Some of us might vote for...


    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]

    April 7, 2010 at 1:31 pm

    #1147712

  • RE: Peroformance Question

    Looking back without relevant trace files in place during that time is probably hard to do (if possible at all).

    I would ask the developer to wrap that query into 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]

    April 7, 2010 at 1:14 pm

    #1147703

  • RE: How to fing first letter is a number or letter in a column

    I'd rather test for a number instead of using the ISNUMERIC function.

    Among others, "+-.," are valid when testing against ISNUMERIC

    Example:

    DECLARE @test-2 CHAR(3)

    SET @test-2 ='.10'

    SELECT ISNUMERIC(LEFT(@test,1)),CASE WHEN @test-2 LIKE '[0-9]%' THEN...


    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]

    April 7, 2010 at 12:58 pm

    #1147696

  • RE: Importing XML data contained in a table's column to another table

    RV-813525 (4/7/2010)

    Lutz,

    Its a great reply

    Thank you, RV!

    I hope one or the other method is useful, not only for the OP.


    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]

    April 7, 2010 at 12:24 pm

    #1147667

  • RE: How many of you are not true DBA's?

    I'm working in project management, sometimes as a project manager, sometimes as a "link to translate" between business reps and software vendor.

    Since I'm focused on SQL Server projects, I decided...


    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]

    April 7, 2010 at 12:20 pm

    #1147663

  • RE: Importing XML data contained in a table's column to another table

    Hi,

    here's a rather large sample of various methods using XQuery.

    Unfortunately, you didn't provide a "translation list", meaning what nodes you'd like to see in what column. Therefore, I had to...


    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]

    April 7, 2010 at 11:59 am

    #1147638

  • RE: UDF, Computed Column, Persisted, Determinism

    @ Paul:

    Interesting!

    What do I misread/misunderstand when reading BOL?

    I thought what you just demonstrated wouldn't be possible...

    It looks like query optimizer is using ISNULL to override the columns NULL definition.

    VERY NICE!!...


    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]

    April 6, 2010 at 2:59 pm

    #1146814

  • RE: UDF, Computed Column, Persisted, Determinism

    Paul White NZ (4/6/2010)

    Al B (4/5/2010)

    Any thoughts would be greatly appreciated. If I'm barking up the wrong tree, I'd love to hear some alternate solutions.

    The problem here is not one...


    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]

    April 6, 2010 at 1:52 pm

    #1146768

  • RE: Importing XML data contained in a table's column to another table

    I'll second RV.

    Using XQuery inside a stored procedure is most probably the easier way.

    If you need assistance please post sample data and expected result in a ready to use format...


    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]

    April 6, 2010 at 12:11 pm

    #1146698

  • RE: UDF, Computed Column, Persisted, Determinism

    Jeff Moden (4/5/2010)

    lmu92 (4/5/2010)

    ...at least use a table-valued function.

    Teaching opportunity here, Lutz. Tell the op "why" and how you'd use an iTVF in a computed column. 😉

    I guess I...


    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]

    April 6, 2010 at 10:27 am

    #1146618

  • RE: UDF, Computed Column, Persisted, Determinism

    Why don't you use a view instead?

    And, if you really want to use a UDF, at least use a table-valued function.

    Something like

    CREATE FUNCTION your_function (@ParentID int, @Keyword nvarchar(255))

    RETURNS TABLE

    AS

    RETURN

    (

    ...


    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]

    April 5, 2010 at 5:44 pm

    #1146119

  • RE: Are the posted questions getting worse?

    Kit G (4/5/2010)

    ... Memories of holding my breath during reboot hoping that the operating system (Windows 3.11) would come up abound. ...

    Wasn't Windows 3.11 "just" an application back...


    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]

    April 5, 2010 at 9:29 am

    #1145792

  • RE: Sql Query on one table sub query required

    What would be your expected output based on some sample data provided asdescribed in the first link in my signature? (Your current post doesn't really include a quesition...)

    Side note: How...


    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]

    April 4, 2010 at 2:21 am

    #1145424

Viewing 15 posts - 3,841 through 3,855 (of 5,502 total)