Browse by Tags

All Tags » CTE (RSS)

SMS 2003 - Query to pull logged on user records from all sources by jnelson

I was trolling the forums lately on MyITForm.com and was reading some conversations about logged on user records. It made me think of all the sources where you could get that information. Off the top of...
Filed under: , ,

SMS Web Report (SQL 2005+) - Show SMS program execution chaining hierarchy visually using CTE (Common Table Expressions) in SQL 2005+ by jnelson

In response to a request on the forums, here's a SQL query that uses common table expressions (CTE) to visually return the program execution chain hierarchy. (something like this) 00000000 - ProgramA...
Copyright - www.myITforum.com, Inc. - 2007 All Rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems