[DUG] sql query issue

[Vikas...]

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... <vikas.image at gmail.com> 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 <neven at mwk.co.nz> 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 at delphi.org.nz
> > > Admin: http://delphi.org.nz/mailman/listinfo/delphi
> > > Unsubscribe: send an email to delphi-request at delphi.org.nz with
> > > Subject: unsubscribe
> > >
> >
> > _______________________________________________
> > NZ Borland Developers Group - Delphi mailing list
> > Post: delphi at delphi.org.nz
> > Admin: http://delphi.org.nz/mailman/listinfo/delphi
> > Unsubscribe: send an email to delphi-request at delphi.org.nz with Subject:
> > unsubscribe
> >
>
>
>
> --
>   vikas




-- 
  vikas
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20080508/22286c64/attachment.html