sql - I have NULL results for thousands of rows. How do I exclude those from populating when they don't exist? -

-

i have code @ sales employee of mine. hired create growth on extinct customers. on 1,000+ customers have in dbase, effect 100. there have been lot of rows generated value null. want report exclude rows of customers more efficient in understanding management. how accomplish this?

    select  t1.cardcode 'bp code',         t1.cardname 'bp name',         count(case when t1.slpcode<>'37' t0.docnum end) '# of orders',         sum(case when t1.slpcode<>'37' t0.doctotal end) 'total orders amt',         sum(case when t1.slpcode<>'37' t0.doctotal end)/         count(case when t1.slpcode<>'37' t0.docnum end) 'avg order size',         count(case when t1.slpcode='37' t0.docnum end) '# of orders',         sum(case when t1.slpcode='37' t0.doctotal end) 'total orders amt',         sum(case when t1.slpcode='37' t0.doctotal end)/         count(case when t1.slpcode='37' t0.docnum end) 'avg order size'     ordr t0 inner join ocrd t1 on t0.cardcode=t1.cardcode    t0.docstatus = 'c'         , t0.canceled <> 'y'         , t0.docdate >= '2015-05-26'  group    t1.cardcode,             t1.cardname  order    t1.cardname 

select tnot.*, tyes.* ( select ocrd.cardcode 'bp code',               ocrd.cardname 'bp name',               count(ordr.docnum) '# of orders',               sum(ordr.doctotal) 'total orders amt'          ocrd          left join ordr             on ordr.cardcode= ocrd.cardcode            , ordr.canceled <> 'y'           , ordr.docdate >= '2015-05-26'           , ocrd.slpcode <> '37'       group ocrd.cardcode,               ocrd.cardname      ) tnot     join ( select ocrd.cardcode 'bp code',               ocrd.cardname 'bp name',               count(ordr.docnum) '# of orders',               sum(ordr.doctotal) 'total orders amt'          ocrd          join ordr             on ordr.cardcode= ocrd.cardcode            , ordr.canceled <> 'y'           , ordr.docdate >= '2015-05-26'           , ocrd.slpcode  = '37'       group ocrd.cardcode,               ocrd.cardname      ) tyes      on tnot.[bp code] = tyes.[bp code]    , tnot.[bp name] = tyes.[bp name]  order tyes.[bp name]

Comments

Post a Comment

Popular posts from this blog

python - Healpy: From Data to Healpix map -

-
Image
i have data grid rows represent theta (0, pi) , columns represent phi (0, 2*pi) , f(theta,phi) density of dark matter @ location. wanted calculate power spectrum , have decided use healpy. what can not understand how format data healpy use. if provide code (in python obvious reasons) or point me tutorial, great! have tried hand @ doing following code: #grid dimensions nrows*ncols (subject change) theta = np.linspace(0, np.pi, num=grid.shape[0])[:, none] phi = np.linspace(0, 2*np.pi, num=grid.shape[1]) nside = 512 print "pixel area: %.2f square degrees" % hp.nside2pixarea(nside, degrees=true) pix = hp.ang2pix(nside, theta, phi) healpix_map = np.zeros(hp.nside2npix(nside), dtype=np.double) healpix_map[pix] = grid but, when try execute code power spectrum. specifically, : cl = hp.anafast(healpix_map[pix], lmax=1024) i error: typeerror: bad number of pixels if point me tutorial or edit code great. more specifications: data in 2d np array , can change numrows/...
Read more

c - Bitwise operation with (signed) enum value -

-
i using enumerator values flags: typedef enum { = 0x00, b = 0x01u, // u has no influence, expected c = 0x02u, // u has no influence, expected ... } enum_name; volatile unsigned char* reg = someaddress; *reg |= b; according misra-c:2004 bitwise operations shall not done signed type. unfortunately, compiler iar use signed int (or short or char) underlying type of enums, , option can find relates size, not signedness ("--enum-is-int"). according iar c/c++ development guide arm , pages 169 , 211, can define type of enum s if enable iar language extensions ( -e command-line option, or project > options > c/c++ compiler > language > allow iar extensions in ide). in particular, should define "sentinel" value, make sure compiler chooses correct type. prefers signed types, , uses smallest possible integer type, sentinel should largest positive integer corresponding unsigned integer type can describe. example, typedef enum ...
Read more

xslt - Unnest parent nodes by child node -

-
in xml there items 0-n attributes , item should copied each attribute new item 1 attribute. given xml this: <?xml version="1.0" encoding="utf-8" ?> <items> <item> <name>a</name> <attributes> <attribute> <key>attribute1</key> <value>1</value> </attribute> </attributes> </item> <item> <name>b</name> </item> <item> <name>c</name> <attributes> <attribute> <key>attribute1</key> <value>5</value> </attribute> <attribute> <key>attribute2</key> <value>2</value> </attribute> <attribute> <key>attri...
Read more