Forum Replies Created

Viewing 15 posts - 3,526 through 3,540 (of 5,502 total)

  • RE: How to obtain week by week plus YTD totals

    TheSQLGuru (5/14/2010)

    Unfortunately I don't have the time to work this today, but shouldn't this be doable with simple CASE statements in a single pass? Hopefully someone else can work...


    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]

    May 14, 2010 at 9:17 am

    #1167622

  • RE: convert three fields into one datetime

    If you define your sour columns as character you might be able to use the following:

    SELECT CAST('2010'+'-'+'1'+'-'+'15' AS DATETIME)


    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]

    May 13, 2010 at 4:44 pm

    #1167239

  • RE: Display results even when there are none.

    The way you've arranged your tables you probably need a RIGHT OUTER JOIN to get all values from Staff.


    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]

    May 13, 2010 at 4:23 pm

    #1167233

  • RE: Bulk move notes from one customer record to another

    fawadafr (5/13/2010)

    Would this be a good table definition?

    SELECT .... FROM [CRMNote]

    GO

    Thanks for the reply!

    No, since the column definition is missing. There are no ready to use sample data either...

    Please...


    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]

    May 13, 2010 at 4:18 pm

    #1167232

  • RE: Bulk move notes from one customer record to another

    I would use ROW_NUMBER() OVER(PARTITION BY names, address, [basic contact info] ORDER BY hopefully_existing_rowid) as RowNmbr to identify the separate rows.

    The ROW_NUMBER would be used within a CTE in order...


    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]

    May 13, 2010 at 4:09 pm

    #1167229

  • RE: Sum pivot columns

    Would the following help?

    I'm using OVER (PARTITION BY) to get the total per idName.

    Side note: Since you already using dynamic SQL you might want to have a look 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]

    May 13, 2010 at 3:47 pm

    #1167217

  • RE: simple Insert - tune

    Tara,

    did you add any indexes after populating #EmployeeDur and Empgig1?

    If not, I guess the following indexes might help:

    Empgig1: EmpID,InDt include(EmpCode)

    #EmployeeDur: EmpID,StDate,EnDate

    Side note: Are you sure you need the DISTINCT clause...


    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]

    May 13, 2010 at 1:49 pm

    #1167171

  • RE: Free Advice or Free Consulting

    Excellent job, Grant!

    The only question that remains open is: Where to draw the line?

    But I guess it's almost impossible to answer...

    Interview questions, test/homework, almost complete projects, several hundred lines 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]

    May 13, 2010 at 6:04 am

    #1166785

  • RE: checkning for allowable values

    Jeff Moden (5/12/2010)

    Yes and no. You're certainly on the correct tract with making a table but it should be a permanent table instead of one built on the fly....


    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]

    May 12, 2010 at 4:43 pm

    #1166575

  • RE: checkning for allowable values

    Jeff Moden (5/12/2010)

    ...

    I'm still believe that the use of the Tally table here would be slower across a million rows than if the codes were stored in a nice...


    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]

    May 12, 2010 at 2:19 pm

    #1166523

  • RE: What is the accepted method for citing BOL in a presentation?

    I would quote the related msdn website.

    AFAIK, websites are allowed as references.

    e.g. http://msdn.microsoft.com/en-US/library/ms186734(v=SQL.90).aspx as a reference for the ROW_NUMBER() syntax.

    I would copy the website together with a date information for...


    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]

    May 12, 2010 at 1:53 pm

    #1166507

  • RE: How do I restrict a login to only 1 connectin to the database server?

    I second Brandie and Elliot regarding the sandbox db.

    Once that person "designed" a query he/she wants to run in production, that person should send the query to one of 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]

    May 12, 2010 at 1:46 pm

    #1166502

  • RE: XML XQuey Help

    Please re-read my previous post: I asked for your expected result based on your sample data. I can't find it...

    All I see is

    ROW # FIELD NAME 1 ... FIELD NAME...


    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]

    May 12, 2010 at 12:33 pm

    #1166460

  • RE: checkning for allowable values

    Joe Celko (5/12/2010)

    Don't use the race codes table; remove the code from the string and see if it has left-overs:

    REPLACE('I', '',

    REPLACE('N', '',

    REPLACE('P', '',

    REPLACE('B', '',

    REPLACE ( 'W', '', mutli_race_code),

    ),),),)...


    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]

    May 12, 2010 at 12:30 pm

    #1166456

  • RE: XML XQuey Help

    Maybe the reason you didn't get any reply yet is the way you posted your question.

    There are some people around (including myself) that prefer to have ready to use sample...


    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]

    May 12, 2010 at 10:34 am

    #1166367

Viewing 15 posts - 3,526 through 3,540 (of 5,502 total)