Hi Hugh,

I'm happy for you to use the FOR XML examples, so long as you give me credit

Good luck with future publishings!

All the...

Aw, I hate it when that happens.  You spend time on a solution, only to see that someone's beat you to it! 

Oh well,...

So it it!  I was put off by all those words... 

The query below gives the following result, and is safe to run.

Col1        Col2       

----------- -----------

123         1

123         2

123         3

124         1

127         1

127         2

CREATE TABLE #TableA...

Here's another way to do it if don't know the groups (using Farrell's #Counting table).  This code below gives the following result, and is safe to run.

A           B           C           TOTAL      ...

Good article - thanks Hugh.  A shame about the download, but I'm sure you'll get that fixed.

In case anyone's not familiar with the...

I'm probably missing something, but the code below (in blue, between the stars) does the job on my simple dummy data.  Run the whole lot below for a demo.

For anyone who does not yet have SQL Server 2005, here's an article for achieving similar results using a UDF in SQL Server 2000...

http://www.windowsitpro.com/Article/ArticleID/26094/26094.html?Ad=1 (written by Tim Pfeiffer)

You can probably do something with a view and an instead of trigger. Something like this (on top of your xml parsing stuff)?...

 

create view...

You can do pretty much anything with 'for xml explicit'. In this case you can do something like this...

 

create table TempTable (FirstName varchar(50), LastName...

Here's how I'd do it (very similar to Greg's, and the same limitations)...

declare @start_date datetime

declare @end_date datetime

set @start_date = '1 jan 2001'

set @end_date = '1 jan...

Funnily enough we started using the categories a week or two ago. We've found that the name of the sql developer works well for us as a category.

quote:

---

If you are talking about making the change on Monday and testing it before it runs live on Fri, I'd argue it...

We primarily use SQL 2000's XML functionality, then apply XSL for HTML reports. For very quick and simple reports where performance is not an issue, we put the SQL...

I'm a bit confused by those replies.

David - If the system has to be up and running when it's needed, then is that a non-critical system?

Antares:

a) Scenario 2 isn't necessarily...