Than'x Mr David  And Mr Phil

Ur query is right but it does not give me my desired output. I here by sends the data and please give the sol. The...

Thanks Mr Phil Parkin

I am Very Thankful to u.

I want the report in which

I want to see all the city and...

Than'x Jesper

I am Giving u the details

Test1

**********

City1       Name1

City2       name2

city1       Name3

city4       Name4

City2       Name6

City1       Name7

-------

Test2

*************

01         City1             10/08/05         xxx

02         City2              10/8/05          yyy

03         city1              11/8/05           xxx

04         City3               11/8/05          xxx

--------

Test3

***********

01           5              G

02           7               v

03           0               g

-----

Can u Understand now...

Hi Iain

The tables and the query is wotrking perfectly.

Since i have tried And i got result

So if u can give some junk data then it will be easier to...

MR Remy

Than'x

But I am always Query Analyzer. So I need the query

So pl help if u can

Than'x for ur  help

Hi sushila

Than'x Ur code working properly

But ont thing I have to follow and is that

If i execute this query I am getting the inserted records in that table for once...

Hi guys

Is there any who can help me  in following

I have two table test1 and test2

test1 has 20 records

When I Execute the following

Delete test1

All records are to be...

sushila and Remi 

Pl  follow this

First I create this trigger

CREATE TRIGGER trgInsertIntoNewTable

ON test2

FOR DELETE

AS

insert   INTO test3  * FROM test2

GO

I got the message

" The command  created successfuly"

Now I...

For sushila

Y i have a test3 table and I have given the total operation before to this

For Remi

I am using

delete test3

Than'x  for trying

Pl solve this

Sorry Remi Gregoire  and Sushila

The table get deleted but the value is not inserted in the test3 table

So pl solve...

CREATE TRIGGER tr_AuditTableName_D_1 ON Test2 for

DELETE

AS

SET NOCOUNT ON

Insert into test3(a, b) Select acctno, acctname from test2

GO

Sorry Remi Gregoire 

ur code gives the...

CREATE TRIGGER trgInsertIntoNewTable

ON test2

FOR DELETE

AS

SELECT * INTO test3 FROM test2

GO

Sorry Sushila This trigger object is created but it gives the follwing error

Invalid object name 'test3'

So pl solve...

Yes Mr Remi Gregoire 

This is the trigger case

so pl help me if u can

pl help anyone who can do it

no this query gives error

and i have only one table named test

the records in test table must be inserted into new table at the time of deletion

pl solve this if...

U can do by this way and get the result

SELECT sum(draw) as tot_draw , sum(retuns) as tot_returns, 

sum(retuns + short + notdel + damag) as unsold,

sum(draw-retuns-short-notdel-damag) as Netsale,

sum(draw)/sum(retuns +...