select * from dbo.AcCSD


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AcCsD]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
	Truncate Table AcCsD
	print 'AcCsD Transactions Deleted'


_____________________________________________________________________________________


select * from dbo.AcCSM




if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AcCsM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
	Truncate Table AcCsM
	print 'AcCsM Transactions Deleted'





_____________________________________________________________________________

select * from dbo.AcCshInOut



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AcCshinout]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
	Truncate Table AcCshinout
	print 'AcCshinout Transactions Deleted'


_______________________________________________________________________________

select * from dbo.AcCshCnt


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AcCshCnt]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
	Truncate Table AcCshinout
	print 'AcCshCnt Transactions Deleted'

_____________________________________________________________________________


select * from dbo.AcTrx



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AcTrx]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
	Truncate Table AcTrx
	print 'AcTrx Transactions Deleted'


_____________________________________________________________________________

select * from dbo.AcCshCnt



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AcCshCnt]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
	Truncate Table AcCshCnt
	print 'AcCshCnt Transactions Deleted'

_____________________________________________________________

select * from dbo.AcCStt



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AcCStt]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
	Truncate Table AcCStt
	print 'AcCStt Transactions Deleted'

______________________________________________________________

select * from dbo.AcStkCrd



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AcStkCrd]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
	Truncate Table AcStkCrd
	print 'AcStkCrd Transactions Deleted'


___________________________________________________________


select * from dbo.AcStkBal where BalanceQty<='1'


Update AcStkBal set BalanceQty='0'





_____________________________________________________________________________


select * from dbo.AcStk where BalanceQty<='1'


Update AcStk set BalanceQty='0'


_____________________________________________________________________________

_____________________________________________________________________________

_____________________________________________________________________________

_____________________________________________________________________________