If you always need to search by Symbol and Date, change the PRIMARY KEY to [Date] ASC, [Symbol] ASC. I'd even recommend to makes this the clustered index (assuming you...

As an alternative you could use the CrossTab syntax as described in the related article in my signature.

If you'd need to add some flexibility, use DynamicCrossTab (a related article is...

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