I have a db in which each record consists of over 200 fields. These fields are populated throughout the day by users in two different locations. I need to find away for this to be done so th...
Can somebody please provide a sample code on how will I join 5-8 tables.
Thanks.
good morning,
I have a client that uses a medical billing application storing data to Pervasive SQL version 9. They bill for several customers, therefore they have several databases on the ...
I have a table that contains Sales by week and region as such.
Week1 Region1 10
Week2 Region1 10
Week3 Region1 10
Week1 Region2 10
Week2 Region2 10
Week3 Region2 10
I would li...
We need a contact management software at our office.
We have around 50 customers (and growing) which all should get, welcoming letters, information letters, gifts, offers, and so on.
We ...
Hi,
I am currently receiving an 'ActiveX component can't create object' error message when loggin into our web based reporting tool which is part of application. We have an Oracle 9i databa...
I try to setup WMI alert for BROKER_QUEUE_DISABLED
and I use following WSQL - SELECT * FROM BROKER_QUEUE_DISABLED
but receive error:@wmi query cannot be executed in @wmi namespace
...
We are trying to find out for all users/Logins oin a particular server what databases they have access to and the level of access
so the result would be:
User: Database: LevelofAcess(or...
I am trying to do the bulk insert with a format file and getting the following error:
Cannot perform bulk insert. Invalid collation name for source column 2 in format file 'C:\MLFPformat_mod....
Imagine you have a database that can only do 2,000 queries a second. Your web application gets 5,000 queries a second, what can you do to improve the situation? Like: Imagine its a stock quote...
hello experts. how do businesses normally design their schema for something like booking of tickets?
should one ticket be a record or should each ticket has a column with avaliable tickets an...
Hi,
My company do websites and I am required to create an efficient database for their search engine.
The search engine will only be for the websites we create, so we don't need a crawler,...
My office uses GBS software with Access as the backend. GBS Tech support told me that I need to update to Sequel express because the database has grown to big for access. I don't know what "...
I've made 3 attempts to extract data from this database and have been unsuccessful. This customer has no support agreement with Raining Data so I'm in a tough spot.
1. My best shot appears...
I have database that is involved in merge replication. There are two tables
involved in the replication.Customer requirement is to do a bulk insert on
the table involved in the replication....
