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...
Sorry I meant that this field is not an identity field
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, Thanks for the reply. What I meant with the second question is the following : This whole thing is to use it in an inventory for articles....
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...
I forgot to mention : how can we do that from Visual Basic? Ralph
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...
Thanks for all the help This topic can be closed.
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 back, Thanks for the prompt reply. I explain how the joining is. Table A = TransactionHeaders PK = HeaderNumber, CoLRoot,...
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, So the followiong strSQL as string con.begintrans 'execute read with hold lock option 'execute update command con.committrans
Hello We haven't used stored procedures before. And have no plans to use it in the future. So I think we'll need to program in VB
Do you have to do this in SQL Server Stor Proc? Or can you call this from VB? Thanks
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...
Separate names with a comma.
