Forum Replies Created

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

  • RE: Regarding sql server dba(queries)

    Oksana March (11/26/2011)

    Personally, I hate when people tell me to "Google it" or look in Books Online (everyone knows already there is that option, why remind?) Therefore, I'll try 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]

    November 27, 2011 at 3:09 am

    #1413157

  • RE: Get Dates of Month listed as Columns

    I'd rather go with the classic CrossTab approach (see related links in my signature).

    The code is not only easier to read and to expand (e.g. to include "nested" pivots), it's...


    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]

    November 27, 2011 at 2:46 am

    #1413156

  • RE: Access 2010 to SQL 2008 R2 ODBC Error

    Can you open the linked tables in Access?

    Can you create a new view using the linked tables?


    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]

    November 25, 2011 at 10:49 am

    #1413044

  • RE: Using T-SQL to manipulate Excel files in a SQL Table

    I just came across this link (Replicating Excel 2003 Formulas to SQL Server).

    Might be worth looking into 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]

    November 25, 2011 at 10:39 am

    #1413040

  • RE: Excel RATE function replication SQL Server

    A google search provided quite a few links claiming to provide an Excel-like functionality.

    Some of the solutions are CLR based and should return the correct result. ("correct" in terms 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]

    November 25, 2011 at 10:23 am

    #1413038

  • RE: Distinct-tify TWO columns into ONE column

    There's only one person being able to answer that 😉

    But the chances on your side aren't too bad...

    If all the code I provided does is to show how important consistent...


    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]

    November 25, 2011 at 9:51 am

    #1413022

  • RE: Distinct-tify TWO columns into ONE column

    @Cadavre: Your code returns 2011-10-31 which is not part of the expected result.

    I'd throw a DISTINCT into the ring:

    SELECT DISTINCT Date2 AS DateOutput FROM @TABLE


    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]

    November 25, 2011 at 9:26 am

    #1413016

  • RE: Problem with ServiceBroker Queue

    If the queue is "overloaded" it usually means there is no process receiving the messages.

    Deleting the queue is not really the way the messages should be "cleared".

    Rusanus blog[/url] might help...


    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]

    November 24, 2011 at 3:12 pm

    #1412806

  • RE: SQL Server 2008 R2 slow after a week

    There's simply not enough information...

    What exactly do you mean by "getting slow"?

    You'll need to figure out if there are specific queries getting slower and where those queries get the data...


    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]

    November 24, 2011 at 3:01 pm

    #1412803

  • RE: How to import Excel data into CSV file?

    Are you sure SSIS is the right tool to do it?

    CSV is a rather straight forward format of Excel. But Excel is not really a database source...

    A short VB script...


    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]

    November 24, 2011 at 2:38 pm

    #1412798

  • RE: Distinct-tify TWO columns into ONE column

    SELECT Date2 AS DateOutput FROM YourTable ??

    It's most probably not the code you're looking for, but it's a valid solution based on your sample data... You might want to be...


    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]

    November 24, 2011 at 2:34 pm

    #1412797

  • RE: Converting varchar(50) to date time

    SELECT STUFF(CONVERT(VARCHAR(11),CONVERT(datetime,'20071015',112),113),1,3,'')

    As a side note: "ASAP" is not really among the preferred phrases on this site... It's usually combined with the word "money" 😉

    Edit: two more issues:

    1) it's highly recommended...


    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]

    November 24, 2011 at 2:25 pm

    #1412796

  • RE: Can someone tell me how to write this query? Thanks

    Revenant (11/24/2011)

    This may or may not be correct.

    What does it mean, "since last year"?

    As of this moment, GETDATE() will return 11/24/2011 12:45 and some seconds.

    Do you want data from 11/24/2010...


    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]

    November 24, 2011 at 2:12 pm

    #1412794

  • RE: Can someone tell me how to write this query? Thanks

    You didn't mention anything about the parameter @timeline, just three scenarios...

    Based on more than 500 points on your side I would have expected you know how to provide ready 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]

    November 24, 2011 at 1:32 pm

    #1412783

  • RE: Can someone tell me how to write this query? Thanks

    see my reply on your original 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]

    November 24, 2011 at 1:00 pm

    #1412778

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