14 Solved Topics

Remove Filter
Member Avatar for
Member Avatar for ehpratah

Hi Im having a hardtime making my query work the way it should be.i'm getting wrong output. basically what im trying to do is a simple user statistic that will show the user inputed data and user processed data base on the date range the user selected. heres the screenshots …

Member Avatar for ehpratah
0
283
Member Avatar for ehpratah

Hi everyone i need some help down here. i am trying to connect multiple db and at the same time i want to sum the value of the column. what i have right now is this SELECT SUM(total) as branch1sales FROM icm.sales UNION SELECT sum(total) as branch2sales FROM hism.sales its …

Member Avatar for ehpratah
0
327
Member Avatar for ehpratah

Hi need some insight on how to show record from different database on the same server. i also tried using join but didnt get the correct output. im finding a way to make it work using just one query. my last resort will be using different query to select the …

Member Avatar for ehpratah
0
335
Member Avatar for Gobble45

Hi All, Firstly I will say that this exercise is for my learning experiences through an online course. However I have spent a combined total of about 6 hours working on this question and I am completely stumped on how to get the correct answers. The question: > List the …

Member Avatar for rajkumar007
0
265
Member Avatar for jkvt

Hi, I have two LINQ queries that produce two different results, but the fields, while having different names, are essentially the same. I am trying to union them together (although concat in this case should produce the same results), but I am getting an error. My thought is that I …

Member Avatar for jkvt
0
4K
Member Avatar for anjerodesu

Hi everyone, I would like to ask a question about MySQL. Say, I have a database like this: database 1: articles |- id |- title |- description database 2: tags |- id |- articleID |- tag I needed to search from articles.description and tags.tag and while doing so, the searched …

Member Avatar for anjerodesu
0
316
Member Avatar for Biiim

Hi thought i'd try here see if anyone can help solve this quicker. First off we have a email database. The main table is the email data, all unique rows per email address with a unique id. eg. emailid,email 1,email@example.com 2,email@example.co.uk Next we have another table which logs the data …

Member Avatar for smantscheff
0
285
Member Avatar for borchu

Hi, my question is simply but a little bit tricky; let assume that there are two array array1 = (2, 5, 6, 1, 7) and array2 (3, 2, 6, 8) and after function setUnion new array or use pointer return (2, 5, 6, 1, 7, 3, 8). Below my code …

Member Avatar for mazzica1
0
560
Member Avatar for Labdabeta

Is it possible to define a union at creation. ie: [CODE]union Colour { unsigned int i; char c[4]; struct{ char a; char r; char g; char b; }col; }Black(0xFF000000),White(0xFFFFFFFF),Red(0xFFFF0000),Green(0xFF00FF00),Blue(0xFF0000FF)/*etc...*/;[/CODE]

Member Avatar for Labdabeta
0
122
Member Avatar for Sandhya212

Hi, I need to find the 'length' of union between 2 vectors. The code I have is[CODE] vector<int> v1,v2; vector<int> unionsetv; vector<int>::iterator it; v1.push_back(1);v1.push_back(2);v1.push_back(3); v2.push_back(3);v2.push_back(2);v2.push_back(4); it = set_union(v1.begin(),v1.end(),v2.begin(),v2.end(),back_inserter(unionsetv)); cout << unionsetv.size()<< " "; cout << int(it - unionsetv.begin())<< " " ; [/CODE] I could not get this to work and …

Member Avatar for Sandhya212
0
226
Member Avatar for manish250

hello all i am using a query [ICODE]select 'hour','filename','tot_sent_count','tot_success','tot_prm_fail','tot_switchedoff','tot_other_error' UNION select hour,filename,sum(tot_sent_count),sum(tot_success),sum(tot_prm_fail),sum(tot_switchedoff),sum(tot_other_error) INTO OUTFILE '/tmp/hourlyFileMis(2011-03-09)' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n' from tbl_mis where date_format(date_time,'%Y-%m-%d')='2011-03-09' group by hour,filename order by hour;[/ICODE] output is ok but one thing is not coming properly that header fields are coming at the …

Member Avatar for smantscheff
0
183
Member Avatar for mbhanley

Hi * I have spent the last 18 hrs or so trying to get the wright sql code or think of an alternative but I just can't get my head around it. If any one can help me it would be awsome. What I am trying to acheive is getting …

Member Avatar for hielo
0
214
Member Avatar for P00dle

I'm making some sort of mistake in the following code: [CODE]use xPress_CR select * from (SELECT * FROM dbo.T_JOBS WHERE ENDDATEANDTIME = null UNION SELECT * FROM dbo.T_JOBS WHERE STATUS = 'Failed')[/CODE] Any idea what I'm doing wrong?

Member Avatar for P00dle
0
105
Member Avatar for Charls Frdinand

Hello everyone! This is my first post, been a long time reader though. First of all, it's been a while since I don't program and I'm rusty (very). The problem is: I just can't learn how to use the JOIN or UNION commands, everything I read is confusing. I'm simply …

Member Avatar for Charls Frdinand
0
235

The End.