Recent content by gussifinknottle

Thanks Ian.

Hello, I would like to retrieve all of the data from table1 wherein two of the columns match two columns in table2. I have done a select * from table1 where col1 in (select col1 from table2) and col2 in (select col2 from table2) I am not getting the right number though? What do I need to...

KevinADC I have posted about 10 times in the last decade. What basis are you using to make your comments? I do have a life outside of the cyber world and make a trip to the forums on a need only basis. And when I get a reply for my queries, I have thanked the contributor for the same...

Also, by sliding windows, I mean getting data in non-overlapping contiguous windows. This would mean, data for 1-1000, 1001-2000, 2001-3000 and so on. Thanks, Anamika

Yes there is a possibility that the last window will not have 1000 (or the window size) elements. In this case, I normalize it for the number of elements in the window. So, if there are 784 elements and the sum S = 9000, then I get the data for the last window as (S/9000)*1000. Anamika

I have a table that has 3 columns Scaffold Position Pileup -------- -------- ------ 1 1 20 1 2 30 1 3 40 1 … 1 n 40 2 1 11 2 2 14 2 3 16 2 … 2 m 4 3 1 2 3 2 56 3 3 4 3 … 3 p 91 For every scaffold, I would like to be able to get a sum of the Pileup for a sliding window. The...

Hi Chris, When I ran this with a test case, it ran fine and give me the output I was looking for. However, when I changed the \d to a regular expression, ([0-9]*), to include search for numbers that may go from 1 to abut 100k, I don't see any output. Thanks, Gus

Hello, I have two files that have delimited entries as shown below. I would like to use either Perl script to extract all the rows in File 1 corresponding to values in File 2 and output it to another File. File 1 ------- 1 36 24 Object1 2 45 36 Object2 3 96 21 Object3 4 89 32 Object4 5 98 23...

[b] When I run the following stored procedure I get the error message displayed below. What am I doing wrong? [B] [COLOR=BLACK]MY STORED PROCEDURE IS : [B] [COLOR=BLUE]GetAssetTaxCal 3 , '1035' , 49 , 1 , '15 Oct 1996' , '15 Feb 2001' , 0 , 0 [B] [COLOR=BLACK] Output...

I don't want the header in my output when I do a Select Query. Is there any way I can programmatically change this, other than doing either of the following: *SELECT <col_name> AS ' ' OR Unchecking the Print Options in the Connection Options of the Query Analyzer. I am looking for something...

I have got a table from which I have obtained average values, based on 'GROUP BY' clause. I need to get the max of these average values and display them. Is there any way I can do an aggregate of an aggregate, like max of an avg in the same Query?

I have a table which has got a clustered index. When I move it from version 6.5 to 7.0, I am unable to see the physical ordering of data, based on the field on which I have the Index, when I do a Simple select. Why is this happening?

When I am running a query that drops tables, I get the following message. Could not find table table_customer. Will try to resolve this table name later. How can I avoid this?

I have a script that drops a number of tables (after searching the system tables for their existence). Depending on a select criteria (e.g. for a particular client, whose nameis specified), I may recreate and populate the above dropped tables. IF (SELECT client_name = 'abc') BEGIN CREATE...

To expand on the last thread I posted. I send out Patch Scripts that have fixes between Maintenance releases. But I don't want the customers seeing what I have in the patch. If it is a normal stored procedure, I use 'WITH ENCRYPTION' option. I would like to use something similar. (Sort of...