Users Online

We have 209 guests online
Update closed to active PDF Print E-mail
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