SQL Query in Excel PowerPivot -


i have issue when try validate sql query , says 'a column name can not blank'

i have been able shortened version without joining 2 table together.

select [dbo].[stocktransactions].[transactionnumber],  [dbo].[stocktransactions].[activitydate],  [dbo].[stocktransactions].[sitecode],  [dbo].[stocktransactions].[commoditycode],  [dbo].[stocktransactions].[commodityvarietycode],  [dbo].[stocktransactions].[bingradecode],  [dbo].[stocktransactions].[samplemoistureqty],  [dbo].[stocktransactions].[partition],  [dbo].[stocktransactions].[sampleproteinqty],  [dbo].[stocktransactions].[sampletestweight],  [dbo].[stocktransactions].[sampleretentionqty],  [dbo].[stocktransactions].[samplescreeningsqty],  sum([dbo].[stocktransactions].[unshrunktonnes]),  [dbo].[stocktransactions].[sampleskinningsqty], [dbo].[vw_oms_sampleresults].[testcode], [dbo].[vw_oms_sampleresults].[result]    [dbo].[stocktransactions]  left outer join [dbo].[vw_oms_sampleresults]  on ([dbo].[stocktransactions].[stocktransactionsomsid]=[dbo].             [vw_oms_sampleresults].[stocktransactionsomsid])   (([dbo].[stocktransactions].[activitydate]>'1/10/2016'  , [dbo].[stocktransactions].[transactiontype]='grower receival                      '  , [dbo].[stocktransactions].[businessunitcode]='ausbulk'  , (not [dbo].[stocktransactions].[ownername]='shrink')  , [dbo].[stocktransactions].[commoditycode]='wh'  , [dbo].[stocktransactions].[seasonlongcode]='2016/2017'  , [dbo].[vw_oms_sampleresults].[testcode] in ('ff', 'fr', 'fs', 'snl')  , [dbo].[stocktransactions].[sitecode] in ('arn', 'buc', 'cow', 'cum', 'cun', 'dar', 'edi', 'ell', 'kie', 'kim', 'kpi', 'kya', 'lin', 'loc', 'man', 'mda', 'min', 'nei', 'nun', 'pen', 'pnt', 'poo', 'rud', 'stb', 'the', 'too', 'tum', 'ung', 'wad', 'war', 'wha', 'wit', 'wrl', 'wud', 'yan', 'yee')))   group [dbo].[stocktransactions].[transactionnumber],  [dbo].[stocktransactions].[activitydate],  [dbo].[stocktransactions].[sitecode],  [dbo].[stocktransactions].[commoditycode],  [dbo].[stocktransactions].[commodityvarietycode],  [dbo].[stocktransactions].[bingradecode], [dbo].[stocktransactions].[sampleretentionqty],  [dbo].[stocktransactions].[samplemoistureqty],  [dbo].[stocktransactions].[sampleskinningsqty], [dbo].[stocktransactions].[partition],  [dbo].[stocktransactions].[sampleproteinqty],  [dbo].[stocktransactions].[sampletestweight],  [dbo].[stocktransactions].[samplescreeningsqty],  [dbo].[vw_oms_sampleresults].[testcode],  [dbo].[vw_oms_sampleresults].[result],  [dbo].[stocktransactions].[partitionstoragetype]

any why throwing error?


Comments

Post a Comment

Popular posts from this blog

Add new key value to json node in java -

i have json file : { "id":1, "name":"abc", "addressdetails": { "city":"newyork" } } i wanted add 1 more key-value ("pincode" : "414141") node 'addressdetails'. i tried using : objectmapper mapper = new objectmapper(); jsonnode root = mapper.readtree(new file("d://test.json")); objectnode node = mapper.createobjectnode(); node.with("addressdetails").put("pincode", "414141"); but it's not getting added, there way can ? you can try you should modify file path objectmapper mapper = new objectmapper(); objectnode nodes = mapper.readvalue(new file("d:\\test.txt"), objectnode.class); nodes.with("addressdetails").put("pincode", "414141"); mapper.writer().writevalue(new file("d:\\test.txt"), nodes);
Read more

javascript - Highcharts Synchronized charts with missing data points -

Image
i have 2 charts display time series data trying synchronize crosshair , tool tips. however, charts not have same number of data points. causes crosshair , tooltip become out of sync between 2 graphs. i have enabled connectnulls: true on both , while smoothes lines, not add data points time periods don't exist. is there way configure connectnulls inserts filler points? updated here simple jsfiddle example, value missing day causes crosshairs become out of sync between 2 graphs. to set actual x distance between points, can set xaxis.ordinal false. other solution put null values in empty places. set pointstart , pointinterval properties. api reference: http://api.highcharts.com/highstock/xaxis.ordinal http://api.highcharts.com/highstock/plotoptions.series.pointstart http://api.highcharts.com/highstock/plotoptions.series.pointinterval examples: http://jsfiddle.net/csgbxdaj/ - setting ordinal false http://jsfiddle.net/gjxhbf7w/ - putting nulls i
Read more

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

i've set bento/ubuntu-16.04 vagrant box using php 5.6, , getting following error quite few times when try , run shell script: "uncaught reflection exception: class domdocument not exist". i've tried adding following top of script (not together), each no success: "sudo apt-get install php5.6-xml", "sudo apt-get install php5-xml", "sudo apt-get install php-dom" i've tried resetting server "sudo service apache2 restart". does have suggestions?
Read more