Subversion Repositories SmartDukaan

Rev

Blame | Last modification | View Log | RSS feed 

url=jdbc:sqlserver://
server_name=localhost
port_number=1433
database_name=etpstorev5
user_name=rajveer
password=shop2020
query=SELECT items.ProductGroup, items.Brand, items.Model, items.Color, txn.TransactionQuantity, txn.CreateDate, txn.CreateTime, txn.DayId FROM StockLedgerTrn txn, ddata items WHERE ((txn.CreateDate = ? AND txn.DayId > ?) OR (txn.CreateDate > ?)) AND txn.Company = 100 AND txn.Division = '200' AND txn.Warehouse = '901' AND txn.Location = 'SLS' AND txn.ItemNumber = items.ItemNumber AND item.Brand='Spice' AND item.Model='M9000' Order by txn.CreateDate, txn.DayId