Forum Replies Created

Viewing 15 posts - 5,131 through 5,145 (of 5,502 total)

  • RE: SQL Pass Through Query in Access 07 trying to move functionality to SQL Server 2005

    duplicate post.

    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]

    July 8, 2009 at 3:29 pm

    #1021977

  • RE: Pass Through Query in Access 07

    edit: system forced a double 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]

    July 8, 2009 at 3:26 pm

    #1021975

  • RE: Pass Through Query in Access 07

    duplicate post.

    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]

    July 8, 2009 at 3:25 pm

    #1021973

  • RE: NEED HELP WITH T-SQL ...........MORE OF A DISCUSSION; MICROSOFT'S GUI DESIGN..

    SSIS (7/6/2009)

    ... To be honest with I was not expecting a real good answer or solutions, ...

    You might want to put some more confidence in this community! 😉

    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]

    July 7, 2009 at 3:14 pm

    #1021353

  • RE: Payroll Database

    Since Albania submitted an apply for admission to the EU, you'd be faced with European (minimum) standards in terms of taxes a.s.o. sooner or later.

    If you'd do your payroll system...


    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]

    July 7, 2009 at 2:16 am

    #1020917

  • RE: select

    What is the "target system" of your 25Mill rows? (flat file, different database/system, maybe even SSMS (???))

    What are you trying to do with that rather large amount of 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]

    July 6, 2009 at 5:28 pm

    #1020776

  • RE: Payroll Database

    vblllove (7/6/2009)

    This Payroll System will not be apply to USA System. This will be in Europe. That's why we need a Unique System since the most of Software system are...


    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]

    July 6, 2009 at 5:01 pm

    #1020767

  • RE: NEED HELP WITH T-SQL ...........MORE OF A DISCUSSION; MICROSOFT'S GUI DESIGN..

    Jack Corbett (7/6/2009)

    Lutz has set you on the right direction, I think. Here is what Lutz was looking for and leading to, I think:

    @ Jack: that's pretty much exactly...


    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]

    July 6, 2009 at 4:41 pm

    #1020761

  • RE: NEED HELP WITH T-SQL ...........MORE OF A DISCUSSION; MICROSOFT'S GUI DESIGN..

    Hi,

    if I'd have ready to use data s describe in my signature (as well as in the sig of many other posters on this forum) I might be able 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]

    July 6, 2009 at 4:09 pm

    #1020743

  • RE: How I do change from push to pull subcription

    duplicate post. (please don't cross post.)

    original post: http://www.sqlservercentral.com/Forums/FindPost747776.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]

    July 6, 2009 at 12:19 pm

    #1020554

  • RE: Find New Customers

    Hi VampireGhost,

    Thank you for providing the sample data in a ready to use format! Good job! 🙂

    Regarding the SELECT statement:

    Instead of using the IN clause I'd rather use something like:

    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]

    July 6, 2009 at 11:58 am

    #1020536

  • RE: SQL brian teaser...

    Hi Digs,

    I'm just curious:

    Have you ever tried the DelimitedSplit function as per this post?

    If yes, then you'd have noticed there always have been two columns...

    When looking at the...


    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]

    July 5, 2009 at 6:02 pm

    #1020154

  • RE: Find New Customers

    Hi Matt,

    as you probably figured it's hard to verbally describe a database scenario with just a few words...

    It's also hard for some of us to "draw the picture".

    Maybe you could...


    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]

    July 5, 2009 at 5:47 pm

    #1020151

  • RE: SQL Split query

    Jeff Moden (7/5/2009)

    Very cool, Wayne... Guess I'll transfer all of my test results and explanations to that.

    I just did. Definitely not all of them but most of what I could...


    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]

    July 5, 2009 at 5:17 pm

    #1020148

  • RE: SQL brian teaser...

    Hi digs,

    what's missing in your post is something like

    CREATE TABLE #a(some cols)

    INSERT INTO #a(selective cols)

    SELECT [sample data] UNION ALL

    SELECT [more sample data] UNION ALL

    SELECT [even more sample data]

    --target structure

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

    July 5, 2009 at 5:04 pm

    #1020144

Viewing 15 posts - 5,131 through 5,145 (of 5,502 total)