in

myITforum.com
All Tags » SMS 2003 » sms 1.2 (RSS)

Browse by Tags

  • M@d Skillz - SMS Web Reports - Passing a delimited list to SMS Web Reports like a table - (also convert list to rows in SQL)

    BACKGROUND Pass multiple items into a single parameter? With SMS Web reports, there's a lot of power in being able to pass parameters to your report query and have it substitute those values into the SQL code. It really saves you a lot of time not having to write your own front end for your SQL queries...
    Posted to Number2 Blog - MyITForum.com (Weblog) by jnelson on 01-16-2008
    Filed under: SMS, UDF, user defined functions, SMS 2003 SP3, SMS 2003, SMS 2003 SP2, Microsoft Systems Management Server, SMS Web Reports, web report, webreport, smsschm_users, webreport_approle, sql 2005, web reports, user defined function, sms report, sms 2.0, sms 1.2, list to rows, udf_Split, delimited list, list to table, list to column

  • SMS - #2's #1 suggestion - Learn to read/write WQL/SQL by hand

    My #1 suggestion after years of working with SMS/SQL/WQL and then coaching/mentoring/training people is that it REEEALLLY pays to know how to read/write SQL/WQL by hand. I know, there are those people who don't type well and those people who haven't learned how to really read and understand SQL...
    Posted to Number2 Blog - MyITForum.com (Weblog) by jnelson on 12-27-2007
    Filed under: SQL, SMS, SMS 2003, performance tips, aliases, WQL, beautifier, query desiger, sms 2.0, query builder, sms 1.2
Page 1 of 1 (2 items)
Copyright - www.myITforum.com, Inc. - 2007 All Rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems