encapsulate your set logic with the ROUND() function.

set @N=ROUND((SELECT CONVERT(numeric,(493-1)) / 493 *100),2)

SET @a= ROUND((select CONVERT(numeric,(24625- 1 ))/24625 *100),2)

-You results will be

99.8

100

However, as stated in the previous reply, your...

How does one interpret an error message which says

The subreport 'Subreport2' could not be found at the specified location /xxxx. Please verify that the subreport has been published and...

You already have your logic outlined, so really, all you need to do is set it inside a case statement (if doing this in T-SQL)

This would be representative of your...

My pleasure!

I have learned sql in many ways. I learned some basics via class at my work back in the day when I first got started.

Also have learned...

Really could use more info, but you could do something like this:

Select Supervisor.Name as SupName, Employee.Name as EmpName

From TableA as Supervisor

Inner Join TableA as Employee

on Superviser.ID = Employee.SupervisorID

If you...

change the join in query 1 that I gave you to

where Employee.JobTitle = JobTitle.JobTitle

instead of joining on JobDesc

For 2 and 3, I made an assumption for your field to determine if Exempt or Not, Employee State of Residence, Employee Hire Date, and Employee Birth Date

--1.Choose a Job...

I'm assuming you already have your variables set up.

@[User::SourceFileName] is equal to "TDBANKNORTH_GARDEN_671.txt"

Create - @[User::RunDate] Where it is set to GETDATE()-1

Create - @[User::DestFileName]

Then you want the @[User::DestFileName] variable expression...

You're right. I didn't catch that. Dag nabbit. Thanks!

Even though, it still makes it an inner join in effect.

So the question is, if it is a filter, why would...