MS Access To Store Procedure (INT)

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

MS Access To Store Procedure (INT)

Author

Topic

Amini
Starting Member

6 Posts

Posted - 2009-04-03 : 00:31:21

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.

ayamas
Aged Yak Warrior

552 Posts

Posted - 2009-04-03 : 01:42:20

You need to use Convert function
Round([NPay]-Convert(INT,[NPay]),2) AS ExtractPaisa

Amini
Starting Member

6 Posts

Posted - 2009-04-03 : 02:36:20

Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources