Someguy (5/2/2008)

Wrong: The things for which XML is useful are make it VERY useful. It provides a standard for inter-system communication that allows developers to avoid re-inventing the wheel for...

If it's a complex query then it's possible that most of those 30 seconds are taken compiling a new execution plan. This would explain why it takes 30 seconds...

Rob

I think your first query is actually equivalent to this:

SELECT mpe.din, mpe.pkgsize, mp.client, mc.active

FROM

...

Or this one, which uses less string manipulation, but does contain dynamic SQL:

--Data

declare @table table(col1 varchar(5), col2 varchar(200), col3 varchar(10))

declare @sql varchar(1000)

INSERT INTO @table VALUES ('Mut1',

'AZ5397UA9,AZ539CYK2,AZ54022Z3,AZ8040BQ1,AZ0442BB0,AZ2404AW1,AZ307TAD0,AZ442FAE8,AZ442FAQ1,AS490FAV1',

'Credit1')

INSERT INTO @table VALUES ('Mut2',

'AZ5397UA9,AZ539CYK2,AZ54022Z3,AZ8040BQ1,AZ0442BB0,AZ2404AW1,AZ307TAD0,AZ442FAE8,AZ442FAQ1,AS490FAV1',

'Credit2')

SET...

The only way to know is to test it, I'm afraid. The outer join issue was just an example: there are many more pieces of code that work in...

Click on the Jobs folder in SQL Server Management Studio. In the Object Explorer Details window, select all of the jobs. Right-click, and choose Script Job As ->...

If the application is properly written, so that it "identifies" itself to the SQL Server when it connects, then you can see all the connections from the application using the...

I think there's a column called HostName that you can filter on.

John

Well, you haven't given us any table DDL to go on, but after a cursory glance I would say that you should use an OUTER JOIN instead of an INNER...

Or this:

SELECT REPLACE(@String, '.', '')

John

This should work as well, and looks a bit neater:

SET @SQL = 'EXEC ' + @dbname + '.dbo.sp_MSForeachtable ''ALTER TABLE ? WHATEVER'' '

PRINT @SQL

John

GO is a batch separator... I don't think you should use it in dynamic SQL. ...

What will happen to the rows that aren't ordered? Please show us how your result set should look.

John

I'm not an ASP expert so it's difficult for me to tell what SQL this is actually sending to the SQL Server. And you didn't post the error message....

Please post the code you're running and the error message you get. By the way, if this is, or is going to be, production code, then it's not good...