This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| (•_•) | |
| ( •_•)>⌐■-■ | |
| (⌐■_■) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| declare @el table | |
| ( | |
| new_id int identity(1,1), | |
| old_id int | |
| ) | |
| -- transfer the information from the time/expense sheets | |
| begin transaction | |
| begin try |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| IF object_id('tempdb..#records') IS NOT NULL | |
| BEGIN | |
| DROP TABLE #records | |
| END | |
| CREATE TABLE #records | |
| ( | |
| new_id int IDENTITY(1,1), | |
| old_id int, | |
| [type] char(1), |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| IF object_id('tempdb..#records') IS NOT NULL | |
| BEGIN | |
| DROP TABLE #records | |
| END | |
| CREATE TABLE #records | |
| ( | |
| new_id int IDENTITY(1,1), | |
| old_id int, | |
| [type] char(1), |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| using System; | |
| using System.Web.Mvc; | |
| using UCDArch.Core.PersistanceSupport; | |
| using UCDArch.Web.Controller; | |
| using UCDArchTemplates.Models; | |
| using UCDArch.Web.Helpers; | |
| namespace UCDArchTemplates.Controllers | |
| { | |
| /// <summary> |