Edit:

I think Ive got it now. I was selecting the TSQL:Statement Completed event instead of SP:Statement Completed Event.

Fantastic. I see what you mean about the output.

Thanks for your help everyone.

Thanks for the input. Unfortunately the Statement Completed still doesnt help me.

The problem is that the trace only shows one entry (ie the original stored proc being called).

In actually fact,...

My mistake you're right actually.

We have some in house software which takes all our stored procs, adds WITH ENCRYPTION to them, adds them to a db, then scripts the db...

yes, that it!

many thanks

Failed aswell.

Incorrect syntax near 't2'

However. If I replace the first bit:

DELETE FROM

with

SELECT * FROM

Do I get a list of the correct records im wishing to delete

Hmmm

Unfortunately that didnt work either. 0 rows affected.

And I definitely have 2 rows in table2 that arent in table1.

So do I duplicate the first half in the second half?

select cutomer_id,max(orderdate) from mytable group by customer_id

UNION

select customer_id,max(orderdate) from mytable where custorders.id not in

select cutomer_id,max(orderdate) from mytable group by customer_id

I...

Actually I just solved it, but probably alot longer way around.

I did

DELETE FROM TableB WHERE EXISTS (SELECT * FROM TableA WHERE TableA.ID=TableB.ID)

INSERT INTO TableB SELECT * FROM TableA

I guess basically...

aaha, fantastic. Thankyou

Andy

Yep, thats it. Many thanks JeffB

Many Thanks that fixed it!

Hello again,

I've run into abit of a problem with this query.

To summarise all the above, here's the final query:

DECLARE @Current table (StoreName varchar(50) not null, sales money not null)

INSERT @Current...

Noel,

Actually I fixed it another way.

The original declaration had:

DECLARE @Current table (StoreName varchar(50) not null, sales int not null)

I changed the int to money:

DECLARE @Current table (StoreName varchar(50) not null,...

Unfortunately that doesnt work.

If I had to the second half of the sp, I get an aggregate error message on the a.StoreName and b.Sales

SELECT a.StoreName, SUM(a.Sales * 1.0) as ThisPeriod,...

Actually, just one final thing.

The results I get look something like this:

Store ThisPeriod LastYear

StoreA 20 ...