Ryan .. that worked like a charm.. thanks a bunch.

Ryan

Your query does exactly what I wanted. However its taking forever to run with actual data sets. What can I do to make it faster?

thanks

ts_date is just a date field. for tangible sold.

well if I migrate does that destroy my source cube or does the source cube and environment remain intact?

works great.. thanks

found the solution..

Sp_databases

HELLOOOO???

how can find out whats lsn number are both source and destination db's are?

SQL Server has encountered 8 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.

SQL Server has encountered 8...

thanks... it worked..

select empl_Id, proj_id, sum(chargehours) SumChargeHours

from TempCPData1

group by empl_Id, proj_id having sum(chargehours)=0

order by empl_id

seems like you can use having clause with sum. both of these queries fail

select empl_Id, proj_id, sum(chargehours) SumChargeHours

from TempCPData1

group by empl_Id, proj_id having SumChargeHours=0

order by empl_id

select empl_Id, proj_id, sum(chargehours)

from...

I agree with you. Whatever doesnt have a match shouldn't be #matches table.

This is what I see in the report.... wonder why?

Schema Changes History: [tripwiredb]

on 006-sql2005 at 3/27/2008 12:11:11 PM

This report provides a history of all committed DDL statement executions within the...

Thanks Jason. It worked.

🙂

same result:

START_DT END_DT

----------------------- -----------------------

2008-03-01 00:00:00.000 2008-03-15 00:00:00.000

2008-02-16 00:00:00.000 2008-02-29 00:00:00.000