Dear Brothers,
iam woundring to ask to get a help how to make multiple updates for a date records
which i have row of data in the table and the table contain to columns, which they are date start and date end
i want to update the date end in any row and when i update it the start date in the next row should be updated automaticlly for example 1 day after or 1 week.
I have an ID for every row, so am sure i can use the ID to make the update query, but like am stuck in doing this query...
Note that iam writing the sql query in asp.net page where am using vb.net code
wish get any help from u guyz , and thx