Forum Replies Created

Viewing 15 posts - 4,921 through 4,935 (of 5,502 total)

  • RE: return a row (with constants) even if query comes up blank

    edit: identical post.


    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]

    September 20, 2009 at 3:02 am

    #1056032

  • RE: return a row (with constants) even if query comes up blank

    edit: identical post.


    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]

    September 20, 2009 at 3:01 am

    #1056031

  • RE: return a row (with constants) even if query comes up blank

    untested, but it should work:

    IF EXISTS(SELECT 1 FROM mytable WHERE name ='myname')

    SELECT name, address, '12345' as zip from mytable WHERE name ='myname'

    ELSE

    SELECT 'name' AS name, 'address' AS address, '12345' as...


    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]

    September 20, 2009 at 2:59 am

    #1056030

  • RE: TSQL Select Treeview Data omiting nodes with no data

    Using your sample data from above and the CTE you already provided I added another recursive CTE to get the total amount of products pe section id.

    Then I eliminated all...


    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]

    September 18, 2009 at 3:27 pm

    #1055884

  • RE: Sql Join

    Would something like the following help?

    Please note the way sample data are posted...

    DECLARE @Number Table (Number int, Status_id int)

    INSERT INTO @Number

    SELECT 123400 ,1 UNION ALL

    SELECT 123401 ,2 UNION ALL...


    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]

    September 18, 2009 at 12:09 pm

    #1055784

  • RE: Find duplicate rows and keep the one with the highest value in one column

    Here's an example that might work. It's completely untested due to the lack of sample data. Therefore, I used a SELECT instead of DELETE statement.

    It doesn't require the temp table...

    ;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]

    September 17, 2009 at 4:27 pm

    #1055286

  • RE: Insert violates key only in stored proc, not in query window

    It would be really helpful to see the proc itself than guessing from what you described.

    Based on your description: it's unlikely to happen...


    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]

    September 17, 2009 at 1:05 pm

    #1055219

  • RE: TSQL Select Treeview Data omiting nodes with no data

    One reason you don't have any replies yet might be that it takes too much effort to create a test environment.

    Please read and follow the link in my signature on...


    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]

    September 17, 2009 at 1:02 pm

    #1055214

  • RE: Sql Join

    What have you tried so far?

    If you don't have a point to start at:

    You need a CROSS JOIN between your GROUPed numbers (reduced to either the LEFT 4 character or...


    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]

    September 17, 2009 at 12:58 pm

    #1055213

  • RE: Are the posted questions getting worse?

    Grant Fritchey (9/17/2009)

    ...Maybe my skin is getting thicker or scar tissue is building up....

    Scar tissues are distinctive marks for front line warriors!

    And you're definitely one of them 😉


    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]

    September 17, 2009 at 12:21 pm

    #1055196

  • RE: how to write the query with sub sub query

    Once it a while it's required to point out that we're all volunteers who are willing to help. The link above is just one possible way to transfer the message....


    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]

    September 17, 2009 at 12:15 pm

    #1055191

  • RE: Are the posted questions getting worse?

    Grant Fritchey (9/17/2009)

    Actually, I think that one was just a misunderstanding. He didn't get that Jeff was showing him how to set up a test for his index... I think....


    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]

    September 17, 2009 at 12:05 pm

    #1055183

  • RE: how to write the query with sub sub query

    This link should help you further.


    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]

    September 17, 2009 at 11:57 am

    #1055175

  • RE: how to write the query with sub sub query

    you might want to search for "split string function" on this site. There are many solutions available.


    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]

    September 17, 2009 at 11:21 am

    #1055144

  • RE: Are the posted questions getting worse?

    Now that's obviously an OP "who knows how to behave".... Calling Jeff a .... (my fingers actually refuse to retype the word and cut and paste won't work either).

    Combined...


    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]

    September 17, 2009 at 11:15 am

    #1055141

Viewing 15 posts - 4,921 through 4,935 (of 5,502 total)