Shredding XML Question

I need to bring the following data in an xml format (many more years
included) into the table listed at the bottom of this request.

This data is in a large text file, say in c:\calendar.xml

<Calendar>
<ActualDate>2005-01-01T00:00:00</ActualDate>
<MonthName>January </MonthName>
<DayNumber>1</DayNumber>
<YearNumber>2005</YearNumber>
<DayOfWeek>Saturday </DayOfWeek>
<DayType>Holiday </DayType>
</Calendar>
<Calendar>
<ActualDate>2005-01-02T00:00:00</ActualDate>
<MonthName>January </MonthName>
<DayNumber>2</DayNumber>
<YearNumber>2005</YearNumber>
<DayOfWeek>Sunday </DayOfWeek>
<DayType>Weekend </DayType>
</Calendar>
<Calendar>
<ActualDate>2005-01-03T00:00:00</ActualDate>
<MonthName>January </MonthName>
<DayNumber>3</DayNumber>
<YearNumber>2005</YearNumber>
<DayOfWeek>Monday </DayOfWeek>
<DayType>Business </DayType>
</Calendar>

The relational table definition is as listed:

CREATE TABLE Calendar

(

ActualDate DATETIME NOT NULL PRIMARY KEY,

MonthName CHAR(15) NULL,

DayNumber INT NULL,

YearNumber INT NULL,

DayOfWeek CHAR(15) NULL

CHECK (DayOfWeek IN ('Sunday','Monday','Tuesday',

'Wednesday', 'Thursday', 'Friday', 'Saturday')),

DayType CHAR(15) NULL

CHECK (DayType IN ('Business','Weekend', 'Holiday')),

)





Thank you in advance.

See if you can modify the example in this thread to suit your needs:

http://simple-talk.com/community/forums/thread/30267.aspx


--

Adam Machanic
SQL Server MVP

Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220



<TenKMan> wrote in message news:O2C6nyGtHHA.4888@TK2MSFTNGP02.phx.gbl...
>I need to bring the following data in an xml format (many more years
> included) into the table listed at the bottom of this request.
>
> This data is in a large text file, say in c:\calendar.xml
>
> <Calendar>
> <ActualDate>2005-01-01T00:00:00</ActualDate>
> <MonthName>January </MonthName>
> <DayNumber>1</DayNumber>
> <YearNumber>2005</YearNumber>
> <DayOfWeek>Saturday </DayOfWeek>
> <DayType>Holiday </DayType>
> </Calendar>
> <Calendar>
> <ActualDate>2005-01-02T00:00:00</ActualDate>
> <MonthName>January </MonthName>
> <DayNumber>2</DayNumber>
> <YearNumber>2005</YearNumber>
> <DayOfWeek>Sunday </DayOfWeek>
> <DayType>Weekend </DayType>
> </Calendar>
> <Calendar>
> <ActualDate>2005-01-03T00:00:00</ActualDate>
> <MonthName>January </MonthName>
> <DayNumber>3</DayNumber>
> <YearNumber>2005</YearNumber>
> <DayOfWeek>Monday </DayOfWeek>
> <DayType>Business </DayType>
> </Calendar>
>
> The relational table definition is as listed:
>
> CREATE TABLE Calendar
>
> (
>
> ActualDate DATETIME NOT NULL PRIMARY KEY,
>
> MonthName CHAR(15) NULL,
>
> DayNumber INT NULL,
>
> YearNumber INT NULL,
>
> DayOfWeek CHAR(15) NULL
>
> CHECK (DayOfWeek IN ('Sunday','Monday','Tuesday',
>
> 'Wednesday', 'Thursday', 'Friday', 'Saturday')),
>
> DayType CHAR(15) NULL
>
> CHECK (DayType IN ('Business','Weekend', 'Holiday')),
>
> )
>
>
>
>
>
> Thank you in advance.
>
>
>