Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ocm
Starting Member
1 Post |
 Posted - 2010-11-22 : 10:51:32
|
| Greetings,I'm new to this, and wanted to know how to go about doing the following tasks: I was given a file in XML format and asked to use T-SQL for the XML extraction and analysis. Submit the results in an Excel spreadsheet,import the data in the spreadsheets into a SQL Server relational database. Submit the CREATE scripts for all of the objects in the database; briefly explain how I used the data from the spreadsheets to populate the database. The database should be ready to use for accepting new records, as well.Thank you in advance.OCM |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-22 : 11:04:03
|
| Um - which bit do you need help with - what have you done so far?Maybe you should go back and say that you need someone to help you.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-11-24 : 09:28:08
|
| so Excel will contain data extracted from XML documents?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
XML extraction