Hi Theo

This looks very interesting, however I am hitting a conversion error in the dynamic SQL...

SELECT h.step_name as JobName
            ,j.name as CatName
            ,CONVERT(DATETIME,...

Many thanks for the information. I will take the advice on board 🙂

Hi Eugene

Only one record at a time does get updated via user data entry. Are you referring to the original trigger I inherited or to the modification I made to...

I decided to see if some of the seemingly over-complicated form events in place were preventing the trigger in some way and before I got very far, I found that...

Hi. The data is definately being entered via the form. In fact it was a long time before I realised the trigger was working via other means because I was...

Hi. Entire trigger is as follows...

USE [FastPLANNINGDev40]

GO

/****** Object: Trigger [dbo].[ispitblContactsIUTrig] Script Date: 05/28/2012 10:37:29 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER TRIGGER [dbo].[ispitblContactsIUTrig] ON [dbo].[itblContacts]

FOR INSERT,...

Jeff Moden (12/13/2009)

---

Paul-755326 (12/13/2009)

---

RBarryYoung (12/13/2009)

---

Ouch! You can do much better than a WHILE loop. I strongly advise to read the article that bitbucket pointed out to you (http://www.sqlservercentral.com/articles/T-SQL/63003/)...

RBarryYoung (12/13/2009)

---

Ouch! You can do much better than a WHILE loop. I strongly advise to read the article that bitbucket pointed out to you (http://www.sqlservercentral.com/articles/T-SQL/63003/) which as it...

Jeff Moden (12/12/2009)

---

Paul-755326 (12/12/2009)

---

thank you for the information - very interesting. I solved my problem by using the following TSQL as source data in my DTS...

DECLARE @STR varchar(8000)

SELECT...

thank you for the information - very interesting. I solved my problem by using the following TSQL as source data in my DTS...

DECLARE @STR varchar(8000)

SELECT @STR=kPEAccountCode...

I managed to overcome the problem

It seems to me that the users affected were switched from English to British English after they had SQL Client installed and this change does...

it was just the last semicolon and of course the text/varchar change

many many thanks

Hi Gsquared

many thanks for this, but I get incorrect syntax near ';'

also - where do I find help for UDFs?

already tried. No difference.

In your DTS package, you will have at least one connection to a database. I have seen a lot of people using local/localhost and a SQL account (generally, I...