SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 MS Access To Store Procedure (INT)
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Amini
Starting Member

India
6 Posts

Posted - 04/03/2009 :  00:31:21  Show Profile  Reply with Quote
Round([NPay]-INT([NPay]),2) AS ExtractPaisa
NPay = 3513.45 result = 0.45
This is simple formula in MS Access qery. I am converting this in to store procedure in Server 2005. Messege comming "INT is not recogenized build-in function name". what is the replacemnet of INT in store procedure.

Edited by - Amini on 04/03/2009 00:33:15

ayamas
Aged Yak Warrior

552 Posts

Posted - 04/03/2009 :  01:42:20  Show Profile  Visit ayamas's Homepage  Reply with Quote
You need to use Convert function
Round([NPay]-Convert(INT,[NPay]),2) AS ExtractPaisa
Go to Top of Page

Amini
Starting Member

India
6 Posts

Posted - 04/03/2009 :  02:36:20  Show Profile  Reply with Quote
Thanks
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000