Thanks for the reply,

I'd be happier not allowing them access to SQL and I think secure FTP would suit their requirements. 🙂

Thanks ZZartin, I could run a trace as you say but I suspect that this is deliberate and malicious behaviour and as such whoever is doing it is good at...

Thanks Sean, interesting about use of the nolock hint, I wasn't aware of that and this is recommedned by the software vendors - I will discuss it with them what...

no generic columns - here is the view

CREATE VIEW [dbo].[bespoke_packaging_per_job]

AS

SELECT DISTINCT dbo.jobbom.jobnum, dbo.lotdet.lotnum, dbo.prdall.descr, dbo.spdfil.mark, dbo.boming.slot

FROM dbo.bomlot WITH (nolock) INNER JOIN

...

I completely agree, but I the support company I work for have only one login to this customer, and they will not create separate ones for each user unfortunately.

Any...

unfortunately it could be someone who logs in under the same credentials as me.

The db mail idea is good, although in the same way as disabling the trigger,...

Yes - disable/enable trigger are not in the default trace unfortunately 🙁

Yes, the data will be used to calculate storage charges for pallets based on the number of days the pallets have been in stock. I have a stored procedure...

Thanks for all your help guys, I marked Adi Cohn's as the solution because that's what I used in the end, but the other solution does also achieve the goal.

Thanks, that works great on my sample data, but when I try it against the real table with more rows it returns the following error:

The maximum recursion 100 has been...

I finally got this to create the view successfully with the following code:

WITH MyCTE AS (SELECT TOP (1) nomcode AS Retained

...

Thanks but when I try this it returns 'mutipart identifier MyCTE.RetainedVariable could not be bound'?

I can create a user defined function to get the value but not sure how I can use that either?

CREATE FUNCTION dbo.udf_retained_nomcode()

RETURNS @ret TABLE (col VARCHAR (16))

AS

BEGIN

DECLARE @retained...

Thanks I tried that but I can't use the subquery (SELECT nomcode FROM ctlfil WHERE recid = 24) in the GROUP BY clause

Thanks dwain.c - I used xsevensinzx because it is a one off operation. Yes it is slow but scheduled overnight it hadn't got in the way of anything...