I managed to do this using the INSCOPE function. For anyone else that may need to do something similar, I used the following expression in the NILR field and changed...

Please ignore, I have solved the issue. Will post when I have double checked the code.

------

Thanks HowardW, your solution is great and works perfectly. Will use this instead of my...

Perfect, thanks Mark.

Perfect. Thank you very much for your help and patience 🙂

Again apologies, as I say I only realised whilst testing. It's why we test right? Anyway, no there are no other requirements!

Hi Lynn many thanks for your help, sorry for the delay, didn't get a chance to test until late yesterday.

I spotted another slight porblem in testing, take a look at...

Thank you all for your replies, I will take a look at Jeff's article when it comes back online as I am sure I will run into this problem again....

For anyone else who needs to do something similar, I managed to do this by inserting the integer value returned by the stored proc into a temp table and using...

Perfect. Thank you very much Mark.

IF OBJECT_ID('TempDB..#1','U') IS NOT NULL DROP TABLE #1

CREATE TABLE #1

(

[RegNo] varchar(30),

[Surname] varchar(50),

[FirstName] varchar(50),

[DateofBirth] datetime,

[SNo] varchar(20),

[CCode] varchar(20),

[Pt1] varchar(30),

[Ct1] varchar(30)

)

INSERT INTO #1

([RegNo],[Surname],[FirstName],[DateofBirth],[SNo],[CCode],[Pt1],[Ct1])

SELECT '1605308', 'Bloggs','Joe', '01/05/1991', 'C0286371', '1210', 'F1', 'FT' UNION ALL

SELECT...

Yes that makes perfect sense, and works very well. Thanks for the replies guys.

Perfect. Thank you very much.

Just for anyone else who has received a similar error, I have managed to get the query to run for now by taking out the BEGIN TRAN and COMMIT. Not...

Thanks guys, I will give both suggestions a try and report back.

Suprisingly a synonym object is created when you issue a create statement against a column, but the 'object type' field is empty in the synonym properties.

Thanks again for your help.