Indexed views are the "equivalent" to materialized views. They have to be created with the "with schemabinding" option and you can only change the columns that are not associated with...

have a look at sp_addextendedproperty !

are you reading SCOPE_IDENTITY after EACH insert?

Soething that you can easily remove are:

if @@error > 0

    begin

        select @errornum = @@error ...

@errornum will always be 0 if done that way!!!!

you need to change that to...

Chris,

Without data samples it is going to be difficult.

N stands for National Language in SQL92 and is used to denote unicode literals

:: Denotes GLOBAL SCOPE in other words system scope

EM makes it look like one move but it really isn't

And as you see it's a LOT of work

If you are planing to join(inner) those results with some local table there may be a chance. Other wise the only way to ensure remote dynamic filtering is Openquery and yes it...

what is wrong with this:

SELECT SessionID, Creative, Count(*) Cnt

FROM PageHits

where adate = 'Todays'

GROUP BY SessionID, Creative

Vivian,

the alias are bct_day and bct_month

Well then use dynamic and Openquery. It is for sure you'll get the filtered records only

Cheers,

If there are not many tables linked to this one you can do it with EM and it won't be a LOT of work ... for you at least .......

use Openquery if your literal value is hardcoded. If you can create an sp with a parameter and it works as you needed why do you need dynamic sql?

Is there something I am missing? You don't have a GROUP BY on your first statement including the BatchDateTime column??? did that ever worked?

not without a LOT of work.