Login or Sign Up to become a member!
LessThanDot Site Logo

LessThanDot

A Technical Community for IT Professionals

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

LTD Social Sitings

Lessthandot twitter Lessthandot Linkedin Lessthandot facebook Lessthandot rss

Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.

Highly Rated Users

Forum
No Posts Rated

Top 50
Given
Received

Forum Statistics

Users
Members:
1873
Members Online:
0
Guests Online:
115

Total Post History
Posts:
81445
Topics:
18714

7-Day Post History
New Posts:
0
New Topics:
0
Active Topics:
0

Our newest member
BitogClogs

Other

FAQ
All times are UTC [ DST ]

Google Ads

SQLCOP Decimal Size Problems

Please wait...

SQLCOP Decimal Size Problems

Postby dpinalopez68 on Mon Apr 08, 2013 10:02 am

Hi, I have a simple view like this:

select a,b,convert(decimal(10,2),c) from tabla

c is a float,

SQLCOP raise a warning in decimal size Problem, I have changed the third field for a expresion like FLOOR(c) and it keeps me warning,..

Why?.

Thanks in advance
dpinalopez68
Newbie
Newbie
 
Posts: 1
Joined: Mon Apr 08, 2013 9:56 am
Unrated

Re: SQLCOP Decimal Size Problems

Postby gmmastros on Mon Apr 08, 2013 11:34 am

I would need to see all of the code to figure this out.

Also... do you have the word "decimal" somewhere in the name of the view? This could be causing the false positive.
-George
User avatar
gmmastros
LTD Admin
LTD Admin
LTD Gold - Rating: 1630LTD Gold - Rating: 1630LTD Gold - Rating: 1630LTD Gold - Rating: 1630LTD Gold - Rating: 1630
LTD Gold - Rating: 1630LTD Gold - Rating: 1630LTD Gold - Rating: 1630LTD Gold - Rating: 1630LTD Gold - Rating: 1630
LTD Gold - Rating: 1630LTD Gold - Rating: 1630
 
Posts: 2367
Joined: Tue Oct 09, 2007 5:19 pm
Unrated