Link to home
Start Free TrialLog in
Avatar of J3D1-KN1G1-1t
J3D1-KN1G1-1t

asked on

SQL: How to view a date range and then edit the fields in records

Hi Guys,


I want to run a query in sql where it finds a date range for example:

from date: 21/8/2011 to 23/9/2011

and then i want to edit the values in this date range.


Can someone please tell which query to run.

Many Thanks!
SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of J3D1-KN1G1-1t
J3D1-KN1G1-1t

ASKER

ok great that finds the values in the date range, how do i edit the found records?
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Cheers for the responses, I basically want to edit rows in the found set just like how you can do it via right clicking on a table and selecting "Edit top 200 rows)

Hope that makes sense

Many Thanks
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial