And here we have a near perfect example of why those kinds of designs are really bad ideas. No offense to anyone, but coding what this poster wants...

Thansk for the update and feedback.

Steve

(aka smunson)

:-):-):-)

I guess I forgot to tell you how to do that. There's only one really good way to this that you could easily rely on. Group...

You're correct that the sorting on Category group is sorting left to right. Your last image file shows categories within Co. #1 in numeric order, and what you...

The problem with COALESCE is that you can only retrieve one value per row, and if I recall one of the OP's posts correctly, you might well need values from...

Unless you have the 'hello world' text on the end of at least some of the data in the DataIntegrityErrors table, you'll never have a match to worry about avoiding,...

I hear you on the "won't fly" deal, but if you stop and think about it, that rather strongly suggests that there's a huge disconnect between the process being used...

The problem these companies are trying to avoid is having to support their own product in an environment they can't control. It can be difficult, and they can...

One way you can ferret out a potential conversion error is to use a derived table where you eliminate any non-numeric values for your result_value field.

DECLARE @test-2 TABLE(

result_value varchar(20)

)

INSERT INTO...

No offense, but using the option in Access as a means of avoiding having to write the query to produce correct results is a horribly lazy way of getting something...

I'm just wondering why generate XML, when you could just do a classic ASP webpage with ADO code in VBScript to retrieve the data records and dynamically generate the HTML...

I hear you on the newbee-isms. I was at that point a lot of years ago. First point is that you can't wait until AFTER...

You'll have to decide EXACTLY what you mean by "exact match", and you need to be as anal about that as is possible. You either need to know...

If this process is the only way that new records should be inserted into the destination table, then you could use a trigger on the INSERT that would update the...

Ooops! triple post...