Comments by priya naidu1

priya naidu1 2-Aug-12 5:37am View

My other queries are not slow executing. Only for this procedure i even used indexing in database. but somewhere the process is getting struck and the execution is slowed.

priya naidu1 24-Jul-12 8:46am View

No i did not use any functions, but i used indexing technique. I am not finding it to reduce the execution time but.

priya naidu1 23-Dec-11 2:00am View

Actually im looking in sqlsever it self...
Can u tel me for any alt in the backend process?

priya naidu1 17-Sep-11 6:33am View

@ Tejas_Vaishnav,

Oh, I face this kinda problem few of the times for which i am unable to open the procedure for further modifications. Now the problem is been sort.
Actually i don't have the code to provide it here.Again when i find and face the similar kinda error, i will update the code here.

Thanks

priya naidu1 18-Jul-11 1:57am View

Hmm.. My procedural Condition is something like this..

select a.LeaveId, a.EmpCode, a.Reason, convert(varchar,AppliedDate,103)AppliedDate, b.EmpName
from Tt_LeaveForm_Details as a,Adm_Mt_UserDetails as b
where a.EmpCode=b.EmpId
and ( ((convert(datetime,convert(varchar,@pFromDate,103),103)<=convert(datetime,convert(varchar,AppliedDate,103),103))) or ((convert(datetime,convert(varchar,@pFromDate,103),103)<=convert(datetime,convert(varchar,AppliedDate,103),103)))
or
((convert(datetime,convert(varchar,@pFromDate,103),103)<=convert(datetime,convert(varchar,AppliedDate,103),103))) ) and a.Reason like '%as%'
order by AppliedDate desc

Can u plz improve this part?

priya naidu1 15-Jul-11 3:09am View

Yeah, May be that was the reason. Anyways thanks for the correction.

priya naidu1 15-Jul-11 2:38am View

select a.YearId,a.codeid,a.linkid,a.code, a.codename,
b.CodeId ,b.Code , b.CodeName ,c.Codeid,c.code,c.Codename,a.AcctType,d.FYId

from FinancialYear d,Accounts a left join Accounts b on(b.linkid=a.codeid)
left join Accounts c on(c.linkid=a.codeid)

where a.YearId=d.FYId and
b.CodeId=a.CodeId and
a.linkid=6 and a.flag<>0
and a.CodeId=9
and a.accttype='R'

This was the query which i have writen in my procedure, but here duplications are going on for all the columns. which means repeatation of the rows. Please help me in using the "group by "statement.

Comments by priya naidu1 (Top 7 by date)