Add this to the end?
,@x.value(
'(sql_variant1)[1]','FLOAT')
,@x.value(
'(sql_variant2)[1]','FLOAT')
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D