Diary Source Code

USE [AAB] GO /****** Object:  StoredProcedure [dbo].[SP_GET_UPDATE_MARKET_PRICE]    Script Date: 2/8/2017 1:52:18 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: Iqbal Abdurrahman, update by Andri Kurniawan -- Create date: 21 September 2016 -- Description: Get Data for Update Market Price [Vehicle Market Price Application Cisadane] -- BRD : 0269 URF 2016 - Vehicle Market Price -- ============================================= CREATE PROCEDURE [dbo].[SP_GET_UPDATE_MARKET_PRICE]     @brand AS VARCHAR(MAX) ,     @model AS VARCHAR(MAX) ,     @geographical_area AS VARCHAR(MAX) AS     BEGIN         DECLARE @tsqlUMP VARCHAR(MAX) = '';         DECLARE @tsqlYearHeader VARCHAR(MAX) = '';         DECLARE @tsqlYearPivot VARCHAR(MAX) = '';         DECLARE @maxyear INT = 0;         DECLARE @minyear INT = 0;         SET @maxyear = YEAR(GETDATE());         SET @minyear = YEAR(GE

USE [AAB] GO /****** Object:  StoredProcedure [dbo].[SP_GET_DOWNLOAD_MARKET_PRICE]    Script Date: 3/9/2017 9:02:17 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: Andri Kurniawan -- Create date: 9 Desember 2016 -- Description: Get Data for Data Donwload Market Price [Vehicle Market Price Application Cisadane] -- BRD : 0269 URF 2016 - Vehicle Market Price -- ============================================= CREATE PROCEDURE [dbo].[SP_GET_DOWNLOAD_MARKET_PRICE]     @brandID AS VARCHAR(50) = '' ,     @modelID AS VARCHAR(50) = '' AS     BEGIN             DECLARE @tsqlUMP VARCHAR(MAX) = '';         DECLARE @tsqlYearHeader VARCHAR(MAX) = '';         DECLARE @tsqlYearPivot VARCHAR(MAX) = '';         DECLARE @maxyear INT = 0;         DECLARE @minyear INT = 0;         SET @maxyear = YEAR(GETDATE());         SET @minyear = YEAR(GETDATE()) - 14;         DE

USE [AAB] GO /****** Object:  UserDefinedFunction [dbo].[SFN_GET_DATADOWNLOAD_MARKET_PRICE]    Script Date: 3/9/2017 9:03:06 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: Andri Kurniawan -- Create date: 16 October 2016 -- Description: Get Data for Data Donwload Market Price [Vehicle Market Price Application Cisadane] -- BRD : 0269 URF 2016 - Vehicle Market Price -- ============================================= CREATE FUNCTION [dbo].[SFN_GET_DATADOWNLOAD_MARKET_PRICE]     (       @brandID VARCHAR(50)= '' ,       @modelID VARCHAR(50) ='',  @GeoArea VARCHAR(50) =''     ) RETURNS TABLE AS RETURN     ( WITH    tmpTable               AS ( SELECT   a.Vehicle_code AS Code ,                             a.Year AS Tahun ,                             MAX(a.Effective_date) AS MaxDate                    FROM     Mst_Vehicle_Price AS A                             RIG

USE a2isauthorizationdb GO BEGIN TRANSACTION /* READ THIS FIRST! ================ Before executing this script, please check on the current database is there an exists data or please remember is this script has been executed before */ DECLARE @APPID int, @MENUID1 int, @MENUID2 int, @MENUID3 int, @MENUID4 int, @ROLEID1 int /* change the number if numbers exists, please set into a non exists number, sequently*/ SET @APPID = 1 SET @MENUID1 = 96 SET @MENUID2 = 97 SET @MENUID3 = 98 SET @MENUID4 = 99 SET @ROLEID1 = 921 --REGISTRASI APPLICATION MENUS BEGIN IF NOT EXISTS (SELECT 1 FROM General.ApplicationMenus WHERE MenuName = 'VEHICLEMAIN' And ApplicationID = @APPID) BEGIN INSERT General.ApplicationMenus (ApplicationID, MenuID, MenuName, MenuCaption, ParentMenuID, OrderingNo, ApplicationInfo, IsActive, CreatedBy, CreatedDate, UpdateBy, UpdateDate, RowStatus) VALUES (@APPID, @MENUID1, N'VEHICLEMAIN', N'Vehicle', 0, 0, N'', 1, N'NK

  var ObjLst1 = from ls1 in objChkList1  //SUM by Claim_no dan Interest_id                           group ls1 by new { ls1.claim_no, ls1.interest_id } into NoGroup                           select new                           {                               claim_no = NoGroup.Key.claim_no,                               interest_id = NoGroup.Key.interest_id,                               Estimated_amount = NoGroup.Sum(x => x.Estimated_amount),                               Claimable_Amount = 0,                           };             var result1 = from a in objChkList2 //Dicari yg Claim_amount < estimasi_amoung by claim_no & interest_id                           join c in ObjLst1 on new { a.claim_no, a.interest_id } equals new { c.claim_no, c.interest_id } into b_join                           from c in b_join.DefaultIfEmpty()                           where                           a.Claimable_Amount < c.Estimated_amount //<                          

USE [AAB] GO BEGIN TRANSACTION GO /****** Object:  Table [dbo].[Mst_Vehicle_ModelBrand]    Script Date: 1/19/2017 1:35:31 PM ******/ IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES                  WHERE TABLE_SCHEMA = 'dbo'                  AND  TABLE_NAME = 'Mst_Vehicle_ModelBrand') BEGIN DROP TABLE [dbo].[Mst_Vehicle_ModelBrand] END GO /****** Object:  Table [dbo].[Mst_Vehicle_StatusUpload]    Script Date: 1/19/2017 1:35:31 PM ******/ IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES                  WHERE TABLE_SCHEMA = 'dbo'                  AND  TABLE_NAME = 'Mst_Vehicle_StatusUpload') BEGIN DROP TABLE [dbo].[Mst_Vehicle_StatusUpload] END GO IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.SFN_GET_DATADOWNLOAD_MARKET_PRICE') AND type in (N'IF')) DROP FUNCTION [dbo].[SFN_GET_DATADOWNLOAD_MARKET_PRICE] GO IF  EXISTS (SELECT * FROM sys.obje

USE [Asuransiastra] GO /****** Object:  UserDefinedFunction [GODigital].[Fn_SplitString]    Script Date: 7/17/2017 10:31:15 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE FUNCTION [GODigital].[Fn_SplitString] (     -- Add the parameters for the function here     @myString varchar(500),     @deliminator varchar(10) ) RETURNS @ReturnTable TABLE (     -- Add the column definitions for the TABLE variable here     [id] [int] IDENTITY(1,1) NOT NULL,     [part] [varchar](50) NULL ) AS BEGIN         Declare @iSpaces int         Declare @part varchar(50)         --initialize spaces         Select @iSpaces = charindex(@deliminator,@myString,0)         While @iSpaces > 0         Begin             Select @part = substring(@myString,0,charindex(@deliminator,@myString,0))             Insert Into @ReturnTable(part)             Select @part     Select @myString = substring(@mystring,charindex(@deliminator,@myString,0)+ len(@deliminator),len