I want to write an update query for the following :
Table A :
Field ARTID QTY
Field InventID, ArtID, QTYProgram, QtyStock
I have a question regarding the following :
I have a table StockCor : which maintains stock corrections by the user.
ID ARTID QTY
I have a question how to build the following query
Type trans :
1 : Purchase
2 : Sale
3 : Transfer out
4: Transfer in
I want to write an update query for using articles in an inventory module.
I need to write a report in VB which gives me the following result
Customer Store Brussels Store London Store Paris
I need to write a SQL statement which does the following:
Depending on the type of transaction either go to the Supplier table or the...
I have an application in vb.
The problem that I have is, when I execute a couple sql command in a transaction
where by incident I have the...
I want to write an update to a database from DB 1 to DB 2
Where DB1 is located on another server
fe DB1 server 1
I've a question regarding an UPDATE command
I have a table A with an average net price and an average brut price
I want to update these...
How can I write a query which returns the number of records where a code is identical
I would like to know how I join 3 tables
Table A -> Table B
-> Table C
Where table A : Sale Headers
B : Sale details...
We want to have a table with several counters in it.
These counters will be used for invoicing, ordering numbers, etc....
But what we want...
We want to connect a SQL DB (SQL 2000) from remote (internet).
What are the steps to be taken to do this?
When I try this I get the error :...
I have a question regarding insert queries
We have in our DB fe 1000 articles
Half of them don't have a supplier. We want to add a default...
We are developing a report generator for our application, where the user can select fields, put filters on and sorts.
What I now encounter...
We are developing a report generator.
The user wants to create the following list
Artcode ArtDescription Sales 01/06 Sales 02/06
Does anyone know how to sort a stand alone recordset.
Select ItemExts.ItemExtNumber, ItemExts.ColRoot, ItemExts.WSRoot, ItemExts.ItemExtCode,...
We have an article table and a price table
The price table contains 5 sale prices (for different purpose) for each article.
We developped a POS application where in the reporting the user wants to see a list with for all the articles the sales grouped by month.
Separate names with a comma.