|
Billpl
Yak Posting Veteran
71 Posts |
 Posted - 2008-10-14 : 19:22:35
|
| It's about time SQL Management caught up with the real world and put some 'sense into it. (reminds me back in the good old days when we had Speed-SQL)...but it doesn't like my XML stuff. It works fine but it get covered in red lines.or maybe I'm doing something wrong(md.rec.value) "can't find...blah,blah...or the name is ambiguous"---------------------------------Insert Into dbo.apd_Application ( OrgID, LinkKey, AppTrackingKey, OrgAccountKey, LastName, FirstName, MiddleInitial, CompanyName, Address, City, State, Zip, Phone, Phone_Home, Phone_Cell ) Select @OrgID, @LinkKey, md.rec.value('trackingkey[1]','char(20)'), md.rec.value('accountid[1]','char(20)'), md.rec.value('lastname[1]','char(50)'), md.rec.value('firstname[1]','char(50)'), md.rec.value('middleinitial[1]','char(4)'), md.rec.value('companyname[1]','char(50)'), md.rec.value('address[1]','char(50)'), md.rec.value('city[1]','char(50)'), md.rec.value('state[1]','char(25)'), md.rec.value('zip[1]','char(20)'), md.rec.value('phone[1]','char(30)'), md.rec.value('phone_home[1]','char(30)'), md.rec.value('phone_cell[1]','char(30)')From @XAppData.nodes( '/xdoc/debitapp' ) as md(rec) |
|
SQL 2008 Intelli-non-sense