Search results for query: *

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

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

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

Is there any way to encrypt patch scripts that go between maintenance releases?

I have seen a query which looks like: SELECT * FROM Table1 WHERE 1 = 1 AND <other criteria> Why is 1 = 1 used?

Does anybody know of a good link to information on ER Modeling on the web?

Hi, I want to design indexes for an existing table. There are a lot of modifying as well as querying against the table. Can anybody suggest what strategy I adopt when it comes to creating the new indexes?