When you say "package" are you using an SSIS Package and executing a stored procedure or sql code via an execute sql task?

Are you executing it via Sql Agent? does...

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...

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...

Your example does not do what I was referring to. In the original post V2,

From Table A

Left Join B on ID = ID

Where A.Col = x

and B.Col =...

Well, you really didn't supply quite enough table data, but if I'm understaning you correctly, you could use something like this below. Select your max info from the Transaction table...

Why not use a zip task in SSIS to unzip the file instead of Powershell?

Or you could even use an Execute Process Task.

Here is a link that may be...

As a left join, you are returning all rows from Table A, but only those in Table B that match (given the specified critera).

In your alternative, by removing the filters...

Here you go.

SELECT J1.Child

FROM dbo.Job J1

INNER JOIN dbo.job J on J1.Parent = J.Parent

INNER JOIN dbo.sites S on S.Child = J.Child

And sitecode = 18