Post reply

insert recursive days data into table.

  • April 15, 2013 at 5:16 am

    #292331

    Hi,

    Please guide me on following scenario.

    In one of my application i am giviving provision to user select startdate and enddate data to insert records. This functrionality is working fine.

    Also user is asking to provide check boxes for slection of day like sun,mon,tue....sat. if user selects date range like 01/01/2013 to 01/31/2013 and check for Tue and Fri only, then i want to insert data for that renage belonging to tuesday and friday only. there is no day column in my database. how can i handle this in SP?

    thanks

    Abhas.

  • April 15, 2013 at 9:38 am

    #1606513

    maybe be useful

    SELECT Datename (WEEKDAY, GETDATE())

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

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

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