declare @document xml ='<TypedPollingResultSet0 xmlns="http://schemas.microsoft.com/Sql/2008/05/TypedPolling/ModifiedProductsGet"><TypedPollingResultSet0><id>2</id><ProductID>M10570</ProductID><OriginalCatalog> Master Recipes HE</OriginalCatalog><Status>0</Status><DateTimeCreated>2014-10-20T11:48:10.373Z</DateTimeCreated></TypedPollingResultSet0><TypedPollingResultSet0><id>1</id><ProductID>M9519</ProductID><OriginalCatalog> Master Recipes HE</OriginalCatalog><Status>0</Status><DateTimeCreated>2014-10-20T11:48:10.373Z</DateTimeCreated></TypedPollingResultSet0></TypedPollingResultSet0>' ;WITH XMLNAMESPACES(DEFAULT 'http://schemas.microsoft.com/Sql/2008/05/TypedPolling/ModifiedProductsGet') Select T.N.value('id[1]', 'int') as id from @document.nodes('/TypedPollingResultSet0/TypedPollingResultSet0') as T(N)
Wednesday
tsql select from xml with xmlns
tsql select from xml with xmlns
here is how to do that :
mplayer play random file into folder
to shuffle and play random audio files in folder , create following .bat file:
cd C:\Audio\mix\
c:\tools\mplayer\mplayer -quiet -shuffle *
cd C:\Audio\mix\
c:\tools\mplayer\mplayer -quiet -shuffle *
Monday
BizTalk Archive not available or not configured. Timeout error
Here are steps how to resolve BizTalk timeout issue and see tracked messages:
1.purge all tracking data
USE [BizTalkDTADb]
GO
DECLARE
@return_value int
EXEC
@return_value = [dbo].[dtasp_PurgeAllCompletedTrackingData]
SELECT 'Return Value' =
@return_value
GO
2.submit messages to BizTalk
3.After messages are placed run
this job on BizTalk server in order to see messages bodies:
TrackedMessages_Copy_BizTalkMsgBoxDb
Subscribe to:
Posts (Atom)
here is powershell script on how to get list of files from changesets associated with one tfs task
$dllPath = "C:\Program Files (x86)\Microsoft Visual Studio\2019\Enterprise\Common7\IDE\CommonExtensions\Microsoft\TeamFoundation\...

-
Error:The element 'Schedule' has invalid child element 'RecurrenceRule'. List of possible elements expected: 'Occurring...
-
Here is instruction how to make blinking text in rainmeter: 1.right click and select " Edit skin " 2.add following code to temp...
-
2010-11-24 Update: Please download latest version of Pidgin , that has this problem fixed , no additional steps required. Here are 3 ways to...