Forum Replies Created

Viewing 15 posts - 736 through 750 (of 5,502 total)

  • RE: "Null value is eliminated by an aggregate" Error without aggregates

    I'd say it's because of the Distinct operator in your query. Therewith you're using an aggregation similar to

    GROUP BY D.Col1, D.Col2, D.Col3, D.Col4, D.Col5, D.Co6, D.Col7,

    Agt.Col1, Agt.Col2, AH.Col1,...


    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]

    January 1, 2012 at 9:07 am

    #1427274

  • RE: Are the posted questions getting worse?

    Wishing you a Very Happy

    and

    Prosperous New Year!!! 🙂

    +1


    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]

    December 31, 2011 at 10:32 am

    #1427229

  • RE: help

    I just can repeat what I stated before:

    Please read and follow the advice given in the first link in my signature and post ready to use sample data together 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]

    December 31, 2011 at 1:07 am

    #1427180

  • RE: Virtualize or not ?

    benjamin.reyes (12/30/2011)

    LutzM (12/30/2011)

    Just make sure to charge them for the support (assuming your company had to pay for the product, too...)

    I wish it worked that way. :hehe:

    Though I'll settle 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]

    December 30, 2011 at 2:45 pm

    #1427133

  • RE: Virtualize or not ?

    benjamin.reyes (12/30/2011)

    Sounds like neither virtualization, nor throwing even more hardware at the problem will fix it.

    We've had pretty good success in partnering with our vendors in sharing performance data such...


    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]

    December 30, 2011 at 1:46 pm

    #1427121

  • RE: help

    Please read and follow the advice given in the first link in my signature and post ready to use sample data together with your expected result and what you've tried...


    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]

    December 30, 2011 at 10:57 am

    #1427075

  • RE: SQL running very slow from .Net

    WangcChiKaBastar (12/30/2011)

    ok

    Its actually an iterative call to a Stored Proc from .Net

    and the proc runs super fast on SSMS. every call it fetches 2 to 3 rows and

    returns data 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]

    December 30, 2011 at 10:37 am

    #1427070

  • RE: Query Result in Mail

    The data in the file will be in the same order as specified in the original query. If there's no ORDER BY in the SELECT statement then you can't expect...


    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]

    December 30, 2011 at 10:31 am

    #1427068

  • RE: sql query

    It's not really a duplicate post...

    In this post the account number for "00011 0055500ABC" should be 0055500 whereas in the post Gianluca referenced the expected result is 0055500AB...

    @mario:

    I strongly recommend...


    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]

    December 30, 2011 at 5:10 am

    #1426890

  • RE: sql query needed

    Thanx, Dev.

    At least I didn't waste too much time on it...


    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]

    December 30, 2011 at 5:01 am

    #1426884

  • RE: sql query needed

    Didn't see your latest reply, I'm sorry...

    What is the logic to get "P" based on "0047225P1"? Shouldn't it be "1"?


    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]

    December 30, 2011 at 4:33 am

    #1426865

  • RE: sql query needed

    Based on what you provided so far, this could be one solution:

    SELECT '004722' AS [serial number] , 'P' AS letter

    UNION ALL

    SELECT '0055500AB' AS [serial number] , 'C' 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]

    December 30, 2011 at 4:30 am

    #1426862

  • RE: Returning More then one thing from a Function

    You don't need a function to return the values you're looking for:

    In your sproc simply use the select statement:

    SELECT

    @UserFullName = chrFullName,

    @UserEmail = chrEmail

    FROM[User]

    WHERE intUserID...


    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]

    December 30, 2011 at 4:17 am

    #1426854

  • RE: How view will help in performance and how can i identify tempdb is full

    Are those questions part of an interview?


    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]

    December 30, 2011 at 2:44 am

    #1426809

  • RE: Query Result in Mail

    logicinside22 (12/29/2011)

    I tired with this option but i am getting blank excel file in mail.

    Does the query return any result at all when executed using the same query window 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]

    December 29, 2011 at 2:34 pm

    #1426724

Viewing 15 posts - 736 through 750 (of 5,502 total)