sql - Two group by tables stich another table -


i have 3 tables need put together.
first table main transaction table need distinct transaction id numbers , company id. has important keys. transaction ids not unique.
second table has item info linked transaction id numbers not unique , need pull items.
third table has company info has company id.

now i've sold of these first 1 through group id. second through subquery creates unique ids , joins onto first one. issue i'm having third 1 company. cannot seem create query works in above combinations. ideas?

as suggested here code. works that's because company used count doesn't give correct number. how else can company number come out correct?

select     dep.itemidapk,     dep.totalone,     dep.company,     company.vendname,     appd.itemidapk,     appd.itemname (     select         csi.itemidapk,         sum(f.totalone) totalone,         count(f.dimcurrentcompanyid) company     dbo.reportone f (nolock)     inner join dbo.dsaleitem csi (nolock)          on f.dsaleitemid = csi.dsaleitemid      inner join dbo.dimcurrentcompany cv         on f.dimcurrentcompanyid = cv.dimcurrentcompanyid     inner join dbo.dimdate dat         on f.dimdateid = dat.dimdateid     (         dat.date >='2013-01-29 00:00:00.000'         , dat.date <= '2013-01-30 00:00:00.000'     )     group csi.itemidapk ) dep inner join (     select         vend.dimcurrentcompanyid,         vend.name vendname     dbo.dimcurrentcompany vend ) company     on dep.company =  company.dimcurrentcompanyid inner join (     select         c2.itemidapk,         itemname     (         select distinct itemidapk         dbo.dimitem c     ) c1     join dbo.dimitem c2 on c1.itemidapk = c2.itemidapk ) appd     on dep.itemidapk = appd.itemidapk

for further information output following example, know code executes , companyid incorrect put (count) in make above code execute:

current results:  item number     tls      companyid    company name    item number   item name 111111         300         303         johnson corp       29323      soap   proposed results:   item number     tls      companyid    company name    item number   item name 111111         300         29         johnson corp       29323      soap


-

Comments

Post a Comment

Popular posts from this blog

amazon web services - S3 Pre-signed POST validate file type? -

i know it's possible put limit on file size content-length-range header. possible validate file type? https://docs.aws.amazon.com/amazons3/latest/dev/httppostforms.html#policyconditions i see there content-type header, if set say, audio/mp3 allow mp3 files , return error if file not mp3? i found previous question answers mention validating file size: s3 direct upload restricting file size , type you can specify content-type @ post request. you can specify @ signature, post must done content-type: { "expiration": "2007-12-01t12:00:00.000z", "conditions": [ {"acl": "public-read" }, {"bucket": "johnsmith" }, {"content-type: "audio/mp3"} ] } creating html form (using aws signature version 4) edit: @ previous question found, checking content-type.
Read more

c# - Check Keyboard Input Winforms -

i wondering if instead of doing this protected override void onkeydown(keyeventargs e) { if (e.keycode == keys.a) console.writeline("the key down."); } i set bool method , this: if(keydown(keys.a)) // whatever here i've been sitting here ages trying figure out how it. can't wrap head around it. in case wondering, plan call bool inside different method, check input. since want perform action after pressing key, using keydown event enough. but in cases suppose want check if specific key down in middle of process, can use getkeystate method way: [dllimport("user32.dll", charset = charset.auto, exactspelling = true)] public static extern short getkeystate(int keycode); public const int key_pressed = 0x8000; public static bool iskeydown(keys key) { return convert.toboolean(getkeystate((int)key) & key_pressed); } you should know, each time check key state using example iskeydown(keys.a) method returns true if ke...
Read more