Forum Replies Created

Viewing 15 posts - 4,381 through 4,395 (of 5,502 total)

  • RE: dataset containing the max(date):

    Did you try the GROUP BY clause (for details please see BOL)?


    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]

    February 1, 2010 at 12:05 pm

    #1111861

  • RE: Add standard text to all stored procedures

    On my system the 2k5 templates are located at

    "C:\Programs\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\sqlworkbenchprojectitems\Sql\Stored Procedure\"

    It's easy to modify those templates.


    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]

    February 1, 2010 at 11:19 am

    #1111833

  • RE: Are the posted questions getting worse?

    Ray K (2/1/2010)

    lmu92 (2/1/2010)

    If you feel to have a look at a thread named

    VERY UNIQUE PROBLEM: Updating Table with XML Data in SQL 2005

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

    February 1, 2010 at 10:47 am

    #1111813

  • RE: Are the posted questions getting worse?

    If you feel to have a look at a thread named

    VERY UNIQUE PROBLEM: Updating Table with XML Data in SQL 2005

    Updating Table with Column Type of...


    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]

    February 1, 2010 at 10:34 am

    #1111802

  • RE: VERY UNIQUE PROBLEM: Updating Table with XML Data in SQL 2005

    The main reasons why I think you didn't get an answer yet:

    The "sample data" you posted are obviously so huge that it takes forever to open that thread. I strongly...


    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]

    February 1, 2010 at 9:49 am

    #1111753

  • RE: Last n records from a table

    sunil88_pal88 (2/1/2010)

    So why has microsoft has made some opposite of TOP .They should also have made BOTTOM

    They actually have. Sort of, at least...

    But is doesn't have anything to do 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]

    February 1, 2010 at 9:40 am

    #1111741

  • RE: Recursive Table Hierarchy?

    Since you start "from scratch" you might want to consider storing the hierarchy data as nested sets. For details please search for "Celko nested sets hierarchy". It might be 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]

    February 1, 2010 at 7:02 am

    #1111586

  • RE: fincial years

    Easiest way would be a calendar table holding each day in one column and the fiscal year information and other stuff you might need (e.g. work day yes/no, holidays) in...


    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]

    February 1, 2010 at 6:52 am

    #1111576

  • RE: max limit of varchar(max) in sql server 2005

    Instead of relying on forum information you could use BOL (BooksOnLine, the SQL Server help system) to get the information you're looking for:

    varchar [ ( n | max ) ]...


    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 29, 2010 at 3:34 am

    #1110602

  • RE: Query Log

    I would add that "feature" to the SQL script (so you can run and test it separately).

    You could either store the result of each query in a temp table 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]

    January 28, 2010 at 2:01 pm

    #1110357

  • RE: select query

    charipg (1/28/2010)

    Please correct the below query..........

    select max(myDate) from

    ( select field_1 myDate from myTable

    union all

    select field_2 myDate from myTable

    union all

    select field_3 myDate from myTable)

    If you add...


    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 28, 2010 at 1:46 pm

    #1110349

  • RE: select query

    charipg (1/28/2010)

    I am not able to provide the sample data.

    can you pls provide the sample query?

    You don't have to provide your real data. Get the basic concept and transform 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]

    January 28, 2010 at 1:19 pm

    #1110335

  • RE: Help whit Query Distinct

    add

    AND A.Piloto LIKE 'ACD%'

    to your WHERE clause.

    If that's not what you're looking for please provide sample data and expected results as described in the first link in my...


    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 28, 2010 at 1:14 pm

    #1110332

  • RE: select query

    charipg (1/28/2010)

    selecting one greatest value from 3 coloumns in a table.?

    Yes.

    How about sample data including your current query as requested before?


    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 28, 2010 at 1:10 pm

    #1110328

  • RE: select query

    Sounds like homework.

    If not, please provide sample data, expected result and what you've tried so far as described in the first link in my signature.


    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 28, 2010 at 1:03 pm

    #1110322

Viewing 15 posts - 4,381 through 4,395 (of 5,502 total)