text to lcSql textmerge noshow pretext 3 select ri.*, rt.Descrip AS type_descrip, rt.maxdays, rt.maxrents, rt.shortdesc, rt.showinfo, rt.SigRequire from r_invent ri inner join r_types rt on ri.rentaltype = rt.typeid where ri.equip_tag = ?pnEquiptag ENDTEXTThe equip_tag column is defined as decimal(17,0) in SQL Server. In SQL Trace I see the following query being executed:
exec sp_executesql N'select form_no from r_header where rental_no = @P1 ',N'@P1 float',719646112000(for a similar query).
where ri.equip_tag = CAST(?pnEquiptag as decimal(17,0))Thanks in advance.