Subquery Results are In Memory !

You would have to look at the execution plans of each for further insight

the reason you didn't get the results with my post was that @status should had been set to

Set @status = 'ER,OK'

instead of

Set @status = char(39) + 'ER' +...

Select *

from

  news N

  join

  (

 Select  TOP 20 news_entity_id,  Max (

    Convert(char(8),news_date,112)

    +

    Right('000'+ Cast(news_date_time as varchar(4)),4)

   &nbsp as MaxDateTime

 from news

 group by  news_entity_id

 order...

DECLARE @status AS VARCHAR(20)

SET @status = char(39) + 'ER' + char(39) +', ' + char(39) + 'OK' + char(39)

/*@Status = 'ER', 'OK' */

SELECT * FROM TABLEA WHERE  charindex(',' +...

I would write something easier to maintain like:

SELECT  Account

  , IDENTITY(int, 0,1) as AddrNbr

  , substring(';'+ Address ,n + 1,

    Charindex(';',';'+ Address , n + 1 )- n -1...

This is the approach I use to solve this problem:

Create a table that holds 1 row per day for maybe 2 o three years (depending on your requirements) Like:

Create Table...

check that autoclose is NOT checked!!

Can you post some examples? -- of what you have and what you want --

First Create This Function:

CREATE FUNCTION dbo.AllReasons(@Reasons char(50))

RETURNS VArchar(8000)

AS

BEGIN

DECLARE @Result varchar(8000)

SELECT @Result = ISNull(@Result +', ','') + R.Description

FROM

(SELECT Number as n

 FROM dbo.Numbers Where Number <=50 ) Nbr

 INNER JOIN ReasonsTable R...

If you are planning to to the Job path make sure whatever is run from the job is DONE before Next job iteration because Jobs are NOT reentrant!!

HTH

And there is one more way..

CREATE a CCW of your class and try to use the sp_OA* procedures but all those alternatives seem too cumbersome as  

Take a look at this implementation is very easy and self maintained. It has some minor defects but it will help you get where you need 

And Expanding on Mohammed Excellent idea:

DECLARE @sql  NVarchar(4000)

if OBJECT_ID('tempdb..#T1') IS NOT NULL

 drop table #T1

create table #T1 ([name] varchar(60)

  , [rows] varchar(11)

  , reserved varchar(11)

  , data varchar(11)

  , index_size varchar(11)

  , unused varchar(11)

  , DBName...

 CREATE FUNCTION dbo.udf_IsMixedChars(@str varchar(4000))

 Returns int

 AS

 BEGIN

-- This Function Assumes the Existence of a Numbers Table

-- CREATE TABLE Numbers(Number int) Filled accordingly!

 DECLARE @Result int

If Exists(

 Select 1

 From Numbers

 Where Number <= Len(@str)

 and  ASCII(Substring(...

go to EM-->tools-->Options and Make sure you have

Server Register information set up as Read/Store locally and if more than one user is using your wks then uncheck  the  Read/Store locally user independent box

HTH