I run WinSCP via Powershell script

Ooops! you're running is SSIS, ignore me :blush:

Did know someone whose workplace had a life size cardboard cut out of a person called Maud (name not acronym) which...

SELECT Company

FROM CompanyEmployeeArchive

GROUP BY Company

HAVING COUNT(*) = SUM(SIGN(100-Employees))

CONVERT(datetime,[date],CASE WHEN [date] LIKE '%M' THEN 101 ELSE 103 END)

Sean Lange (3/12/2015)

---

measterbro (3/12/2015)

---

I know it is being truncated because I get a syntax error at a point about a third of the way in my SQL which I don't...

I'd bet that when you concatenate the variable the string is converted to nvarchar(8000) instead of remaining nvarchar(max)

Use sp_executesql and pass the variable as a parameter (if it is in...

Leave the tablix visibility as I specified

Add a new row 'Outside Group - Below' the row group for the tablix,

Merge Cells as necessary,

set text to 'No rows for...

Add a filter, select booking date from the dataset, select >= and set the expression for the value to

DateAdd(DateInterval.Day,1,Today)

Add a seconf filter, select booking date from the dataset, select...

use this expression

=Not(Filter(Parameters!ReportParameter1.Value, "Tab1", True, CompareMethod.Text).Length = 1)

and change Tab1 to Tab2 for second tablix

That does not make sense, what is the filter supposed to do?

Is the parameter a single value, i.e. only ONE of ALL,Tab1,Tab2

Refer to my previous post regarding creating a Cartesian product, in this case of yearmonth and vendor.

Also refer to my post referring to providing DDL, data and expected results as...

boettger.andreas (3/9/2015)

---

Out of interest though, how would I achieve the same when not filtering by location?

For example show all locations with all 12 months and for those with no order...

OK back to the beginning, what you needed to post was

Create tables

CREATE TABLE Past12Months (YearMonth char(6))

CREATE TABLE OEORDH (ORDUNIQ int,SHIPTO char(5),ORDDATE char(8))

CREATE TABLE OEORDD (ORDUNIQ int,QTYBACKORD int)

Populate tables

INSERT Past12Months (YearMonth)...

You have to LEFT JOIN both tables, i.e.

SELECTp.YearMonth AS PastYearMonth, OH.SHIPTO AS Location, LEFT(OH.ORDDATE, 6) AS YearMonth

FROMPast12Months AS p

LEFT JOIN OEORDH AS OH ON LEFT(OH.ORDDATE, 6) = p.YearMonth

AND...