|
Written by Zack MIlls
|
|
Friday, 25 September 2009 12:29 |
|
Run this Statement to Update SQL Side of DB before implement next update.
UPDATE tbl_Flow_StepData
SET FlowStepName = N'Archived'
WHERE (FlowStepName = N'Closed')
UPDATE tbl_SO_Data
SET Value = N'Archived'
WHERE (Type = N'CurrentStatus') AND (Value = N'Closed')
UPDATE tbl_SO_StepData
SET StepName = N'Archived'
WHERE (StepName = N'Closed')
UPDATE tbl_Flow_StepData
SET FlowStepName = N'Archived'
WHERE (FlowStepName = N'Closed')
UPDATE tbl_SO_Data
SET Value = N'Archived'
WHERE (Type = N'CurrentStatus') AND (Value = N'Closed')
UPDATE tbl_SO_StepData
SET StepName = N'Archived'
WHERE (StepName = N'Closed')
|
|
Last Updated on Wednesday, 04 November 2009 22:32 |
