Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
2
Reply
Item Avg Unit Price numeric(18,4)
basit khan
Dec 6 2016 11:17 AM
246
Reply
Hi,
I have Item Master the fields are
Itm_No numeric(18, 0)
Itm_Code nvarchar(50)
Itm_Desc nvarchar(500)
Itm_UnitPrice numeric(18, 4)
the data's are
1
00001111
HP Laptop
14.3310
2
00001112
Dell Laptop
14.3541
3
00001113
samsung
14.1000
what i want only take the exact decimal place.
1
00001111
HP Laptop
14.331
2
00001112
Dell Laptop
14.3541
3
00001113
samsung
14.1
Thanks
Basit.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
no of Dates Between two dates
The current transaction cannot be committed in SQL