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!
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!
Last Comment
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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
Hope that makes sense
Many Thanks
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft SQL Server
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER