Forum Replies Created

Viewing 15 posts - 1,786 through 1,800 (of 5,502 total)

  • RE: select multiple wild cards...

    You could use

    WHERE yourColumn LIKE 'A%' OR yourColumn LIKE 'B%' OR yourColumn LIKE 'C%'

    or just create a view with an additional column

    CASE WHEN yourColumn LIKE 'A%' OR yourColumn...


    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]

    March 7, 2011 at 1:00 pm

    #1295552

  • RE: Are the posted questions getting worse?

    Since you obviously put it back where it was, everything's fine, Ki 😀

    At a second glance: did you really COPY the 100-EURO bill??? Don't you know that's illegal?? 😛


    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]

    March 7, 2011 at 12:54 pm

    #1295545

  • RE: Are the posted questions getting worse?

    SQLkiwi (3/7/2011)

    Stefan Krzywicki (3/7/2011)

    Just send him money! If he gets enough he may feel guilty and decide he has to write a book.

    An excellent suggestion. 🙂

    I'm not going to flood...


    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]

    March 7, 2011 at 12:39 pm

    #1295538

  • RE: Test, fail, wait-a-while, test again

    You could either use a job to run every 5min or a sproc with WAITFOR DELAY.


    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]

    March 7, 2011 at 10:06 am

    #1295440

  • RE: comparing multiple rows from multiple columns

    duplicate post. no replies please.

    discussion already started here


    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]

    March 7, 2011 at 8:55 am

    #1295377

  • RE: code help needed

    One reason you might not have an answer by now is the missing information.

    Please provide table def and ready to sample data 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]

    March 7, 2011 at 3:39 am

    #1295233

  • RE: Exporting Data to Excel in multiple sheets

    Did you try to google it?

    I'm sure there are many solutions out there.


    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]

    March 7, 2011 at 3:36 am

    #1295232

  • RE: Export Report Data in to multiple sheets

    Duplicate post. No replies please.

    Original post can be found here


    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]

    March 7, 2011 at 3:33 am

    #1295230

  • RE: Export Report Data in to multiple sheets

    Duplicate post. No replies please.

    Original post can be found here


    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]

    March 7, 2011 at 3:33 am

    #1295229

  • RE: Help me asap pleas

    israel17_popeye (3/6/2011)

    thank you sir here's my new attachment the whole mdf file

    in the stored procedure you can see the ledger can you modife it if you want to! thank...


    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]

    March 6, 2011 at 9:02 am

    #1295106

  • RE: Help me asap pleas

    Table DDL and sample data in a ready to use format are still missing. Please reread the article I pointed you at.

    As a side note: there are seveal people around...


    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]

    March 6, 2011 at 5:29 am

    #1295092

  • RE: T-SQL 2000 to 2008

    What you could do is to search for the character string to be replaced automatically so at least you'll know what definitions you have to tackle. Search the script section...


    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]

    March 6, 2011 at 1:57 am

    #1295073

  • RE: How much is too much for a table variabe?

    The best article I came across so far: http://www.sqlservercentral.com/articles/Temporary+Tables/66720/


    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]

    March 6, 2011 at 1:52 am

    #1295072

  • RE: Help me asap pleas

    Please help us help you by providing ready to use test data, including table def and sample data (especially if your request is "urgent"...). For the best way on 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]

    March 6, 2011 at 1:48 am

    #1295071

  • RE: CXPACKET/Parallelism question

    SQLkiwi (3/4/2011)

    Ok, so the first part of my parallelism article went out a couple of days earlier than I expected :blush:

    Link: http://www.simple-talk.com/sql/learn-sql-server/understanding-and-using-parallelism-in-sql-server/

    What a fantastic article!!! GREAT job Paul! Thank you...


    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]

    March 5, 2011 at 4:01 am

    #1294978

Viewing 15 posts - 1,786 through 1,800 (of 5,502 total)