I want to write an update query for the following :
Table A :
Field ARTID QTY
Field InventID, ArtID, QTYProgram, QtyStock
Sorry I meant that this field is not an identity field
I have a question regarding the following :
I have a table StockCor : which maintains stock corrections by the user.
ID ARTID QTY
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....
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 forgot to mention : how can we do that from Visual Basic?
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
Thanks for all the help
This topic can be closed.
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
Thanks for the prompt reply.
I explain how the joining is.
Table A = TransactionHeaders
PK = HeaderNumber,
I would like to know how I join 3 tables
Table A -> Table B
-> Table C
Where table A : Sale Headers
B : Sale details...
So the followiong
strSQL as string
'execute read with hold lock option
'execute update command
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?
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.