Tema: Re: Dar karta T-SQL select'as
Autorius: Jornada Del Muerto
Data: 2011-08-12 16:57:50
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=windows-1257" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 9.00.8112.16430">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV>
<DIV><FONT size=2 face=Arial>UPS turi buti taip:</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial></FONT></DIV>
<DIV>
<DIV><FONT size=2 face=Arial>(</FONT></DIV>
<DIV><FONT size=2 face=Arial> (<FONT size=3
face="Times New Roman">INV1.datephysical Is Not Null And LIK1.DATEPHYSICAL IS
NULL AND ( INV1.datephysical BETWEEN '2011.07.01' AND '2011.07.31')
</FONT></FONT></DIV>
<DIV><FONT size=2 face=Arial><FONT size=3
face="Times New Roman">Or</FONT></FONT></DIV>
<DIV><FONT size=2 face=Arial> (<FONT size=3
face="Times New Roman">LIK1</FONT></FONT>.datephysical Is Not Null And
INV1.DATEPHYSICAL IS NULL AND ( LIK1.datephysical BETWEEN '2011.07.01' AND
'2011.07.31')</DIV>
<DIV>)</DIV>
<DIV><FONT size=2 face=Arial>AND </FONT></DIV>
<DIV><FONT size=2 face=Arial>(</FONT></DIV>
<DIV> INV1.datephysical Is Not Null OR LIK1.datephysical Is
Not Null</DIV>
<DIV>)</DIV>
<DIV></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Sklewstus
pamirsau:)</FONT></DIV></DIV></DIV></BODY></HTML>