Forum Replies Created

Viewing 15 posts - 5,281 through 5,295 (of 5,502 total)

  • RE: Exporting Table to multiple excel sheets based on a field in a table

    I'm (almost) copying one of the replies from today, so it seems like it's "Excel-day" 🙂

    I've just seen another thread (http://www.sqlservercentral.com/Forums/FindPost734494.aspx) that included the following link: http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/ .

    This link might...


    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]

    June 14, 2009 at 3:59 pm

    #1009403

  • RE: Are the posted questions getting worse?

    Jumpin' right in with dictionary stuff:

    As per Wiki: "A clique is a small group of people who like the same things."

    We do like the same thing here, which is working...


    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]

    June 14, 2009 at 3:33 pm

    #1009395

  • RE: Launching Excel VBA from SSIS?

    I've just seen another thread (http://www.sqlservercentral.com/Forums/FindPost734494.aspx) that included the following link: http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/ .

    This link might help you to get your data from Excel.

    Regarding the macro issue:

    I don't know how complicated...


    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]

    June 14, 2009 at 12:14 pm

    #1009352

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (6/14/2009)

    I have removed the account of our (un)professional1 friend from the system and deleted threads. Apologies to those of you that had to deal with him/her....


    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]

    June 14, 2009 at 11:29 am

    #1009336

  • RE: Are the posted questions getting worse?

    regarding our friend "Professional1" aka "forumloser" aka "dxmer":

    I reported the individual to Steve asking for clarification.

    The report is not about the way he's ignoring any replies or his attitude.

    It's about...


    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]

    June 14, 2009 at 2:16 am

    #1009265

  • RE: cancel account

    forumloser (6/13/2009)

    lmu92 (6/13/2009)

    I'm sure, site owners will take care of it and cancel your account as requested.

    So the final answer is there is no way to cancel an account once...


    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]

    June 13, 2009 at 3:54 pm

    #1009178

  • RE: cancel account

    forumloser (6/13/2009)

    How do I cancel my account?

    The easiest way:

    Sign off any threads and newsletters you subscribed to.

    Don't post anymore.

    Don't login anymore.

    As you can see, to sign off is...


    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]

    June 13, 2009 at 3:09 pm

    #1009173

  • RE: cancel account

    Hi dxmer,

    a few thought on your statement on the other thread:

    forumloser (6/13/2009)

    ...

    I apparently don't fit into the cliques that have been established here...

    What you call "cliques" we would call slightly...


    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]

    June 13, 2009 at 3:00 pm

    #1009170

  • RE: Iterating through XML node to provide multi column recordset

    Thanxalot Flo!

    Just sent you a PM...


    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]

    June 13, 2009 at 2:12 pm

    #1009165

  • RE: To write a query

    Please don't cross post.

    Discussion already started at thread http://www.sqlservercentral.com/Forums/FindPost734274.aspx


    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]

    June 13, 2009 at 1:51 am

    #1009027

  • RE: How can i split up the zipcode and city from my table?

    Steve Kinnaman (6/11/2009)

    Thank you Wayne. Thanks to you I even figured out how to retain the space in the swedish zip by adapting your script like this:

    select ...


    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]

    June 12, 2009 at 10:55 am

    #1008814

  • RE: How to get Saturday b/w two dates

    Since you already have date columns in your table, the following might help

    select from where datename(dw,dateCol)='Saturday'

    and datecol >=@start

    and datecol <=@end


    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]

    June 12, 2009 at 10:32 am

    #1008799

  • RE: How to count the occurences of weekdays in a year

    Please don't cross post!

    for reference see http://www.sqlservercentral.com/Forums/FindPost733984.aspx


    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]

    June 12, 2009 at 10:24 am

    #1008793

  • RE: Determining the number of business days between two dates

    Hi,

    I just used your question "determine the number of business days between two dates" and searched for exactly the same string on this site (search function on the upper right...


    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]

    June 12, 2009 at 10:21 am

    #1008790

  • RE: Iterating through XML node to provide multi column recordset

    Glad I could help!

    If you have any future issues regarding SQL Server get back to this forum.

    Considering the way you've provided the sample data I'm sure you'll get a real...


    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]

    June 12, 2009 at 9:11 am

    #1008739

Viewing 15 posts - 5,281 through 5,295 (of 5,502 total)