Nice 1 :w00t:

Really astonished no repy

So sorry admin :-(:ermm:

Thanks Jeff ,

i agree with ur suggestion to create index on id_updt column.

the script is same, which i have modified in my script given below

where id_updt>=convert(datetime,convert(varchar(10),getdate()-3,101))

and...

Hi folks,

The script is fine but as per performance concern we should not use any function in where condition. My script is

Convert(varchar(10),id_updt,101) >=Convert(varchar(10),getdate()-3,101)

data retrieving from trigger table for...

Yeh Phil ..thanx for ur time and discussion ..

Though i got some more info about Pivot as u(Phill) know we can use crosstab fun for the desired output while only...

can any body help me out...?

Thanks waiting for....:hehe:

yeh phill exactly. i m having final data and i can do the same in excel sheet (i min to say manual pivoting) but requirement is to automate in...

Actually client is going to spool this report on the basis of between transaction dates how many processed and pending according to branch and region wise. like bangalore for the...

Thanks Phill, for your great suggession.

now here below are my table details

/*************/

create table #Mis

(

region varchar(50),

branch varchar(60),

trdate datetime,

reportcnt int,

pendingcnt int

)

insert into #Mis values ('Bangalore','BG40-BELGAUM','2013-05-06 00:00:00.000',0,1)

insert into #Mis values...

Thanx Dear for ur ans.

This might be a interesting question , but i don't think so..coz u should mention the server wheather it is 2k/05/08.As u gave ans 0 ,1 it is correct in...

dear

How d whole table will drop ....could u plz elaborate