Options...SQL Server Object Browser...Scripting...Script Triggers = True

I can't see anything obviously wrong with the logic.

What I would do next is put two textboxes on the report, one for

=(

iif(Sum(Fields!TotalInvPrimaryPart.Value, "PartNumber")=0

,Sum(Fields!TotalInv.Value, "PartNumber")+first(Fields!TotalInvPrim.Value, "PartNumber")

,Sum(Fields!TotalInv.Value, "PartNumber"))

+

iif(Sum(Fields!QTYonOrderPrimaryPart.Value, "PartNumber")=0

,Sum(Fields!TotalQTYonOrder.Value, "PartNumber")+first(Fields!QTYonOrderPrim.Value, "PartNumber")

,Sum(Fields!TotalQTYonOrder.Value, "PartNumber"))

+

iif(Sum(Fields!QTYonPMRPrimaryPart.Value,...

http://microsoft-ssis.blogspot.co.uk/2011/12/propercase-in-ssis.html

Ideally you would have suitable exclusions in your where clause to avoid procesing errors.

You cannot trap errors on one select in a UNION, but you could insert the results of...

the step will fail immediately when the second proc errors if they are all in one step, but if you have each proc in it's own step, you can configure...

if you are filtering in the SQL statement, why not just use an IF and have two queries, one for each filter?

Glad it helped, and thanks for the feedback 🙂

You have put quotes (") round the expressions, making them strings...

Instead of adding a row inside the group, try this:

Start with a Table with two columns, one for your "group" value and one for the aggregate (sum):

Select both cells on...

Hi Lowell,

Thanks for that - it is a reasonable work-around until those spoon-heads fix SSMS back to how it used to work...

Unfortunately, I can't really make use of that as...

I know a lot of fools.

No worries, now if you can find...

Here you go:

Here is an iTVF for it...

CREATE FUNCTION SplitWithDelimiter (@MyString VARCHAR(200), @MaxLength INT, @Delimiter CHAR(1), @Breakers varchar(256))

RETURNS TABLE

WITH SCHEMABINDING

AS

RETURN

SELECT substring(base.value, 1, Pos1) + @Delimiter + substring(base.value, Pos1 + 1, Pos2 -...

gmamata7 (6/21/2013)

---

How to change the system date in only one database?

When an application accesses this database, it should show the future date. But the rest of the database should show...