TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
siva nathan
953
828
233.2k
i cant group a column in sql server
Apr 4 2017 12:50 AM
my table record is below in screen shot
my query is belw
declare @FromDate datetime
set @FromDate='03-01-17'
declare @Todate datetime
set @Todate='03-19-17'
select
sum(round(OThrs,0)) as OThrs, convert(int,round((( ME.AuditSalary+HRA)/8),0)* convert(int,round(isnull(OThrs,0),0)*2)) as OTSalary
from master_salary as MS
inner join Master_Employee as ME on ME.id=MS.Refid
Where convert(varchar(10),MS.Attdate,110) between @FromDate and @Todate and ME.Category in(2)
group by ME.AuditSalary ,HRA,OThrs
Attachment:
Screenshot_(59).rar
Reply
Answers (
6
)
how to round off 2.30 as 3 same way 2.15 as 2
How to get the work confidence in IT field