Click here to Skip to main content
14,360,959 members
   

Database

 
AnswerRe: Clarification on SQL Server Function? Pin
Shameel12-Mar-13 21:26
professionalShameel12-Mar-13 21:26 
GeneralRe: Clarification on SQL Server Function? Pin
Shameel13-Mar-13 0:01
professionalShameel13-Mar-13 0:01 
AnswerRe: Clarification on SQL Server Function? Pin
Mycroft Holmes12-Mar-13 21:44
memberMycroft Holmes12-Mar-13 21:44 
GeneralRe: Clarification on SQL Server Function? Pin
Mycroft Holmes13-Mar-13 22:20
memberMycroft Holmes13-Mar-13 22:20 
AnswerRe: Clarification on SQL Server Function? Pin
uspatel13-Mar-13 3:00
professionaluspatel13-Mar-13 3:00 
QuestionArithmetic overflow error converting expression to data type nvarchar. Pin
Vimalsoft(Pty) Ltd12-Mar-13 11:19
professionalVimalsoft(Pty) Ltd12-Mar-13 11:19 
AnswerRe: Arithmetic overflow error converting expression to data type nvarchar. Pin
Mycroft Holmes12-Mar-13 13:35
memberMycroft Holmes12-Mar-13 13:35 
AnswerRe: Arithmetic overflow error converting expression to data type nvarchar. Pin
Richard Deeming13-Mar-13 3:18
mveRichard Deeming13-Mar-13 3:18 
decimal(4, 1) means a number with three digits before the decimal point and one digit after:
http://msdn.microsoft.com/en-gb/library/ms187746.aspx[^]

Based on your provided inputs: 36.403 * 100 = 3640.3

Therefore, your result requires four digits before the decimal point, so the precision should be 5:
RETURN CAST(CAST(CONVERT(float, @parPercentageToBeFormatted) * 100 AS decimal(5, 1)) AS nvarchar(5)) + N'%'




"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer


Questionput a condition in join query Pin
demoninside912-Mar-13 2:38
memberdemoninside912-Mar-13 2:38 
AnswerRe: put a condition in join query Pin
Jörgen Andersson12-Mar-13 3:19
protectorJörgen Andersson12-Mar-13 3:19 
GeneralRe: put a condition in join query Pin
demoninside912-Mar-13 19:47
memberdemoninside912-Mar-13 19:47 
GeneralRe: put a condition in join query Pin
Mycroft Holmes12-Mar-13 21:40
memberMycroft Holmes12-Mar-13 21:40 
GeneralRe: put a condition in join query Pin
demoninside912-Mar-13 21:49
memberdemoninside912-Mar-13 21:49 
GeneralRe: put a condition in join query Pin
Mycroft Holmes12-Mar-13 23:23
memberMycroft Holmes12-Mar-13 23:23 
GeneralRe: put a condition in join query Pin
demoninside912-Mar-13 23:39
memberdemoninside912-Mar-13 23:39 
QuestionHow to Recover the Data if the Delete Query is Fire?? Pin
Anubhava Dimri11-Mar-13 23:11
memberAnubhava Dimri11-Mar-13 23:11 
AnswerRe: How to Recover the Data if the Delete Query is Fire?? Pin
Mycroft Holmes11-Mar-13 23:40
memberMycroft Holmes11-Mar-13 23:40 
GeneralRe: How to Recover the Data if the Delete Query is Fire?? Pin
Anubhava Dimri12-Mar-13 0:44
memberAnubhava Dimri12-Mar-13 0:44 
Questiondatabase design for a self food ordering system? Pin
suryakanthithommy11-Mar-13 7:40
membersuryakanthithommy11-Mar-13 7:40 
AnswerRe: database design for a self food ordering system? Pin
Sandeep Mewara11-Mar-13 8:04
mentorSandeep Mewara11-Mar-13 8:04 
Questionwhy i am unable to retrieve holiday name Pin
Member 870181310-Mar-13 23:35
memberMember 870181310-Mar-13 23:35 
AnswerRe: why i am unable to retrieve holiday name Pin
Mycroft Holmes11-Mar-13 0:20
memberMycroft Holmes11-Mar-13 0:20 
GeneralRe: why i am unable to retrieve holiday name Pin
Member 870181311-Mar-13 5:31
memberMember 870181311-Mar-13 5:31 
QuestionBCP - Exported files (docx, xlsx & pptx) are corrupted Pin
ragasai10-Mar-13 17:52
memberragasai10-Mar-13 17:52 
QuestionDatabase design for E commerce web site Pin
subbaraogaddam8-Mar-13 20:44
membersubbaraogaddam8-Mar-13 20:44 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.