Hey Naven
My problem got solved
i actually missed soemthign in where clause i have added the option called
aprove date in it and it fetched the record in 10 minutes time
Thanks so much for ur time in replying to my mail
Regards
Vik
On 5/8/08, Vikas... <[EMAIL PROTECTED]> wrote:
>
> Hi Naven
>
> thanskf ro the reply
>
> please find the query below
>
> ************************************************
>
> SELECT top 100 percent convert(varchar,a.approvedate,112) as [date],
> rtrim(a.accountnumber)+replicate(' ',16-len(rtrim(a.accountnumber))) as
> accountnumber,
> dbo.Get_Value(accountname,100) as accountname ,
> convert(varchar, convert(datetime,createdate),112) as AccountOpenDate ,
> dbo.Get_Value(a.comment,1016) as OperatingIns,
> dbo.Get_Value((select acctstatuscode from svs_account..acctstatus c where
> c.acctstatusid=a.statusid),16) as AccountStatus ,
> (rtrim(icnumber1)+replicate (' ',15-len(rtrim(icnumber1)))) as CUSTID ,
> dbo.Get_Value(signaturename,100) as [CUSTID Name],
> (case when (select count(*) from svs_account..signcardtable s where
> s.accountnumber=b.accountnumber and s.branchnumber=b.branchnumber and
> s.signcardnumber=b.signcardnumber)>=1 then
> 'ENABLE '
> else 'DISABLE ' end)as CUSTIDstatus,
> rtrim(a.imagefilename)+replicate(' ',22-len(rtrim(a.imagefilename)))as
> imagefilename ,icnumber1 as CustomerID,signaturenumber ,
> (rtrim(b.ICNumber1)+'.tiff')+replicate('
> ',22-len(rtrim(b.ICNumber1)+'.tiff')) as SignatureFile ,a.Branchnumber,
> approvedate
> from svs_account..account a , svs_account..signature b
> where a.accountnumber=b.accountnumber and a.branchnumber=b.branchnumber
> and b.icnumber1 not in (
> select imagefile from legacydetailtbl)
>
>
> ************************************************
>
>
> On 5/8/08, Neven MacEwan <[EMAIL PROTECTED]> wrote:
> >
> > Vikas
> >
> > Can you post the text of the query?
> >
> > Basic Pointers
> >
> > 1/ Add indexes for ther foreign keys (these can allow duplicates)
> > 2/ Restrict the result set (I assume you dont want the query to return
> > 10 million rows)
> > 3/ use ansi join syntax
> >
> > N
> >
> >
> > Hi
> > > I have an query related to an sql sever 200o using delphi 5. Not sure
> > > if this is the right palce to ask it. Still i belive may be soemone can
> > > help
> > > me in this
> > > I am creating a store procedure.
> > > In that i am fetching the information on the basis of join between
> > > two table.
> > > say table 1 and table2. Now thign is at my client place table 1 has
> > > 10 million records and table 2 has 15 million records.
> > > Now i have done a join between these two table depending on
> > > tabl1.x=table2.x and table1.y=table2.y. I have used the primary key in
> > > colum
> > > x of table 1 that emans it automaticaly created a clustered idex. Now
> > > problem is when i execute this query it takes more than hour to run this
> > > query. Any way i can reduce the time of query using any option.i can't use
> > > primary keys on table2 sicne i do have duplicate values.
> > > Regards
> > > Vikas
> > > Solution consultant
> > > NCR coorporation
> > >
> > > --
> > > vikas
> > >
> > > ------------------------------------------------------------------------
> > >
> > > _______________________________________________
> > > NZ Borland Developers Group - Delphi mailing list
> > > Post: delphi@delphi.org.nz
> > > Admin: http://delphi.org.nz/mailman/listinfo/delphi
> > > Unsubscribe: send an email to [EMAIL PROTECTED] with
> > > Subject: unsubscribe
> > >
> >
> > _______________________________________________
> > NZ Borland Developers Group - Delphi mailing list
> > Post: delphi@delphi.org.nz
> > Admin: http://delphi.org.nz/mailman/listinfo/delphi
> > Unsubscribe: send an email to [EMAIL PROTECTED] with Subject:
> > unsubscribe
> >
>
>
>
> --
> vikas
--
vikas
_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: delphi@delphi.org.nz
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to [EMAIL PROTECTED] with Subject: unsubscribe
