Tema: Re: Dar karta T-SQL select'as
Autorius: Rimokas
Data: 2011-08-12 15:08:08
> Pasitaisau shiek tiek, turetu buti:
>>      (INV1.datephysical >='2011.07.01' or INV1.datephysical IS NULL)  and
>>      (INV1.datephysical <='2011.07.31' or INV1.datephysical IS NULL)  and
>>      (LIK1.DATEPHYSICAL >= '2011.07.01' or LIK1.datephysical IS NULL) and
>>      (LIK1.DATEPHYSICAL <= '2011.07.31' or LIK1.datephysical IS NULL)

  OK bandysiu . Tiesa , jeigu naudot Isnull() funkcija , tuomet group by 
keikiasi . Su case viskas eina .
google friend connect ar openid ar kas kitasneklausiu2011-08-20 22:19
+c++ eilutesDaynewss2011-08-17 13:42
+C, #define - kaip isskirti du simboliuslietuvys2011-08-15 14:00
+Universitetai.. ir NoSqlfakeID2011-08-10 10:33
XML prefiksaiMauzer2011-08-10 08:14
+spring 3 + jsp vs spring 3 + jsf 1.2 vs jsf 1.2 + facletsnews2011-08-09 22:49
spring 3 + jsp vs spring 3 + jsf 1.2 vs jsf 1.2 + facletsnews2011-08-09 22:47
-Dar karta T-SQL select'asRimokas2011-08-09 10:38
Re: Dar karta T-SQL select'asDream-Colored Bunny2011-08-09 15:16
Re: Dar karta T-SQL select'asRimokas2011-08-10 09:01
Re: Dar karta T-SQL select'asJornada Del Muerto2011-08-10 17:06
Re: Dar karta T-SQL select'asRimokas2011-08-11 08:29
Re: Dar karta T-SQL select'asJornada Del Muerto2011-08-11 14:34
Re: Dar karta T-SQL select'asRimokas2011-08-12 13:09
Re: Dar karta T-SQL select'asJornada Del Muerto2011-08-12 16:51
Re: Dar karta T-SQL select'as2x502011-08-14 18:54
Re: Dar karta T-SQL select'asDainius2011-08-15 10:22
Re: Dar karta T-SQL select'asJornada Del Muerto2011-08-15 15:10
Re: Dar karta T-SQL select'asJornada Del Muerto2011-08-12 16:57
Re: Dar karta T-SQL select'asDream-Colored Bunny2011-08-12 14:35
Re: Dar karta T-SQL select'asDream-Colored Bunny2011-08-12 14:41
Re: Dar karta T-SQL select'asRimokas2011-08-12 15:08
Re: Dar karta T-SQL select'asRimokas2011-08-12 16:17
Re: Dar karta T-SQL select'asLaimis2011-08-13 00:44
Re: Dar karta T-SQL select'asJornada Del Muerto2011-08-12 16:00
Re: Dar karta T-SQL select'asDream-Colored Bunny2011-08-10 16:35
Re: Dar karta T-SQL select'asJornada Del Muerto2011-08-09 15:00
Re: Dar karta T-SQL select'asRimokas2011-08-10 08:57
Re: Dar karta T-SQL select'asJornada Del Muerto2011-08-10 16:19
Re: Dar karta T-SQL select'asJornada Del Muerto2011-08-10 17:10
+geometrinė progresijaolis2011-08-08 19:55
+REQ: MySQL uzklausataikaika2011-08-08 18:48
+facebook connect neduoda IDneklausiu2011-08-04 00:10
gal kam bus idomuJornada Del Muerto2011-08-02 17:06
+T-SQL subquery/subselect klausimasRimokas2011-08-02 16:10
+reikia patarimo del autentifikacijos mobile app <-> web serviceTadas B.2011-08-01 12:56
+Ar įdėmiai skaitote specifikacijas?ejs2011-07-31 17:50
+OT: buvo pakurtas proxy ant home pcgannet2011-07-24 21:38
+Reikia patarimo dėl SQLHyperLink2011-07-21 20:16
+OT: ISO valdymo programine irangaLeon2011-07-20 16:58
REQ: Spausdintuvu spool failu readeriodjPasco2011-07-20 11:45
+ekrano vaizdo irasymo irankisnews.omnitel.net2011-07-20 10:52
+projektukas web developeriams@Herkus2011-07-18 18:37
+.NET fake properties for PropertyGridJornada Del Muerto2011-07-18 18:27
+rfid/proximity korteliu skaitymasneklausiu2011-07-16 14:02
+MSSQL : kabliai taskaibala nemate2011-07-14 22:56
+Seamonkey, imap ir message filtraiLaimis2011-07-13 12:35
+newsletter (paveiksliukai)news.omnitel.net2011-07-11 16:38
+JAVA knygos pradedančiajam?mal2011-07-07 11:14
+OT: HTML+CSS - programuotojas ar dizaineris? Kaip manote?Jornada Del Muerto2011-07-06 14:25
+Q: SQL serverio backupprg2011-07-04 16:53
+XAMPP Mercury pasto serverio konfiguravimasRomas Smeleviius2011-06-29 14:49
+OT: Windows: file properties. DetailszZz2011-06-29 12:59
+Programuotojo kėdėHyperLink2011-06-28 10:37
+Q: MSSQL grupavimaizZz2011-06-27 08:25
freelance darbeliai joomla developeriuinews.omnitel.net2011-06-17 12:27
+gal kas galetu perlauzt programke Carlson SurvCE 2.5?HomeSite2011-06-13 19:40
+MSSQL ir koduoteTomis2011-06-13 14:46
+Q: klausimėlis apie paprasto www kainąDex2011-06-13 14:21
+REQ: patarimo!MinVodai2011-06-10 23:03
+su kuo cia parasytaneklausiu2011-06-09 13:39
+Dar vienas klausimuxHyperLink2011-06-09 11:38
+Programines irangos pardavimas pagal licenzine sutartiDonatas2011-06-09 10:08
+Dar viena problemelėHyperLink2011-06-08 16:00
+Idomus datos skaiciavimas Access'u DateDiffDonatas2011-06-08 14:22
+DDR2 RAM del visual studio 10, 4GB ar 8Gb ?If2011-06-07 14:18