HI frank,

Are u saying that he best solution is to change the datatype to decimal to get high precision.

HI

RetailPrice is money and SalesQuantity is float.

I have done wht you said, that is i cast it as money and things works well. However two doubts.

1.When I multiply Retailprice...

Thanks a lot. It works when I reversed set nocount on/off in the above example.

You saved lot of my time and i learned one more thing today

Regards

mani

Hi Conwaydean,

I tried set nocount off/on option as well. Still problem persists. For better understanding I will list actual stored Procedure here.

--------------------------------------

begin

SET NOCOUNT OFF

declare @TempTable table

(CompanyId varchar(3),DeptCode varchar(3),DocketNo integer,TransactionType...

Hi Andy,

There is no problem with permission or anything of that sort. Because if i change the stored procedure to just select * from department, then it works,...

yeah, we need facility to move a posting from one category to another

Thanks for it.

I wrongly posted it in different section, so i reposted.

hi abhi_develops,

I mean something like this, it obviously is not an efficient way. Just another method

ex:

SELECT CONVERT(varchar, dateEntered, 103)

FROM dbo.tblDirectory

WHERE CONVERT(varchar, dateEntered, 103) LIKE '09/07/2002%'

Why was "dtColumn like dt +'%' " not mentioned as one of the ways seraching for dates in s datetime column with inconsistent storage like storing date and time.

...