Viewing 13 posts - 1 through 13 (of 13 total)
Really astonished no repy
So sorry admin :-(:ermm:
Thanks
SUrya
August 27, 2014 at 3:13 am
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...
Thanks
SUrya
January 14, 2014 at 12:40 am
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...
Thanks
SUrya
January 11, 2014 at 9:25 pm
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...
Thanks
SUrya
June 27, 2013 at 6:13 am
can any body help me out...?
Thanks
SUrya
June 27, 2013 at 4:32 am
Thanks waiting for....:hehe:
Thanks
SUrya
June 27, 2013 at 3:01 am
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...
Thanks
SUrya
June 27, 2013 at 2:47 am
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
SUrya
June 27, 2013 at 1:32 am
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...
Thanks
SUrya
June 27, 2013 at 1:13 am
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...
Thanks
SUrya
January 29, 2010 at 6:55 am
Viewing 13 posts - 1 through 13 (of 13 total)