<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-2">
<META content="MSHTML 6.00.2900.2604" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Napr takto:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>select id,nazev, (select count * from tabulka t1
where t1.id > tabulka.id ) poradi</FONT></DIV>
<DIV><FONT face=Arial size=2> from tabulka</FONT></DIV>
<DIV><FONT face=Arial size=2> order by id</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>jinak si to musite upravit podle sebe</FONT></DIV>
<DIV><FONT face=Arial size=2>Jirka</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=novotny.pp@atlas.cz href="mailto:novotny.pp@atlas.cz">Pavel
Novotný</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=hw-list@hw.cz
href="mailto:hw-list@hw.cz">'HW-news'</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, April 05, 2005 3:37
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: OT Cislovani radku v SQL
prikazu SELCT ?</DIV>
<DIV><BR></DIV>
<DIV dir=ltr align=left><SPAN class=531122513-05042005><FONT face=Arial
size=2>Omlouvam se za OT , ale pisu sw pro laboratorni automat, ktery primo
komunikuje s SQL serverem nebo Access databazi a potrebuji nasledujici
</FONT></SPAN></DIV>
<DIV><SPAN class=531122513-05042005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=531122513-05042005><FONT face=Arial size=2>SELECT *, x
FROM tabulka</FONT></SPAN></DIV>
<DIV><SPAN class=531122513-05042005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=531122513-05042005><FONT face=Arial size=2>pricemz x by ve
vysledku tohoto selektu melo byt poradove cislo radku v danem vyberu tj
1,2,3,4,5,6.... </FONT></SPAN></DIV>
<DIV><SPAN class=531122513-05042005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=531122513-05042005><FONT face=Arial size=2>Lze to nejak resit
pomoci jazyka SQL ?</FONT></SPAN></DIV>
<DIV><SPAN class=531122513-05042005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=531122513-05042005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=531122513-05042005><FONT face=Arial
size=2>Dekuji</FONT></SPAN></DIV>
<DIV><SPAN class=531122513-05042005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=531122513-05042005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=531122513-05042005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=531122513-05042005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=531122513-05042005></SPAN> </DIV>
<P>
<HR>
<P></P>_______________________________________________<BR>HW-list mailing
list - sponsored by
www.HW.cz<BR>Hw-list@list.hw.cz<BR>http://list.hw.cz/mailman/listinfo/hw-list<BR>
<P>
<HR>
<P></P>Příchozí zpráva neobsahuje viry.<BR>Zkontrolováno Antivirovým systémem
AVG.<BR>Verze: 7.0.308 / Virová báze: 266.9.1 - datum vydání:
1.4.2005<BR></BLOCKQUOTE></BODY></HTML>