|
arthiasha
Starting Member
India
40 Posts |
 Posted - 07/10/2012 : 00:37:47
|
Thanks a lot...
I need a query for the table 'task_schedule' where the columns are...
company_id varchar(12),
project_id varchar(20)
sub_project_id varchar(20),null
unique_id int
task_id int
wbs_id varchar(20),null
task_type varchar(1),null
task_description varchar(255),null
sch_start_date datetime, null
sch_finish_date datetime,null
plan_duration int,null
Plan_duration_uom varchar(2)
task_status varchar(2)
predecessors varchar(255),null
successors varchar(255),null
resources varchar(255),null
act_start_date datetime,null
act_finish_date datetime,null
projected_start_date datetime,null
projected_finish_date datetime,null
projected_duration int,null
projected_duration_uom varchar(2),
status_date datetime,null
remaining_duration int,null
remaining_duration_uom varchar(2),null
completion_percentage tinyint,null
actual_duration int,null
actual_duration_uom varchar(2),null
task_owner varchar(7),null
equipment_code nvarchar(15),null
asset_code nvarchar(15),null
all_predecessors_complete_ind varchar(1),null
last_update_id varchar(20),null
last_update_timestamp timestamp
These are the column names of the table 'task_schedule' and i wanted to update the columns to NULL 'task_status','sch_start_date','sch_finish_date','act_start_date','act_finish_date','projected_start_date','projected_finish_date','projected_duration','status_date'
where the 'task_status' is 'NS'
Please send me the query
|
 |
|
update date column with datatype datetime
