Here's an alternative. Ib - If speed is important to you, you might find it performs a bit quicker, but you'll have to test that yourself.

We can shorten the code still further. But I'm just riding Peso's suggestion... 

SELECT    z.[Start Date],

          z.DType,

          SUM(z.Volume)

FROM      (

             SELECT   ...

> ISDATE() which I think only allows US (mdy) format

I don't think this is correct. I think it works from the dateformat setting (see example below).

I agree that data cleansing shouldn't...

Just to note that you can use the 'NULLIF' function too (example below). But the ISDATE approach is probably safer and better.

--data

declare @t table (d1 varchar(30),...

You've not really explained what it is you're trying to do, but maybe these links will help...?

http://www.perfectxml.com/articles/xml/importxmlsql.asp

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=21&messageid=217076

Just to clarify: This is an 'Adjacency List Model', rather than "Joe Celko's 'Nested Set Model'".

It looks a little underdeveloped!

Arrays? Maybe this will help?

http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm

And here's a very silly method (loosely based around another one of the techniques in the link Mirko provided)...

--data

declare...

Hi all,

I've just come to this and, since it looked like fun, thought I'd have a stab

I've just coded for the 1st...

http://www.google.co.uk/search?hl=en&q=fn_split ?

...obviously to get this date to yymmdd format, you just need to use convert...

declare @i int

set @i = 1137699938

SELECT convert(varchar, DATEADD(ss, @i, '01-01-1970'), 112) as...

skarai has got it, I reckon. To explain more simply...

declare @i int

set @i = 1137699938

SELECT DATEADD(ss, @i, '01-01-1970') as 'My date'

/*results

My...

Philip - I'm confused!

You said "I can import the spreadsheet into a temporary table via DTS". The 'data' section I wrote was just my test data to illustrate the method to use...

Use 'set rowcount' in sql 2000...

http://www.aspfaq.com/show.asp?id=2521