Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Help to get data from XML column.
George, Thank you very much, your help is priceless. I'm fighting with deadlines and too many 'new' think on this project, consequently 24 hours seams like not enough. I feel bad taking advantage of your good will and not putting enough effort to find solution on my own but I hope you...- bazyl
- Post #8
- Forum: Microsoft SQL Server: Programming
-
Help to get data from XML column.
Hi George, I need your help, please have a look at the SELECT query. I added child element <Contribution> to <Employee> one and now I cannot get ID, Amount, EnrollDate, and DeptId columns populated, they are populated with NULLs. Could you please help? Thank you. PS. How do you make you code...- bazyl
- Post #5
- Forum: Microsoft SQL Server: Programming
-
Help to get data from XML column.
I really appreciate your help, thank you very much George.- bazyl
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Help to get data from XML column.
I have a table with a XML column and appreciate any help how to get all data from that columns. This is the simplified sample, but should help to understand my issue. I can get all Employee data but I have no idea how to include DeptID data for each return row. CREATE TABLE #Deductions...- bazyl
- Thread
- Replies: 8
- Forum: Microsoft SQL Server: Programming
