From 89ffc630471605c4757b5854af3d73b5b75e98d6 Mon Sep 17 00:00:00 2001
From: Roy Ben Shabat <Roy.mail.net@gmail.com>
Date: Mon, 14 Sep 2020 13:47:34 +0300
Subject: New thread loading wizard.

---
 .../Notes/Tango.Notes/DB/Fix Job Corrupted Runs Start Time.sql         | 2 ++
 Software/Visual_Studio/Notes/Tango.Notes/Tango.Notes.csproj            | 3 ++-
 2 files changed, 4 insertions(+), 1 deletion(-)
 create mode 100644 Software/Visual_Studio/Notes/Tango.Notes/DB/Fix Job Corrupted Runs Start Time.sql

(limited to 'Software/Visual_Studio/Notes/Tango.Notes')

diff --git a/Software/Visual_Studio/Notes/Tango.Notes/DB/Fix Job Corrupted Runs Start Time.sql b/Software/Visual_Studio/Notes/Tango.Notes/DB/Fix Job Corrupted Runs Start Time.sql
new file mode 100644
index 000000000..9467a8cf1
--- /dev/null
+++ b/Software/Visual_Studio/Notes/Tango.Notes/DB/Fix Job Corrupted Runs Start Time.sql	
@@ -0,0 +1,2 @@
+UPDATE JOB_RUNS SET START_DATE = ACTUAL_START_DATE WHERE START_DATE = '0001-01-01 00:00:00.000' AND ACTUAL_START_DATE IS NOT NULL
+UPDATE JOB_RUNS SET START_DATE = END_DATE WHERE START_DATE = '0001-01-01 00:00:00.000' AND ACTUAL_START_DATE IS NULL
\ No newline at end of file
diff --git a/Software/Visual_Studio/Notes/Tango.Notes/Tango.Notes.csproj b/Software/Visual_Studio/Notes/Tango.Notes/Tango.Notes.csproj
index 0da639179..5dfe4c005 100644
--- a/Software/Visual_Studio/Notes/Tango.Notes/Tango.Notes.csproj
+++ b/Software/Visual_Studio/Notes/Tango.Notes/Tango.Notes.csproj
@@ -49,6 +49,7 @@
     <Content Include="Azure\Test User Credentials.txt" />
     <Content Include="Azure\SQL Database.txt" />
     <Content Include="DB\DB Schema Change Log.txt" />
+    <Content Include="DB\Fix Job Corrupted Runs Start Time.sql" />
     <Content Include="DB\SQL Dependency.txt" />
     <Content Include="EDrawMax\License.txt" />
     <Content Include="Nswag\Pre-Build Example.txt" />
@@ -66,7 +67,7 @@
   <Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" />
   <ProjectExtensions>
     <VisualStudio>
-      <UserProperties BuildVersion_AssemblyInfoFilename="Properties\AssemblyInfo.cs" BuildVersion_UpdateAssemblyVersion="True" BuildVersion_BuildVersioningStyle="None.None.Increment.TimeStamp" BuildVersion_UseGlobalSettings="False" BuildVersion_StartDate="2000/1/1" />
+      <UserProperties BuildVersion_StartDate="2000/1/1" BuildVersion_UseGlobalSettings="False" BuildVersion_BuildVersioningStyle="None.None.Increment.TimeStamp" BuildVersion_UpdateAssemblyVersion="True" BuildVersion_AssemblyInfoFilename="Properties\AssemblyInfo.cs" />
     </VisualStudio>
   </ProjectExtensions>
 </Project>
\ No newline at end of file
-- 
cgit v1.3.1