Hi,
I have a query where i am not been able to find out errors.
SELECT
dbo.SalePurchase.tran_date AS billdate
,LEFT(dbo.SalePurchase.tran_no, 1) + RIGHT(dbo.SalePurchase.tran_no, 8) AS BILLNO
,dbo.GL.AcName, Item_1.ItemName
,dbo.IT.iRate
,dbo.IT.iAmount AS amt
,Item_1.UOM
,dbo.IT.iQty
,dbo.SalePurchase.sp_dr
,AddressBook_1.FullName
,dbo.SalePurchase.sp_cr AS bamt
,GenMast_1.GenName AS itemgroup
,dbo.Item.ItemName AS subitem
,dbo.AddressBook.FullName AS tagidar
,GenMast_2.GenName AS city
,dbo.GenMast.GenName AS district
,salepurchase.sp_cr-salepurchase.sp_basic as tamt
FROM
dbo.AddressBook
RIGHT OUTER JOIN dbo.GenMast AS GenMast_2
INNER JOIN dbo.GenMast ON GenMast_2.GroupCd = dbo.GenMast.Code
RIGHT OUTER JOIN dbo.GL ON GenMast_2.Code = dbo.GL.CityCd ON dbo.AddressBook.Code = dbo.GL.TagadgirCd
RIGHT OUTER JOIN dbo.SalePurchase ON dbo.GL.AcCode = dbo.SalePurchase.ac_code
LEFT OUTER JOIN dbo.AddressBook AS AddressBook_1 ON dbo.GL.BrokerCd = AddressBook_1.Code
LEFT OUTER JOIN dbo.Item
RIGHT OUTER JOIN dbo.IT ON dbo.Item.Code = dbo.IT.SubItemCd ON dbo.SalePurchase.Code = dbo.IT.SPCode
LEFT OUTER JOIN dbo.Item AS Item_1
LEFT OUTER JOIN dbo.GenMast AS GenMast_1 ON Item_1.GroupCd = GenMast_1.Code ON dbo.IT.ItemCode = Item_1.Code
WHERE (salepurchase.sp_type='sr')
ORDER BY LEFT(dbo.SalePurchase.tran_no, 1) + RIGHT(dbo.SalePurchase.tran_no, 8)
n execution showing "
unable to convert char to datetime
". Although the data type for
trandate
is set to
DateTime
. The error remains.
Please help..