Am I correct in saying the values need to stay in the same rows?

or could I sort this sample as follows:

Sample

Col1 Col2 Col3

9 ...

oh and why do you have an order by if you doing a count?

try this

select @Filas = count(*)

from

VariablePromedio B,dbo.Homologacion H

where B.IDVariableProm = H.IDPagoVariable

and SUBSTRING (convert(varchar(20), H.IDEmpresa) , 4 , 1 ) = '4'

and H.IDOcupacion = 1

and B.SalOtrasNoPetroleras <> 0

ORDER BY SalOtrasNoPetroleras

I've taken out the correlated queries how does it run now?

SELECT u.USERID,

(CASE WHEN e.ISACTIVE = 1 THEN 'Active' ELSE 'Inactive' END) AS STATUS,

(CASE WHEN e.OPTOUT = 1 THEN...

have you tried removing the correlated subqueries as Chris mentioned?

could you show us your code please 🙂

And perhaps the execution plan for both queries

what would you like to know about IO statistics?

All seems to be working now.

I was getting an error, but it seems that the messges actually ended up going through 🙂

Thanks again guys

Excellent stuff 🙂

try this:

Subqueries in a select can only return one result, you could use a correlated sub-query not sure how that would perform , but here is a another solution:

SELECT TOP...

what is the value of the table name that you passing in?

If I change the VARCHAR to NVARCHAR and run the code there are no problems?

can you confirm?

I thought your problem was in SQL 2000? as there is no VARCHAR(MAX) in 2000

ALSO if you USE sp_executeSQL you must use a NVARCHAR

I'll work on a solution now

ok there goes the concat solution, as you can't concat with sp_executeSQL

I...