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.
| Author |
Topic |
|
Muhtar
Starting Member
2 Posts |
 Posted - 2008-12-02 : 22:58:23
|
| hi,I'm new in SQL Server(SQL 2005). 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 TotalPurchase --------- purchaseDate storeId GoodsCode Price quantity total Sales--------- SalesDatestoreIdGoodsCodePricequantity total Store-------------idStoreIdStoreName |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-03 : 00:18:31
|
| what have you tried till now? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-03 : 00:19:08
|
| Also you should be posting this Transact SQL forums in future. |
|
|
|
|
|
|
Stock Card inventory