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

You could use this to get you in the right area. It will get the files from a directory. I did it once before where I basically ordered by date...

Declare @value1 numeric(38,10)

Declare @value2 numeric(1,1)

SET @value1 = 1234567890.123456789

SET @value2 = 0.1

SELECT @value1

SELECT @value2

SELECT @value1 * @value2

= "123456789.012345679"