Ok, so at least you have a budgetary number to compete against... 😉

Get a quote from your vendor how much it would cost to replace the "heaviest" c.u.r.s.o.r.s.

Once that's done,...

Something like this?

DECLARE @tbl TABLE

(

DATE DATETIME, OrderNmbr INT, Transtype VARCHAR(10), Amount INT, InvoiceinPer CHAR(1)

)

--/*

INSERT INTO @tbl

SELECT '12/1/2010', 12345 ,'Inv', 1000 ,'N' UNION ALL

SELECT '12/3/2010', 12345 ,'Credit', -1000 ,'N' UNION...

Wouldn't it be more efficient to have one table ANTI_RES with a column AB_CODE, a column for the sensitivity result and one for the sample?

With such a structure you wouldn't...

Hmmmm... your last statement in the link...

If you're referring to the "Call in the Experts" editorial: sure I did and it demonstrated how much more efficient an organization can be if people know what they don't...

Just to make sure there is no misinterpretation:...

I think the table design needs to be re-evaluated...

Basically there are products, sections and status history per product and section. There might be section groups as well (at least what...

Care to share the link? Others might benefit from it.

I'd go with the XML approach but shred it into relational data behind the scenes (noone needs to know 😉 ).

If I understand correctly, you have two questions:

a) how to load the file into SQL Server and

b) how to shred the data into tables

a) load the (unshredded) file (using a...

One reason for not getting an answer yet might be a missing table structure (reduced to the relevant columns) with some sample data so we can visualize...

Hi Wayne,

the reason for the additional empload tag is the "ROOT('empload')" code snippet.

The ROOT element basically is the "wrapper" around the xml code since a wellfomrmed xml needs a covering...

Here's one version to define the order:

ORDER BY CASE WHEN cast('19000101' + ' ' +StartTime as datetime) >'19000101 11:30:00:00' THEN 0 ELSE 1 END, StartTime

But I strongly recommend to...

sounds like homework...

There are three choices:

a triangular self join,

a recursive CTE, or

a "quirky update" approach.

If it's homework, go for the first. If it's performance critical and there are people...

What's the data type of StartTime?