Re: Q: MS SQL [cinic @ 2012-11-14 17:57:45]

Tema: Re: Q: MS SQL
Autorius: cinic
Data: 2012-11-14 17:57:45
<HTML><HEAD></HEAD>
<BODY dir=ltr>
<DIV dir=ltr>
<DIV style="FONT-FAMILY: 'Arial'; COLOR: #000000; FONT-SIZE: 10pt">
<DIV><FONT size=3 face="Times New Roman">kuo blogai where kiekis &lt;&gt; 
0?</FONT></DIV>
<DIV><FONT size=3 face="Times New Roman"></FONT>&nbsp;</DIV>
<DIV 
style="BORDER-BOTTOM-COLOR: #000000; BORDER-LEFT: #000000 4px solid; BORDER-TOP-COLOR: #000000; PADDING-LEFT: 5px; BORDER-RIGHT-COLOR: #000000; MARGIN-LEFT: 5px">
<DIV 
style="FONT-STYLE: normal; DISPLAY: inline; FONT-FAMILY: 'Calibri'; COLOR: #000000; FONT-SIZE: small; FONT-WEIGHT: normal; TEXT-DECORATION: none">
<DIV>"Baltas auksas" &lt;aa@aa.aa&gt; wrote in message 
news:k801p9$bgj$1@trimpas.omnitel.net...</DIV></DIV></DIV>
<DIV 
style="BORDER-BOTTOM-COLOR: #000000; BORDER-LEFT: #000000 4px solid; BORDER-TOP-COLOR: #000000; PADDING-LEFT: 5px; BORDER-RIGHT-COLOR: #000000; MARGIN-LEFT: 5px">
<DIV 
style="FONT-STYLE: normal; DISPLAY: inline; FONT-FAMILY: 'Calibri'; COLOR: #000000; FONT-SIZE: small; FONT-WEIGHT: normal; TEXT-DECORATION: none">Yra 
duomenu lentele:<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
Eil.nr<BR>&nbsp;&nbsp;&nbsp;&nbsp; Prekes 
pavadinimas<BR>&nbsp;&nbsp;&nbsp;&nbsp; Prekes 
partija<BR>&nbsp;&nbsp;&nbsp;&nbsp; Mato vienetai<BR>&nbsp;&nbsp;&nbsp;&nbsp; 
Kiekis<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1<BR>&nbsp;&nbsp;&nbsp;&nbsp; Preke 
A<BR>&nbsp;&nbsp;&nbsp;&nbsp; Partija A<BR>&nbsp;&nbsp;&nbsp;&nbsp; 
KG<BR>&nbsp;&nbsp;&nbsp;&nbsp; 6<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
2<BR>&nbsp;&nbsp;&nbsp;&nbsp; Preke A<BR>&nbsp;&nbsp;&nbsp;&nbsp; Partija 
A<BR>&nbsp;&nbsp;&nbsp;&nbsp; VNT<BR>&nbsp;&nbsp;&nbsp;&nbsp; 
0<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3<BR>&nbsp;&nbsp;&nbsp;&nbsp; Preke 
A<BR>&nbsp;&nbsp;&nbsp;&nbsp; Partija B<BR>&nbsp;&nbsp;&nbsp;&nbsp; 
KG<BR>&nbsp;&nbsp;&nbsp;&nbsp; 70<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
4<BR>&nbsp;&nbsp;&nbsp;&nbsp; Preke A<BR>&nbsp;&nbsp;&nbsp;&nbsp; Partija 
B<BR>&nbsp;&nbsp;&nbsp;&nbsp; VNT<BR>&nbsp;&nbsp;&nbsp;&nbsp; 
216<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5<BR>&nbsp;&nbsp;&nbsp;&nbsp; Preke 
A<BR>&nbsp;&nbsp;&nbsp;&nbsp; Partija C<BR>&nbsp;&nbsp;&nbsp;&nbsp; 
KG<BR>&nbsp;&nbsp;&nbsp;&nbsp; 166<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
6<BR>&nbsp;&nbsp;&nbsp;&nbsp; Preke A<BR>&nbsp;&nbsp;&nbsp;&nbsp; Partija 
C<BR>&nbsp;&nbsp;&nbsp;&nbsp; VNT<BR>&nbsp;&nbsp;&nbsp;&nbsp; 
576<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7<BR>&nbsp;&nbsp;&nbsp;&nbsp; Preke 
A<BR>&nbsp;&nbsp;&nbsp;&nbsp; Partija D<BR>&nbsp;&nbsp;&nbsp;&nbsp; 
KG<BR>&nbsp;&nbsp;&nbsp;&nbsp; 104<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
8<BR>&nbsp;&nbsp;&nbsp;&nbsp; Preke A<BR>&nbsp;&nbsp;&nbsp;&nbsp; Partija 
D<BR>&nbsp;&nbsp;&nbsp;&nbsp; VNT<BR>&nbsp;&nbsp;&nbsp;&nbsp; 
324<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9<BR>&nbsp;&nbsp;&nbsp;&nbsp; Preke 
A<BR>&nbsp;&nbsp;&nbsp;&nbsp; Partija E<BR>&nbsp;&nbsp;&nbsp;&nbsp; 
KG<BR>&nbsp;&nbsp;&nbsp;&nbsp; 45<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
10<BR>&nbsp;&nbsp;&nbsp;&nbsp; Preke A<BR>&nbsp;&nbsp;&nbsp;&nbsp; Partija 
E<BR>&nbsp;&nbsp;&nbsp;&nbsp; VNT<BR>&nbsp;&nbsp;&nbsp;&nbsp; 
140<BR><BR><BR><BR>Kai parasyti selecta, kad rodytu tik visus irasus, isskyrus 1 
ir 2 eilutes ?<BR>Kitaip sakant yra tikslas issitraukti produktu sarasiuka, 
kuriu kiekis VNT <BR>&lt;&gt; 0 ir LKG &lt;&gt; 0 
<BR><BR></DIV></DIV></DIV></DIV></BODY></HTML>