This user account () has been banned from the forums
Viewing 7 posts - 31 through 38 (of 38 total)
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 =...
February 23, 2012 at 11:32 am
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...
February 23, 2012 at 11:19 am
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...
February 23, 2012 at 11:00 am
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...
February 23, 2012 at 10:44 am
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
February 23, 2012 at 10:29 am
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...
February 23, 2012 at 8:08 am
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"
March 22, 2011 at 6:30 am
Viewing 7 posts - 31 through 38 (of 38 total)