thomashohner (12/17/2013)
Thank you so very much, I also imagine that performance will suffer some and I will try to work on that. Luckily this wont be run often, more of a monthly spot check. I knew it would probably be some type of split list function I just had no idea how to implement it. I will give it a go tomorrow when I get to the office. Thanks again for your help. I hope to get enough experience and well versed enough to be able to help others instead of being a SQL leech as I currently am.:blush:
Hey, you are welcome and I'm sure you are not a "leech" - no-one would be helping out here if they didn't want to 🙂
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);