How in SQL could you "zip" together records in separate tables (à la the UNIX paste(1) utility)? For example, assuming two tables, A and B, like so: A B ======== ==== Harkness unu Costello du Sato tri Harper Jones How could you produce a single result set NAME | NUM =============== Harkness | unu Cost...
Hi everyone... Consider i have 4 workbooks with the following structure... 1. Main.xlsx Name Jan Feb Mar A B C 2. Jan.xlsx Name Jan A 3.3 B 6.4 C 5.3 3. Feb.xlsx Name Feb A 1.3 B 3.4 C 5.5 4. Mar.xls...
I want to combine multiple lists of items into a single list, retaining the overall order requirements. i.e.: 1: A C E 2: D E 3: B A D result: B A C D E above, starting with list 1, we have ACE, we then know that D must come before E, and from list 3, we know that B must come before A, and D must come after B and A. If there are con...
I have these 2 scripts and the problem is that function check is called only if #hotel state is changed. How can I make function check run and in the case of #hotel doesn't change. var hotelMap = { hotel_a: 15, hotel_b: 5, hotel_c: 10 }; //Edw mporeis na allazeis to release period gia kathe ksenodoxeio $(function() { $('#hotel').cha...
I want to combine two relative paths in C#. For example: string path1 = "/System/Configuration/Panels/Alpha"; string path2 = "Panels/Alpha/Data"; I want to return string result = "/System/Configuration/Panels/Alpha/Data"; I can implement this by splitting the second array and compare it in a for loop but I was wondering if there i...
I have two png image files that I would like my android app to combine programmatically into one png image file and am wondering if it is possible to do so? if so, what I would like to do is just overlay them on each other to create one file. the idea behind this is that I have a handful of png files, some with a portion of the image o...
I am writing a foxpro sql & need to combine three date columns from three different tables into a new date column. As an example if the three tables are A,B,& C and the date Columns are Adate, Bdate and Cdate, how do I combine them as distinct and separate dates into a column called TransDate and in the SQL? I would appreciate samples of...
Hi All, Imagine a have a very long enunumeration, too big to reasonably convert to a list. Imagine also that I want to remove duplicates from the list. Lastly imagine that I know that only a small subset of the initial enumeration could possibly contain duplicates. The last point makes the problem practical. Basically I want to filter ...
What I want to do is something like this: searchid = 4 while searchid != -1 @a += A.find(searchid) @b = B.find(searchid) searchid = @b.parentid end The problem being the line @a += A.find(searchid) The error being something like NoMethodError: undefined method `+' for #<A:0x173f9a0> So, how do you combine multiple 'find...
Hello, I'm looking for a library which could rank/unrank ordered combinations (ranking means from a combination it give you which nth combinations it is from a gray code or lexicographic or some other algorithm, unranking is the reversing process). I look for a library doing many algorithmes like gray code or lexicographic, rev-lexico...
Hey everyone. I'm new to excel and VBA and I'm stuck at this problem. I have multiple lists that are in separate columns in excel. What I need to do is combine these columns of data into one big column. I do not care if there are duplicate entries, however I want it to skip row 1 of each column. ROW1| 1 2 3 ROW2| A D G ROW3|...
Can any one suggest simple code snippet for combining account and profile tabs in drupal 6. i'm using onepageprofile module it works fine but any other simple solution ? ...
I am using Access and have this SQL SELECT land.id, land.official_name, vaksiner.vaksiner FROM land INNER JOIN (vaksiner INNER JOIN land_sykdom ON vaksiner.id = land_sykdom.sykdom) ON land.kort = land_sykdom.land ORDER BY land.official_name The SQL gives me a result like this: id official_name vaksiner 1 a ...
From your experience, what's the most flexible minimizer/compressor (JS+CSS) for ASP.NET MVC you've dealt with? So far mbcompress doesn't seem to be too MVC friendly weboptimizer.codeplex.com lacks documentation clientdependency.codeplex.com is still in beta compress2 seems like a good candidate, but haven't tried it yet mvcscriptmana...
How to combine two data columns into one file. These code should produce a new file which have 2 column. Although it produce 2 column but, the data isn't right where all the data of a were written first followed by data duration fid=fopen('data1.txt'); A =textscan(fid,'%f%f%f%f%f%f%f%f%f%f%f%f'); % read a txt file in = cell2mat(A); %ch...
dt1 dt2 dt3 dt 1 3 6 10 2 4 1 5 3 6 5 3 4 7 4 1 5 1 2 4 6 2 8 7 8 8 9 10 I have the above data which I want to combine in one single matrix (10 x 4). The maximum number of row is 10. I created zeros matrix, however I have problem since the data doesn't have the same dimension. How it is poss...
student1 student2 student3 code score code score code score 1 20 1 100 1 22 2 11 3 11 2 90 3 12 4 22 5 11 4 11 5 28 This question is related to http://stackoverflow.com/questions/3174631/matlab-how-to-combine-uneven-matric-into-single-matrix but a li...
I created a .a lib file and it was built under iPhone OS 3.0 (in XCode 3.2.2). Now I found that it doesn't work on OS 4. I was using the lipo command to build the .a file for both simulator version and device version: lipo -create libdevice.a libsimulator.a -output libcombined.a Now I created another .a file under iPhone OS 4.0 (in XC...
How do I create an icon file that contains multiple sizes? I know that I create a icon from a bitmap using Icon.FromHandle() but how do I add another image / size to that icon? Edit: I need to do this in my application, so I cannot execute an external application to do the combining. ...
hi, i want to combine text and image on the fly to create a jpg widget. I want to do this for a fundraising website, i will need to update the image once a day so it reflect the updated fundraising progress bar. The reason why i want a jpg (image) widget is because it is much more friendly to add to blogs, website etc. ...