If you've ever written a report that also selects IP addresses or MAC addresses, you've noticed that there can be multiple addresses per machine and it will throw off your counts. So I've whipped a little something together that concatenates them into their own columns. I don't have time...
Posted to
Number2 Blog - MyITForum.com
(Weblog)
by
jnelson
on
11-21-2007
Filed under: SQL, SMS, UDF, SMS 2003, web report, sql 2005, SQL 2000, ip address, mac address, user defined function, FOR XML PATH, sms report