You're welcome.

They are still using my design for the XML file import, SEVEN years after implementation... That's solid!

Do I need to mention that the schema for XML file has been...

Four years of practice

We (insurance broker company) imported around 400 XML files every day, each of them between 2 and 10 mb.

The XML files could...

You have indexed the addresses right now with [2]. What if there are more addresses? Or a better example, several orders for a customer.

This is because you set "root" to...

Or simply

SELECT YEAR(MyField) FROM MyTable

Yes. I did not understand he was knowledgeable about XML otherwise, since he wrote only for customer node.

And I also know that the technique you are using does not work...

What you just selected is XML

   <Cust_id>101</Cust_id>

   <Cust_fname>"George"</Custf_name>

   <Cust_lname>"Spencer"</Cust_lname>

   <Cust_address>"Some Address"</Cust_address>

   <Cust_dob>

      <day>2</day>

      <month>10</month>

      <year>1963</year>

  ...

The original posting was inserted in last 7 days including today.

Select * From TblName where <Date_Column> >=DateAdd(day,DateDiff(day,0,getdate()),-6)

or

Select * From TblName where <Date_Column> >DateAdd(day,DateDiff(day,0,getdate()),-7)

As I wrote yesterday?

You really need DYNAMIC SQL for this.

Search for SOMMARSKOG and DYNAMIC SQL on the Internet and you will find a person who has good insight about this.

http://www.sommarskog.se/dynamic_sql.html

I really don't think ASP is doing the joins. SQL Server is doing the joins.

Also I believe that you are doing a CROSS JOIN (Cartesian Product), selecting all possible combinations...

For the first, CROSS JOIN creates a CARTESIAN PRODUCT, which means you end up with ALL combinations of freight_manager and LargeOrderShippers!

Alter your function to include something...

What was the solution?

Well, sometimes life is easy.

BTW, there is a six digit limit for the conversion as stated in BOL

This table shows the style values for float or real conversion to character...

It made some sense. But to be really clear, do you have an example of table design and about 20 rows of test data?

Example:

TABLE LoA

----------------------

PersonID INT,

Date DATETIME,

Days TINYINT

And...