Skip to main content

Posts

SP Update market price

By
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...
1 comment
Baca Selanjutnya »
Recent posts

SP download

By
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 @min...
Post a Comment
Baca Selanjutnya »

Create Fuction

By
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 ,                         ...
Post a Comment
Baca Selanjutnya »

Register Menu

By
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...
Post a Comment
Baca Selanjutnya »

Linq Group by

By
  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),                               Claimab...
Post a Comment
Baca Selanjutnya »

Membuat SQL Rollback

By
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_...
Post a Comment
Baca Selanjutnya »

Function Split String di SQL Server

By
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...
Post a Comment
Baca Selanjutnya »