Search results for query: *

Hi, Suppose I have the following query SELECT sum(some_value) from some_table s where s.date in (date1,date2,date3) Suppose I want to make it contingent on some other table and basically do the following SELECT sum(some_value) from some_table s where s.date in ( select distinct(date) from...

Hi, I have a file with a million lines in the following format. field1=val1 field2="val2" field3="" It is basically a list of key/values pairs separated by a space. Where a value is NOT encased in quotes, it will have only alphanumerics or a dot or a minus sign. Where it IS encased in...

Hi, Suppose I have 2 tables. One is called "detail" date DATE account_id int stock varchar(10) trades int pnl int PRIMARY KEY (date,account_id,stock) This table is useful for research, however I expect that 95% of the queries will be grouping by date and account_id. Since there are...

Hi, I have 2 tables. One table is called "data". It's defined as follows date DATE NOT NULL total int NOT NULL It is indexed by date and has, say, 300K records per date, and a total of 45M records with a range of dates from, say ,20090101 to 20110401 second table is called "rate" and is...

I have the following query: mysql> desc tradesTable; +--------------+-------------+------+-----+-------------------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+-------------------+-------+ | date | date...

Here are the details. 1) Here are 2 tables mysql> show create table globalPnL; | globalPnL | CREATE TABLE `globalPnL` ( `date` date NOT NULL, `symbol` varchar(32) NOT NULL, `account_id` int(16) NOT NULL, `currency` varchar(8) NOT NULL default 'usd', `pnl` float(13,4) NOT NULL...

Suppose I have a table consisting of 10 fields. f1,f2,...,f10 f1 is not the primary key, and hence has repetitions suppose I have the following set of data AAA,1,2,... BBB,3,4,.... AAA,5,9,... CCC,4,1,... BBB,3,7,... I need to return any ENTIRE row for a distinct value of f1. So ideally...

Suppose I have a table consisting of 10 fields. f1,f2,...,f10 f1 is not the primary key, and hence has repetitions suppose I have the following set of data AAA,1,2,... BBB,3,4,.... AAA,5,9,... CCC,4,1,... BBB,3,7,... I need to return any ENTIRE row for a distinct value of f1. So...

Greetings! I have the following problem. A program I run generated a data file. That data file is very large. It gets gzipped on the fly. Gzipped it could be several gigabytes large. If the data file is completed, it has the word DONE as the last line. This is variable - I can print out...

Well, this would really be for the gnuplot forum, except there isn't one. It's rather simple. When I pass gnuplot() function the data array, it consists of [$DATE,$data] points. I have missing dates in my dataset, and I want it that way, but the silly thing still puts them on the x-axis. How...

Greetings, I have several perl modules which rely on certain environment variables. Those variables can be set with one of the following scripts . /source/production_sys.sh . /source/dev_sys.sh . /source/another_sys.sh It is undesirable to manually set environment variables - one must...

Greetings, I have a flash widget that I wish to have on different websites. A very simple question: If I have/get, say, Iframe code from somewhere else (dynamically acquired), can I somehow render it within my widget? I know that using javascript I can manipulate the IFRAME in which the...

Greetings, I have a an ads data table which has, say, 7 columns: Date,AdvertiserID,AdID,PublisherID,PublisherSiteID,Impressions,Clicks "Date" field contains just the Date part (time is zeroed out) Primary key is composite, consisting of first 5 columns...

I have dataset which calls a stored procedure, which returns, say DATE (a date),NAME (a string),SALES (an integer) I want to graph this as a simple line graph such that DATE is on X-axis, NAME is a series, and SALES is the data (on Y-axis). So I have as many lines as there are NAMEs, showing...

Greetings, Simple question...There are a number of controls to select from the Toolbox when building a report in the Intelligence studio (rectangle, table,matrix...), but I do not see "checkbox", which would be useful in a number of instances. Are there ways to extend the toolbox? Can I...

Greetings, I have a report that I produce with columns Date, A, B, C, D, Total, Revenue I have 3 user - inputed parameters start_time, end_time, groupBy start_time and date_time are used in the query. GroupBy I intend to use to perform a conditional grouping. It is a multivalue field...

Greetings, I have the following code: using System; using System.Collections.Generic; using System.Text; class Class1 { static void Main() { dataContainer cont = new dataContainer(1,1); Console.WriteLine("set COUNT: {0}, PRICE: {1}",cont.getCount(),cont.getPrice())...

greetings everyone, I have to connect to an https site, log in, browse to a particular page, input field selections, and extract certain information from it. I wish to automate this process. I am, however, running into a problem. Here is what I have so far #!/usr/bin/perl use strict; use...

Hi guys, I've been having a problem with a perl script that segfaults for a while now. I think I have a clue now however as to where or why it may be happening, but I need to debug it. It is a threaded script. Perl version 5.8.3. I get the following error right after every thread...

greetings, Something rather strange is happening here...Since server reboot, all the sudden, the following sniplet of code... insert into MY_TABLE (MID,PARTNER) values('123','PTR2') ON DUPLICATE KEY UPDATE PARTNER = VALUES(PARTNER); is generating the following error ERROR 1062 (23000)...