The stored procedure works, because if I execute it outside the trigger, it works.

Maybe my syntax is wrong for the trigger or something

Yeah that worked thanks, its not selecting that column(ADR3) anymore. But its not giving me any data, just showing the column titles.

HI,

I have changed my code up so get only the specific record needed.

Here is what it look like now.

Once again I don't get any errors, but its like only the...

Yeah there are more than one, but there aren't duplicates, one address can be used more than once, so I need to create a view that I can query later...

Not to sure. There are more than 1 records but there are not duplicates.

Its just that there can be multiple entries for each address.

I need to create a view so...

When I do it before then I get the following error.

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >,...

Just below that I set the value.

SET @ADR3 = (SELECT ADR3

FROM PAT_NAMES_ADDRESS

WHERE ADR1 = @ADDRESS)

SET @ADDRESS = 'M & B Pumps Division'

Hi John,

I di what you said: SET @ADR3 = (SELECT ADR3

...

The SP inserts data into a table in another database.

The trigger should execute this stored procedure as soon as new data is inserted into the table.

Hi Can anyone please help me, I get the following error message:

Msg 245, Level 16, State 1, Line 2

Conversion failed when converting the varchar value 'TA1001F ' to...