Search results for query: *

I need to create some global variables accesible from an exe and some activex dll. I found a solution by creating a class in the main program , register it in ROT(running object table) and after that in each dll I can get the instance of that class and use all his proprierties/methods. The only...

Hi, I must design a Sql Server 7.0 database for a heavy loaded website. This database will receive 50k+ inserts/day and 10-20k+ selects. All selects are time dependant. Initially the column had datetime type. For speed reasons I created another column (integer type). This column store the...

Hi, First of all I must to mention that the database will receive 40000 inserts/day and probably 10000+ requests. I have a table with many fields(20), most all of them are integer. Three of them are varchar(100). My question is how to design the table/tables to obtain maximum performance on...

Hi, I have a strange problem with calculating some amounts Ex. create table Contracts(contract_id int,contract_description varchar(15)) create table Quittances(quitt_contract_id int, quitt_amount decimal(12,2)) create table Others(oth_contract_id int, oth_amount decimal(12,2)) insert into...

Hi, Does anyone have an example(or URL) for finding all the serial ports connected and their status(if they are in use or not) ? Thanks, Catalin.

Hi, Has anyone a construction for dropping all indexes from a database? Thanks.

Hi, Which is the quickest way to select distinct only for a number of fields. For example I have: select f1,f2,f3,... from tbl I wont a kind of(only for ideea, syntax incorrect): select (distinct f1,f2) f3,f4,.... from tbl Ex: f1 f2 f3 f4 1 1 2 5 1 2 1 2 2 1 2 3 2 1...

Hi, I have a table with the following columns: product_id int, category varchar(30), ammount money, cnt int What I need is to have for each product the record that have ammount max for it. If exists many records with the the same ammount = max(ammount) for that product then we look...