Hello, I want to write an update query for the following : Table A : Field ARTID QTY Table B Field InventID, ArtID, QTYProgram, QtyStock I want...
Hello, I have a question regarding the following : I have a table StockCor : which maintains stock corrections by the user. ID ARTID QTY ID...
Hello, I have a question how to build the following query Table StockMov Type trans : 1 : Purchase 2 : Sale 3 : Transfer out 4: Transfer in ArtID...
Hello, I want to write an update query for using articles in an inventory module. Invent_header ID STOREID Invent_art table ARTID INVHEADID...
Hello, I need to write a report in VB which gives me the following result Customer Store Brussels Store London Store Paris Smith...
Hello, 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...
Hello, 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 Customer Table Field...
Hello, 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...
Hello, How can I write a query which returns the number of records where a code is identical Fe Code Number 1001 2 1002 1 1003 2...
Hello, I would like to know how I join 3 tables Table A -> Table B -> Table C Where table A : Sale Headers B : Sale details...
Hello, 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...
Hello, 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 :...
Hello, 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...
Hello, 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 0001...
Does anyone know how to sort a stand alone recordset. thanks Ralph
Select ItemExts.ItemExtNumber, ItemExts.ColRoot, ItemExts.WSRoot, ItemExts.ItemExtCode,...
A question We have an article table and a price table The price table contains 5 sale prices (for different purpose) for each article. The...
Hello, 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. In...
Separate names with a comma.
