At least not for me.

Its giving 6, 1 & 3 respectively.

Phil & Sean both are right but you can use something like this..

Insert into Table2 (col3)

Select col1 + ' ' + col2 from table1

May be we both are working on different data set.

Here is mine.

create table playground.sale (email varchar(255), quantityint);

insert into sale values ('email1', 1);

insert into sale values ('email1', 2);

insert into sale...

No, min or max would produce a different result that what he is expecting. Min will produce 1 and max will produce 3.

See you are getting 24 because of cartesian.

So if you use

select sum(distinct(s.quantity))--,s.email

from sale s

inner join eval e

on s.email = e.email

where s.email = 'email1'

if will give you correct result.

As you have mentioned that the recovery model is simple, so I believe yes. But I have never done that. But I have used sp_repldone and worked as expected....

Anything meaningful?

I though you are looking for something to "What if i Just want to mark just the transaction in question as done.. using the @xactid ", and the url...

Check this url.. it may help.

http://blogs.msdn.com/b/repltalk/archive/2011/08/23/using-sp-repldone-to-skip-a-transaction.aspx