Incorrect syntax near the keyword 'convert'.

Question

0.00/5 (No votes)

See more:

SQL

ALTER Procedure [dbo].[buson_getEMPLOYEEIDNAME_s]
(
    @Month INT,
    @Year INT
)
As
Begin
 Select EmpId,Name,(BUSON_SALARYSTR.BASICSALARY / dbo.GetNoofDaysPerMonth(@Month, @Year)) *
 (dbo.GetNoofDaysPerMonth(@Month, @Year) - dbo.NoofdaysAbsent(EmpId,@Month,@Year))(convert(decimal, '12343.5787') as BASICSALARY ,BUSON_SALARYSTR.CODE  FROM BUSON_EMP
 INNER JOIN BUSON_SALARYSTR ON BUSON_SALARYSTR.CODE = BUSON_EMP.SalaryStructure
End

Posted 6-Mar-13 22:03pm

DhananjayanP

Updated 6-Mar-13 22:05pm

Maciej Los

v2

Add a Solution

2 solutions

Solution 1

Try this:

SQL

CONVERT(DECIMAL(18,2),'123456.789')

More about CONVERT[^] function.

Posted 6-Mar-13 22:07pm

Maciej Los

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2013-03-06T22:08:00

Shouldn't there be a comma in there?

SQL

Select EmpId,Name,(BUSON_SALARYSTR.BASICSALARY / dbo.GetNoofDaysPerMonth(@Month, @Year)) *
(dbo.GetNoofDaysPerMonth(@Month, @Year) - dbo.NoofdaysAbsent(EmpId,@Month,@Year))(convert(decimal, '12343.5787') as BASICSALARY ,BUSON_SALARYSTR.CODE  FROM BUSON_EMP
INNER JOIN BUSON_SALARYSTR ON BUSON_SALARYSTR.CODE = BUSON_EMP.SalaryStructure

SQL

Select EmpId,Name,(...) * (...)(convert(decimal, '12343.5787') as ...
-------------------------------^

Incorrect syntax near the keyword 'convert'.

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Incorrect syntax near the keyword 'convert'.

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us