Re: help with group by ..

Article View: borland.public.interbase.sql

Article #165

Back to borland.public.interbase.sql Previous Next

#165

From: Karol Bieniaszewski
Date: Wed, 25 Jun 2008 05:19

23 lines
1791 bytes

Uzytkownik "Wayne Niddery (TeamB)" <wniddery@chaffaci.on.ca> napisal w 
wiadomosci news:48612d51$1@newsgroups.borland.com...
> "Karol Bieniaszewski" <liviuslivius@poczta.onet.pl> wrote in message 
> news:4860b9cd@newsgroups.borland.com...
>>
>> Views can not be used to solve this
>> becaouse of some empty month in one of the tables
>
>
> When querying the views, try a left join instead of the inner join in my 
> example query.
>
> -- 
> Wayne Niddery - TeamB (www.teamb.com)
> Winwright, Inc. (www.winwright.ca)


becaouse of problem with storing plans
i change view to selectable stored procedure
and all work as expected and performance also is ok :)

Karol Bieniaszewski

Technical Details

Message-ID: <4861d557@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References:

<485f842b@newsgroups.borland.com> <485fb1d8$1@newsgroups.borland.com> <48608627$1@newsgroups.borland.com> <4860b9cd@newsgroups.borland.com> <48612d51$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,8abde91de922829b
X-Google-Attributes: gid114a0e,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Karol Bieniaszewski" <liviuslivius@poczta.onet.pl>
Newsgroups: borland.public.interbase.sql
References: <485f842b@newsgroups.borland.com> <485fb1d8$1@newsgroups.borland.com> <48608627$1@newsgroups.borland.com> <4860b9cd@newsgroups.borland.com> <48612d51$1@newsgroups.borland.com>
Subject: Re: help with group by ..
Date: Wed, 25 Jun 2008 07:19:34 +0200
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5512
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 195.205.151.58
Message-ID: <4861d557@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1214371159 195.205.151.58 (24 Jun 2008 22:19:19 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message