Hi Paul

I am comfortable using VBA, so my solution would be to add an AfterUpdate event on the LINE_CD control with something simple like a DLookup, using it to set...

I agree, it does sound like it has found its way into a job or similar scheduled task, but nothing like that exists on this server.

As far as the DDL...

A question I should have asked in my first post - what is the source of the data in this column? Are users able to copy and paste text...

Hi

From the description you have given, I suspect that you don't have just plain alphnumeric characters in your text. There may be carriage return, or similar, characters. Copy...

Hi

I hope you have found a solution by now but if you haven't, my pick here is that there is a security issue involved. Possibly the owner of the...

Hi

When you say it doesn't work with a join in your subquery, do you mean it errors or simply does not result in any records being deleted?

If you are getting...

The "dtproperties" table is a system table (created and maintained by SQL Server itself) not an application one.  I think it is used to store details of any database diagrams...

I suggest you jump into Books Online and have a look at the DateFirst function.  Your problem certainly does seem a little odd, but the solution may be in setting...

Wow!  Look what happens when I go and leave you guys alone for the weekend!!

In what I consider to be the spirit of these forums, thank you all for your...

Thanks for your response.  I have been around this industry for twenty years but I am still amazed by the engenuity and endeavour that the net has exposed us to. ...

Hi

Gila is right - get rid of the duplicate data, then modify your table design to prevent it happening again.

One of the easier ways of determining duplicated records, as it...

Hi Phil

Can you pin it down to just this view?  Do you have any linked tables which can open or perhaps another view - preferably simpler and faster to respond. ...

Hi

I think for your selects to work using a varaible as a table name, then you will have to create the select as a string and exec that string.

In terms...

Hi

I create CSV files using BCP from stored procedures.  I build the data in a temp table, then update an "outputs" column on each record with the concatenated values from...

Of course, there is always another way to start QA

How about creating an association to a script file extension - I guess most...