Forum Replies Created

Viewing 15 posts - 256 through 270 (of 3,666 total)

  • RE: First date of the Month (to date on Range basis)

    Kristen-173977 (9/28/2015)


    Alvin Ramard (9/28/2015)


    Why:

    WHERE YourDateColumn >= @StartDate

    AND YourDateColumn < @DayAfterEndDate

    and not:

    WHERE YourDateColumn >= @StartDate

    ...



    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: First date of the Month (to date on Range basis)

    Kristen-173977 (9/28/2015)


    smer (9/28/2015)


    Hi Team,

    Help to get the Sql Query e.g when execute on 8/15/2015 get the records from 8/1/2015 to 8/15/2015, if run on 9/20/2015 get 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: When IsNumeric not numeric?

    Can you also look at the number of characters to filter out those that have extra characters?



    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: When IsNumeric not numeric?

    Sean Lange (9/25/2015)


    Alvin Ramard (9/25/2015)


    Sean Lange (9/25/2015)


    Alvin Ramard (9/25/2015)


    Sean Lange (9/25/2015)


    And let's not overlook the fact that the OP is converting a PO Number to a float. A numeric 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: When IsNumeric not numeric?

    Sean Lange (9/25/2015)


    Alvin Ramard (9/25/2015)


    Sean Lange (9/25/2015)


    And let's not overlook the fact that the OP is converting a PO Number to a float. A numeric would be a much better...



    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: When IsNumeric not numeric?

    Sean Lange (9/25/2015)


    And let's not overlook the fact that the OP is converting a PO Number to a float. A numeric would be a much better option than float. And...



    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?

    Matt Miller (#4) (9/23/2015)


    Alvin Ramard (9/23/2015)


    Steve Jones - SSC Editor (9/23/2015)


    Lynn Pettis (9/23/2015)


    I assume you are talking about the Jet thread. Do you think any of us have gotten...



    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 (9/24/2015)


    BWFC (9/24/2015)


    SQLRNNR (9/23/2015)


    Steve Jones - SSC Editor (9/23/2015)


    BWFC (9/23/2015)


    Promotion today :w00t: Yay me!!!!

    Congrats. With a raise?

    If no raise, then let them keep the promotion.

    Love the promotions where it...



    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: MS-Jet Engine 4.x ODBC enabled databases to 1 Terabyte/5 billion rows (or) SQL SERVER?

    erichansen1836 (9/23/2015)


    have you heard about SQL Developer edition?

    SQL Server 2014 Developer Edition lets developers build almost any kind of database application on top of SQL Server. It's licensed for use...



    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: MS-Jet Engine 4.x ODBC enabled databases to 1 Terabyte/5 billion rows (or) SQL SERVER?

    Sounds like this would take a lot of programming and testing before it could be considered safe and reliable. So much for your earlier comment saying this would require no...



    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: MS-Jet Engine 4.x ODBC enabled databases to 1 Terabyte/5 billion rows (or) SQL SERVER?

    erichansen1836 (9/23/2015)


    Recovery and restore is very important in the data world. It isn't always needed, but when it is, being able to recover data is very important to most businesses,...



    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?

    Steve Jones - SSC Editor (9/23/2015)


    Lynn Pettis (9/23/2015)


    I assume you are talking about the Jet thread. Do you think any of us have gotten out line?

    Well, since I'm about...



    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: Choosing values

    Luis Cazares (9/23/2015)


    Manic Star (9/23/2015)


    patricklambin (9/23/2015)


    Stewart "Arturius" Campbell (9/22/2015)


    Interesting question, thanks Steve

    Another of the functions copied from Excel.

    I don't think so. These functions have been introduced only to make easier...



    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 has released the hippo into that thread. Time to take cover. 🙂



    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?

    I think I saw the hippo hiding behind the wood shed.



    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 - 256 through 270 (of 3,666 total)