you cannot refernece a column without saying what table it comes from...looks like you need "FROM dbo.payloads"

ie:

maybe like this:

SELECT (Select dbo.payloads.ContentReference as ImportFileName

FROM dbo.payloads

FOR

XML...

looks like it's a combination of Splitting and a pivot;

for specific values, this seems to get teh data back into "column" form; you'd need three split+ pivots in your example,...

in his example, at least one value was "1.5", so th3ey are not single character items.

the error message is related to debugging.

do you really need to debug the CLR?

why not just deploy the project, then test it in q window for known pattern/values?

i'm thinking it has to do with the target tables, and not anything to do with the temp tables;

i read his comment as disabling reading data into temp tables,...

i thought the issue might be related to the altering of the indexes; that would count as a schema change.

Some of which disable indexes and re enable them after...

don't allow a GO to exist inside the comments:

WHERE #enr_detail.acc_nr = drsmas.drs_acc

GO */

Boooks online says a the argument expects a varchar/nvarchar(128) for the max size.

QUOTENAME ( 'character_string' [ , 'quote_character' ] )

Arguments

'character_string'

Is a string of Unicode character data....

did you rebuild the indexes or update statistics on the new server yet?

this would be especially true if the database you restored came from a different version of SQL...the engine...

you could query sys.assemblies;

i'm sticking the results in a global temp table for ease of reporting, for example:

CREATE TABLE [dbo].[##RESULTS] (

[DBNAME] ...

you need to calcualte the counts, and apply the ROTT calculation to that;

by simply wrapping the grouping as a subquery, this gives you what you are after:

select @rott as ROTT,

(count_of_referrals...

try to see if it's convertable from binary to text:

i don't have any reportingservices that are touchable to test:

select

CONVERT(NVARCHAR(max),CONVERT(VARBINARY(max),ConnectionString)) As ConversionAttempt,

ConnectionString,*

from ReportServer..DataSource

Sql integer division: int / int =int, not the decimal you are expecting.

Change @rott /100.0 and it should work as expected.

details are in order, i think.

are you really just running 'dir d:\runtime\SomeExec.exe' (directory!) or are you EXECUTING 'd:\runtime\SomeExec.exe'

how do you know "nothing" happened?

what does the executable do?

does it...

Microsoft indirectly butters my bread, so to speak, as I'm doing dev/web/sql stuff all in SQL Server and .NET technologies. All my coding efforts at work are on that platform.

As...