combine

paste(1) in SQL

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...

MS Excel - Macros for consolidating values from multiple sheets into a single sheet

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...

Algorithm - combine multiple lists, resulting in unique list and retaining order

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...

Combining 2 jquery scripts to work together

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...

Is there an easy method to combine two relative paths in C# ?

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...

combining two png files in android

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...

How do I combine 3 date columns from 3 tables in Foxpro sql?

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...

Filtering subsets using Linq

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 ...

Rails: combining multiple find requests

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...

Libraries C/C++ for ordered combinations generation and ranking/unranking ?

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...

Excel - Combine multiple columns into one column

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|...

drupal combine account and profile

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 ? ...

SQL, combining the result

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 ...

Most flexible minimizer/compressor for ASP.NET MVC 2?

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...

MATLAB combine data

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...

MATLAB how to combine uneven matric into single matrix

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...

Matlab combine matrix

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...

How to build a static library for both iPhone OS 3 and OS 4?

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 to create an Icon file that contains Multiple Sizes / Images in C#

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. ...

How to combine image and text on the fly in php

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. ...