A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.
DECLARE @xmlblob xml SELECT @xmlblob = CAST(CAST ( ba.xmlblob AS varbinary(MAX)) as xml) FROM BizAppNodes ba WHERE VersionEndDateTime = '9999-12-31 00:00:00.000' AND BizAppNodeLabel = 'Application' a SELECT DISTINCT tab.col.value('../../@Label', 'varchar(30)') as ModelLabel, tab.col.value('@Server', 'varchar(30)') as CurrentPeriodId FROM @xmlblob.nodes ('/BizModelSite/Models/ArrayOfBizModel/BizModel/EffectiveDatedCurrentPeriods/EffectiveDatedCurrentPeriod') as tab(col)
|PHP Soap Server returning XML but < & > as < / >||9||45|
|Query for timesheet application||3||17|
|Migration from SQL server to oracle (XML input)||4||25|
|MS SQL + group by time||4||14|