sql server - Simplify T-SQL Query -

-

i simplify query if possible.

select      max(tdatetimeofsurvey)       stocks.dbo.tblsurvey     (           (select isnull(sum(twettons), 0)          stocks.dbo.tblsurvey          tstockareaid = 3           , tdatetimeofsurvey between '20140201' , '20140228') +        (select isnull(sum(twettons), 0)         stocks.dbo.tblsurvey         tstockareaid = 103          , tdatetimeofsurvey between '20140201' , '20140228') +        (select isnull(sum(twettons), 0)         stocks.dbo.tblsurvey         tstockareaid = 181          , tdatetimeofsurvey between '20140201' , '20140228')     ) > 0 , tstockareaid in (3,103,181) -- ras, soil, dorb , tdatetimeofsurvey between '20140201' , '20140228'

many thanks, pierre

please try:

select max(tdatetimeofsurvey)  stocks.dbo.tblsurvey      tstockareaid in (3,103,181) ,      tdatetimeofsurvey between '20140201' , '20140228'  having sum(twettons)>0

Comments

Post a Comment

Popular posts from this blog

python - matpltolib navigation toolbar edit curves and parameters line color automatically changes issue -

-
let's consider axis has multiple lines colors such blue, green, yellow, red, magenta, cyan etc. when user selects curve , presses ok without changing anything, automatically yellow , green colors changed slight difference. this happens yellow, green colors. import sys import numpy np matplotlib.figure import figure import matplotlib matplotlib.use("qt4agg") matplotlib.rcparams['backend.qt4']='pyside' matplotlib.backends.backend_qt4agg import figurecanvasqtagg figurecanvas, navigationtoolbar2qtagg navigationtoolbar matplotlib.figure import figure import pyside pyside import qtgui, qtcore class myapp(qtgui.qmainwindow): def __init__(self, parent=none): qtgui.qmainwindow.__init__(self, parent) self.widget = qtgui.qwidget() self.fig = figure((5.0, 4.0), dpi=100) self.canvas = figurecanvas(self.fig) self.toolbar = navigationtoolbar(self.can...
Read more

node.js - Nodejs javascript implementation of PBEWithMD5AndTripleDES/CBC/PKCS5Padding -

-
in order write simple nodejs app talking server written in java have implement following functionality nodejs. public class crypto { cipher decipher; byte[] salt = { (byte) 0x01, (byte) 0x02, (byte) 0x03, (byte) 0x04, (byte) 0x0a, (byte) 0x0b, (byte) 0x0c, (byte) 0x0d }; int iterationcount = 10; public crypto(string pass) { try { keyspec keyspec = new pbekeyspec(pass.tochararray(), salt, iterationcount); secretkey key = secretkeyfactory.getinstance( "pbewithmd5andtripledes").generatesecret(keyspec); ecipher = cipher.getinstance("pbewithmd5andtripledes/cbc/pkcs5padding"); algorithmparameterspec paramspec = new pbeparameterspec(salt, iterationcount); decipher.init(cipher.decrypt_mode, key, paramspec); } catch (exception ex) { } } } i use crypto module of nodejs var crypto = require('crypto'), pass = new buffer(wek), salt = new buffer([0x01, 0x02, 0x03, 0x0...
Read more