Subversion Repositories SmartDukaan

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