ok - ok remi - you'll have to give me marks for at least trying to match your speed...know it's a lost cause but still...

CREATE TRIGGER trgInsertIntoNewTable

ON test

FOR DELETE

AS

SELECT * INTO newtable FROM deleted

GO.....?!?!

chris - shouldn't it just check for

case when sum(returns + short + notdeliver+damaged) = 0 then null else draw / sum(returns + short + notdeliver+damaged) end AS '%sale'...

as opposed...

I'm quite willing to be a heroine if you would at least tell me what it is that you are trying to accomplish with all those casts...splly. where you're trying...

Now that would definitely be useful - please add my name to the list of petitioners!

afaik - temp tables are transient by nature and definition and the only way you can view the data in temp tables is by doing a "select *..." in QA!

Or...

Not to sound like Heloise...oh wait...I think I mean Dr. Phil..

Dale - "the silky terrier has spoken" - pay heed and don't wait for...

Oh No Dale - I was hoping you hadn't heard of it!

at any rate - please be nice...I promise not to delve too...

erik...never forget BOL...if you do a "select * from sysobjects where name like '#%'" - or even simply "order by name" you should see your table...

Clothing optional? (Ha! Ha! Just checking to see if you were reading this!.........

if that didn't catch anyone's eye nothing will..

request...

you may be talking about...

SET ROWCOUNT 100 ?!?!

oops - vasc - i think we have identical solutions - looks like i cannot type even with moderate speed anymore...

..take that back...looks like...

just so you have enough options...

create table t1

(name char(3),

dtCol smalldatetime)

insert into t1 values('aaa', '8/19/2005')

insert into t1 values('bbb', '8/20/2005')

insert into t1 values('bbb', '8/19/2005')

insert into t1 values('ccc', '8/20/2005')

insert into t1 values('aaa', '7/29/2005')

insert...

yes - you can create the column as IDENTITY(int, 1,1)...but what do you want to do when you reach 999 ?!?!

you can also do a "SELECT @@VERSION" and set the QA tools - options - results - to display the results as "text"!