user defined functions - Number2 Blog

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

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...

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

SQL Function - Convert Bytes to KB, MB, GB, TB, PB or EB and format the output to human readable format by jnelson

(UPDATE: I've created a similar function that will convert any byte based unit of measure to any other byte based unit of measure HERE ) When you query...

Filed under: user defined functions, udf_FormatBytes, byte conversion

Track table growth (or shrinkage) with a SQL job, a table and a multistatement table-valued user defined function by jnelson

THE PROBLEM Sometimes your SMS infrastructure seems to be swimming right along and everything is going right and then something you didn't think too...

Filed under: SQL, execution plan, table scan, Table size, coalesce, multistatement table-valued function, clustered index seek, UDF, user defined functions, table variable, inline function

Number2 Blog - myITforum

Search

Tags

News

Navigation

Archives

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) by jnelson

SQL Function - Convert Bytes to KB, MB, GB, TB, PB or EB and format the output to human readable format by jnelson

Track table growth (or shrinkage) with a SQL job, a table and a multistatement table-valued user defined function by jnelson