Forum Replies Created

Viewing 15 posts - 661 through 675 (of 3,666 total)

  • RE: Help! How to properly normalise a table from the start

    Sean Lange (6/17/2015)


    tomsharp85 (6/17/2015)


    Hi, I have a flat table with 17 columns of contact information with columns to seperate those contacts into different business classes. Here is the table:

    USE DataCompany

    CREATE...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure

    GilaMonster (6/17/2015)


    Please note: 10 year old post.

    Hopefully the OP isn't still looking for that procedure.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    TomThomson (6/15/2015)


    Ed Wagner (6/15/2015)


    Steve Jones - SSC Editor (6/15/2015)


    Jeff Moden (6/15/2015)


    The thing that scares me about that is that it worked. Add a mobility unit, a carbon power cell,...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: No of Months between two dates in YYYYMM format

    oops, misread the question.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Prompt for Date Range?

    Time for Excel to get an upgrade!

    Trying to do this without VBA is getting to be a pain in the ...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Prompt for Date Range?

    tsobiech (6/12/2015)


    Alvin Ramard (6/12/2015)


    Take a look at the link below. It should provide most of the information you need to do this from Excel.

    http://realworldsql.com/2012/06/07/stored-procedures-with-parameters-in-excel/

    Thanks for the link!

    However, when I...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Prompt for Date Range?

    Take a look at the link below. It should provide most of the information you need to do this from Excel.

    http://realworldsql.com/2012/06/07/stored-procedures-with-parameters-in-excel/

    Edit: oops. I didn't see the Luis' response before...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Prompt for Date Range?

    Sean Lange (6/12/2015)


    tsobiech (6/12/2015)


    I think I'm just going to have to resign myself to the fact that I'm going to have to "manually" change the dates, every time, then copy/paste/format...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Prompt for Date Range?

    If you want the view to always look at last quarter, then you could also dynamically calculate, in the view, what the start and end dates need to be.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    Ed Wagner (6/12/2015)


    Lynn Pettis (6/12/2015)


    Also, has anyone placed an order for silver spoons? Looks like we have a higher than normal demand.

    Yeah, and it's been going on for a...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: SSIS - How to Alert When Step Fails ?

    homebrew01 (6/12/2015)


    I have a simple SSIS package that imports an Excel Spreadsheet into a table. The column heading got changed, so the package failed, as expected, but I would...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    Disk unformatting is not that hard. Use DBCC TimeWarp with the correct value for parameter 83. 😎



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    Lynn Pettis (6/12/2015)


    Has anyone ever heard about "disk unformating?" Did not know if you formatted your hard drive you could undo it. Maybe if you imaged it first.

    Lynn,...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: The Rename Game

    freecellwizard (6/12/2015)


    ...

    Also next time I listen to two engineers debate CountryId vs. CountryID for an hour I'm gonna slap someone!

    It should be country_id. 😀

    (just kidding)



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Creating Dimension Based on Multiple Values Grouped in Fact Table

    My Invoice Header dimension probably could be referred to as a degenerate dimension. It was created to hold values that apply to the whole invoice for cases where a separate...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Viewing 15 posts - 661 through 675 (of 3,666 total)