Post reply

how to write a stored procedure to check if the members membership has expired

  • November 24, 2012 at 4:45 am

    #271150

    i have a table named users where i have two three column userid, email, membershipexpiry

    i want to write a stored procedure tat will take email as a input from the front hand and compare the current date with the date stored int the membershipexpiry column in the database its should be less then or equal to the current date if the membership hasn't expired it should return 1 or else 0.

    plz help me

    thanks in advance

    sanjay

  • November 24, 2012 at 4:17 pm

    #1562003

    This is a duplicate post. Please, no answers here. Instead, please see http://www.sqlservercentral.com/Forums/Topic1388300-391-1.aspx

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply