Yes it is neccessary to insert into another table because based on that many more further processes & calculation will be done and i will be using into my application...

exactly Vladan,

thats what i need,the basic idea to do that is to trace the transactionand count for how many hrs the actual transaction was there

i.e suppose i had 1st transaction...

no it wont work each time new record gets added which wont solve the problem.

i will expalin again i had prepared trigger on table TRAN_TABLE which is having column...

thx but its sql 2000

yes i am getting reply from same address

its already done but not working

i had written these code but it gives me syntax error

where headcountdetail is stored procedure and coulmn1 and column2 are coulmns of table2

CREATE TRIGGER HeadCount AFTER INSERT ON table2

...

i had written these code

it give me syntax error

CREATE TRIGGER HeadCount AFTER INSERT ON table2

FOR EACH ROW BEGIN

IF(NEW. coulmn1>2 AND ...

there is table1 with coulmnA,coulmnB,coumnC,coulmnd and

there is table2 with coulmn1,coulmn2

and my procedure is

create procedure Detail

as

@cardtape VARCHAR(100),

@device varchar(10)

update table1

set coulmnB=@cardtape,coulmnC=@devid

i have to write trigger on table2 after insert the inserted...

hi, its working thanks a lot

now i am trying the export the data in excel format using bcp code.

i had written the simple procedure of select statement.

now if run only...

Hi Thankyou very much its working

and now i am trying to export the data using bcp

using below code where output is stored procedure which i had writen and it is...

no it doesnt work

1st query--

select sum(table1.coumn1),table1.column2,table2.column3 Table1

inner join table2 on table1.coulmn3=table2.column4

where table1.column2='Y'

group by column2,column3

2nd query--

select sum(table1.coumn1),table1.column2,table2.column3 from Table1

inner join table2 on table1.coulmn3=table2.column4

where table1.column2='N'

group by column2,column3

but it has to be combined in...

yes it is in full recovery mode

I had shrink the log file but there is no effect

it is showing the same thing the space which is allocated is 30 gb but actual size of the log...