For reporting uses, XML parameters really shine: You can pass the same XML string to multiple stored procs, yet you won’t need to modify all of them, if say, one report’s stored procedure ...