I didn't realize you had...

That will give you the desired output.

I would guess some row contains character value for column "category_1.Description" that's making the conversion to fail.

You may want to look at creating an SSIS package and then set it as a job in SQL Server.

G² (10/1/2009)

---

This is straight from the link supplied in the answer.

SQL Server 2008 introduces several extensions to the GROUP BY clause that enable you to define multiple groupings in the...

Whenever I have faced such situations with dynamic SQL; invariably the issue has been some variable being null ( as @arun.sas said and demonstrated).

Try this:

select case when id is null then 'N/A' else convert(varchar, sum(id)) end from tN group by id

The convert function has been used to get the 'N/A' value. You can...

Lowell's first post has the Order By. You'll just have to re-arrange the order of fields. Also note that you should be placing the Order By only towards the end...

I'm not sure if this is the cause of the error but with dynamic sql I always use

EXEC (@sql)

That's poorly written. But I...

I doubt that's a join because there are no columns specified for the join to base on.

@matt-2, As the where clause is not mentioned in the query I...

Yeah, for certain user selected options the number of columns could be as big as 36(maximum now but may grow couple years down the line).

I will surely post the .Net...

Thank you @Bitbucket for the suggestion but as @Garadin pointed out the situation is not as simplistic. I'd the test data to give an idea of...

Hmm. I won't take that route then. I can do the required in front-end, and I'll have to run a loop for the number of columns and it's not that...

PIVOT may help you.

A good article on it here: http://qa.sqlservercentral.com/articles/T-SQL/63681/