Hey! Be nice

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...