Thanks Phil

🙂

I read a few articles and have now set the 'Delay Validation' of the 'Send Mail Task' to 'True'. The error message has now dissapeared.

Now I need to import package...

Phil thanks for that, just what I wanted. I was just reviewing a thread by greengiant;

"Please confirm Purchase Order " + @[User::PurchasedOrderId] + "will be delivered on " +...

Hi Phil, I think that i am on the right track. I now have;

"Please confirm Purchase Order " + @[User::PurchasedOrderId] + "will be delivered on " + (DT_WSTR, 50)...

Sarvesh the data type was smalldatetime.

Lynn that worked a treat many thanks.

Thanks to all for taking time to review my post, as always very much appreciated.......now on to SSIS!

Kind Regards,

Phil.

Thanks guys.

Phil.

Lutz the values returned in production look good.

Great work,

Phil.

Tried that but did not run app side (as expected!).

Thanks,

Phil.

Hi, no matter what the actual quantity the value retunred is always 10.

I thought I might try the following (where [Identifier] is the value passed by the app)

DECLARE @Qtyint...

Is there a way to make this dynamic as the Qty varies.

Full code as follows:

DECLARE @Qtyint

SET @Qty = 10.00

SELECT

p.ProductId,

p.ProductDescription,

i.LotNumber,

--'Qty: ' + CONVERT(nvarchar(112), i.Quantity),

STR(@Qty,5,2) AS Qty,

l.LocationId AS DefaultLocation

FROM GoodsReceipts...

Thanks, now that's what I call service 🙂

Phil.

Lutz many thanks for all your assistance, I will run against a larger data set and post my results.

Once again, many thanks,

Phil.

OK back to the correct post....

Lutz posted:

Hi Phil,

even though we change the thread, the subject is still the same... (for those that might want to look into the "old" story:...

Thanks Lutz, I will test. Did I post incorrectly or was it moved?

Boy am I having a bad day! I can update the correct post if so then post my...

Apologies for previous script it was late and I was tired.

Please find attached new script + sample data which I have tested.

I would like the query to return the Average...