USE [dw_antam] GO /****** Object: StoredProcedure [dbo].[InsFactExpIntVolkerPlan] Script Date: 05/10/2025 19:51:45 ******/ SET ANSI_NUL...
Read More
Loop 2 sql server,
USE [dw_antam] GO /****** Object: StoredProcedure [dw].[InsdmExpMPlan] Script Date: 05/10/2025 19:54:27 ******/ SET ANSI_NULLS ON...
Read More
ssis expression
simple "FF_CD_DerivedCol_"+ (DT_WSTR,4)YEAR(GETDATE()) + "_" + (DT_WSTR,4)MONTH(GETDATE()) + "_" + (DT_WS...
Read More
pivot sql server
https://www.youtube.com/watch?v=uT_Z2VP2Z24
Read More
sql server scramble reversed
https://dba.stackexchange.com/questions/47967/scramble-the-value-of-one-column-and-unscramble-it SELECT 'Gorilla' ...
Read More
SSIS .xls excel
issu xls ssis Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Template_Culture\TemplateHeaderMetricCulture.xls; Extended Properties=...
Read More
disable password expired win server 2012 r2, disable change pass
http://sptrac.com/wordpress/?p=1285#:~:text=Luckily%20its%20easy%20to%20deactivate,incude%20'Maximum%20Password%20Age'. go to...
Read More
Langganan:
Komentar (Atom)