Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Stock Card inventory

Author  Topic 

Muhtar
Starting Member

2 Posts

Posted - 2008-12-03 : 01:35:22
hi,
I'm new in SQL Server(SQL 2005). please help me, i want to make stock card in my ritel inventory for each category of item and date, i have 3 store and need stock card for each store.
my table is :

goodsCode
-------------
id
goodsCode
GoodsName
price



Stock
----------
stockDate
storeId
GoodsCode
StockPrice
FirstSaldoStock
EndSaldoStock
Total


Purchase
---------
purchaseDate
storeId
GoodsCode
Price
quantity
total


Sales
---------
SalesDate
storeId
GoodsCode
Price
quantity
total


Store
-------------
id
StoreId
StoreName

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-03 : 01:39:15
please post info in following format and illustrate what you want

http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
Go to Top of Page
   

- Advertisement -