Yes, it is for reporting services.

~ iklektic

Thanks! How do I add numeric values to this now?

To clarify;

a list that will look like this:

January 1

February 2

...

Thank you so much for your help! I got some good results from this query. I really appreciate your help and explanations. I have learned a lot!

Extremely useful tool! Thank you!!

The complete code I have for this query so far is:

DECLARE @StartDate datetime, @EndDate datetime

SELECT @StartDate = DATEADD(MONTH, -6, GETDATE()), @EndDate = GETDATE()

SELECT MAX(Customer.CustomerID) AS...

So the CTE doesn't need to have the entire query on there correct? Only the table(s) that are needed to establish the date range?

The query is somewhat lengthy....

Ok, so I'm guessing that "CTE" represents the string below (and CTE means Concatenate?):

WITH indaterange AS )

SELECT customerID, categoryID from contactcategory WHERE (dbo.dateonly(contactOn) between DATEADD(MONTH, -6, dbo.dateonly(GETDATE()))...

Thank you Mr Jones, for your response, I used the asterisk to help focus on the FROM information. I can see how that was misleading, the data I have in...

Thank you for your response, I had tried the right outer join as well, but that didn't return the desired results.

I was actually hoping to get the count from the query side:

SELECT COUNT(characters(table1)) as totalCharacters... or whatever it is supposed to be!

YOU ROCK!!! Am using 2005 so that should work!!

Thank you!

I tried that query but when I ran it... I got the 'completed' statement instead of an actual result?

On a separate note, is there a way to return...

This solution is exactly what I need! Thank you!

I tried the php route and didn't get far at all...

Thank you for your expertise!

... and another thing about the html code.

What I meant was that when I put in the query return this "</LI><LI>", the actual result I got was: .</li><li>... which didn't...

Thank you for the response!

What I am trying to accomplish with that query is create an html list for an email blast that I need to send out...

So......