OR Include the "missing" part in the select list as the error clearly says:

SELECT

CASE GROUPING(LEFT(determinant, 5)) WHEN 0 THEN LEFT(determinant, 5) ELSE 'All' END,

LEFT(determinant, 5),

COUNT(*)

FROM response_master_incident

WHERE determinant...

My advice:

1. Limit the results you need (do not bring the entire table down [if you can])

2. Make sure the select (reading query) uses appropriate indexes ( same for updates)

3....

This can help you:

http://www.sqlxml.org/faqs.aspx?faq=39

Good Luck,

Oh I see you are trying to use that directly from TSQL. Well the short answer is that you need vb or c# to do that.

how are you calling the procedure? vb, c# ?

the type for @strXML should *not* be varchar(8000) it should be TEXT (you may be truncating the document)

Do you mind to try with coalesce instead and see ?

coalesce((your select stuff here),-1)

Also Hints are nothing but that; "hints". It does not means that you will be granted that...

From BOL 2005:

How many destination servers do you require?

If you require only a single destination database, database mirroring is the recommended solution.

If you require more than one destination database,...

np

Can you post the definiton of the first stored procedure and the .Net code that calls it ?

how about -t "|"

There is:

if object_id('data') is not null

drop table data

create table data (col1 varchar(20), col2 varchar(20), col_order int)

insert into data (col1, col2, col_order) values ( 'abc',...

The Distinct on the derived table is superfluous.

Without a bit of more info on where are you trying to get the AVG and SUM from it will be difficult to...

select nullif( columnname,'')

from your table

there is not much control over query compilation in 2005. I have been biten by this quite a bit. Even with Dynamic queries. The only posibility I see is to...