Be careful about using DailyMileageID+1. You could have holes if it's an identity column (when you delete rows, for example), and also is the sort order definitely correct?

Look in...

Hi Jordon,

As you probably realise, SQL 2000 doesn't have CTEs or RowNumber.

I was happy to discover CTEs precisely because I'm hopeless at doing queries like the one below!! So...

A couple of hints that will save tears later.

2gb is not small.

If I had 2 gig of data I wouldn't give it to someone who doesn't know SQL!

Normalisation is not...

Sam,

As I see it, whatever you do, you're going to have to learn a little SQL. Your data's going to be in a relational database, and you're going to...

Hi,

I've written an article 'Linking to the Previous Row' which illustrates exactly this sort of thing using CTEs (Common Table Expressions).

Unfortunately it's not published yet. (It'll be published on...

I'm using IE6, and can view the article OK. hmmm.

Can't help, I'm afraid.

(But this article has been there for quite some time, and I've not heard of...

Unfortunately since the article was written, Altova has stopped distributing a free edition of XMLSpy.

However, you can try it out for 30 days (careful it's very good and you just...

I think these are as old as civilisation itself. Every industry has them - perhaps especially in the building trade.

The wiki below has some great examples.

http://en.wikipedia.org/wiki/Snipe_hunt

Thanks Gail,

I already had that Bad Carma article in my IE Favourites list.

It's one of my all-time favourite articles.

The app takes as input a csv'ish file which comes from a 3rd party reporting tool. However the app is trying to allow flexibility with the actual columns in...

...will do, but it won't be for at least a few weeks.

Hey....that's an interesting idea!

I think I'll explore that a little farther!

Thanks for all your help.

Thanks maddog,

I had considered that type of approach. I was hoping to use reporting services to avoid providing any sort of interface for the user. i.e. so that they...

Thanks jv,

Unfortunately it produces a single csv with columns from both tables / matrixes.

A sub report seems to do the same thing.

So I'm still looking for ideas....:)

Hi,

Nice article.

At one stage you say that auto mode does not allow you to specify a root element, and you provide a work around.  Are you perhaps talking about...