jacobhackl

;WITH cte
     AS (SELECT ROW_NUMBER() OVER (PARTITION BY Col1, Col2, Col3 
                                       ORDER BY ( SELECT 0)) RN
         FROM   #MyTable)
DELETE FROM cte
WHERE  RN > 1

jacobhackl

forfiles /p D:\wrx\data\iedi\done /s /m *.* /d -180 /c "cmd /c del @path"

jacobhackl

*.o *.lo *.la #*# .*.rej *.rej .*~ *~ .#* .DS_Store thumbs.db Thumbs.db *.bak *.class *.exe *.dll *.mine *.obj *.ncb *.lib *.log *.idb *.pdb *.ilk *.msi* .res *.pch *.suo *.exp *.*~ *.~* ~*.* cvs CVS .CVS .cvs release Release debug Debug ignore Ignore bin Bin obj Obj *.csproj.user *.user *.generated.cs

jacobhackl

-- Search in All Objects
SELECT OBJECT_NAME(OBJECT_ID),
definition
FROM sys.sql_modules
WHERE definition LIKE '%' + 'CreatedDate' + '%'
GO

-- Search in Stored Procedure Only
SELECT DISTINCT OBJECT_NAME(OBJECT_ID),
object_definition(OBJECT_ID)

jacobhackl

[assembly: CLSCompliant(true)]

jacobhackl

-- Step 1 : Declare the varaibles

use Northwind
Declare @counter int
Declare @RowsEffected int
Declare @RowsCnt int
Declare @CodeId int
Declare @OldCodeId int
Declare @Err int
SELECT @COUNTER = 1

jacobhackl

work in progress

cbtransfer http://192.168.2.91:8091 http://192.168.2.18:8091 -b bucket -B buckett -u Admin -p pw -n

jacobhackl

REM "press any key to continue with deploy. This will backup current IIS set and move the site from deploy into its place. Hit the X to cancel"
PAUSE
for /f "skip=1" %%d in ('wmic os get localdatetime') do if not defined mydate set mydate=%%d
SET source=C:\inetpub\wwwroot\SetSight3
SET destination=C:\Code\Deploy\Archive\SetSight3_%mydate:~0,8%
REM use Robocopy %source% %destination%  /S /MOV /XF web.config /MAX:100000 to ignore web.config
Robocopy %source% %destination%  /S /MOVE /XF serverInfo.js web.config /MAX:100000 	
SET source=C:\Code\Deploy\SetSight3
SET destination=C:\inetpub\wwwroot\SetSight3
Robocopy %source% %destination%  /S /XF serverInfo.js web.config /MAX:100000 

jacobhackl

install-package newtonsoft.json -version 5.0.8

jacobhackl

XElement pop = XElement.Parse(xml);
XNamespace ns = "mtvnCWExternInteropResData";
string result = pop.Descendants(ns + "RedirInfo").First().Value;