You could have two of the same subtotal, and control the visibility of each one by setting the "Hidden" property to use a formula similar to what you have for...

Custom aggregates can be done with CLR in SQL Server 2005 or later, but it's not usually necessary. What kind of custom aggregate are you looking to create?...

Sounds a bit like you may have accidentally double-clicked twice on the executable. Can anyone else think of another reason?

Steve

(aka smunson)

:):):)

What you're seeking can be rather complex, but there are some things that might simplify it, depending on the overall objective. How is this data to be presented...

My Bad !!! I have the DATEFIRST thing messed up. Take a look at the BOL (Books Online) topic here:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/6b0d0e52-8ac1-4f88-b091-f98d6fb8574a.htm

(just copy and paste the above text...

A couple of things to look at:

1.) RAM utilization on the Web server.

2.) Is IIS 5.0 at the latest service pack level and have all fixes been applied?

3.) Same for...

Sorry, Seth, but putting it in groups just causes folks to refer to it as piles thereof...

Steve

(aka smunson)

:D:D:D

I loved the Dilbert humor, but the moment it degenerated into a group discusson of number 1 and number 2 :D:D:D, it just wasn't all that funny any more...

Steve

(aka smunson)

:D:D:D

Along the same lines as Jeff Moden's post, perhaps the most important issue here is WHY the column needs to be changed to varchar(10). If the problem is...

Seth,

I'm glad you came to that conclusion. I gave up my attempt long ago because it was becoming abundantly clear that the OP was just not going to...

Unfortunately, your example from several pages back conflicts with a statement by the OP that no range contains a duplicate, and your example starts out with one, unless he meant...

I'm still waiting for a complete and unambiguous description of the problem, as well as a good description of exactly what real-world problem the solution to the query problem is...

I'm not sure your data accurately reflects the real tables, but on the assumption that it does, then the following should help:

--===== Create the test tables

DECLARE @Company TABLE...

The text you've presented suggests you 1st delete a file and then want to rename it. If a file doesn't exist, how can you expect a rename...

If the website will serve multiple companies, I would think that there would need to be a table containing company-specific data, and that each company could then have it's own...