diff options
| author | Roy Ben Shabat <Roy.mail.net@gmail.com> | 2020-09-14 13:47:34 +0300 |
|---|---|---|
| committer | Roy Ben Shabat <Roy.mail.net@gmail.com> | 2020-09-14 13:47:34 +0300 |
| commit | 89ffc630471605c4757b5854af3d73b5b75e98d6 (patch) | |
| tree | d83f1196b233560edd37d08d7d00810a7e6d5a32 /Software/Visual_Studio/Notes | |
| parent | 0cfa44b16e412c7fbe1069d0cc83dfed486403b3 (diff) | |
| download | Tango-89ffc630471605c4757b5854af3d73b5b75e98d6.tar.gz Tango-89ffc630471605c4757b5854af3d73b5b75e98d6.zip | |
New thread loading wizard.
Diffstat (limited to 'Software/Visual_Studio/Notes')
| -rw-r--r-- | Software/Visual_Studio/Notes/Tango.Notes/DB/Fix Job Corrupted Runs Start Time.sql | 2 | ||||
| -rw-r--r-- | Software/Visual_Studio/Notes/Tango.Notes/Tango.Notes.csproj | 3 |
2 files changed, 4 insertions, 1 deletions
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 |