Not a problem replaced with AND statement instead of ON seems to have resolved it 🙂

Thanks for the help and your time

J

Hi thanks for this,

Has an error on line 11 (ON statement)

J

Hope this is what you need 🙂

scripting for each of the tables:

USE [MMAUDIT]

GO

/****** Object: Table [dbo].[MMA_SITE_MST] Script Date: 10/26/2014 12:07:31 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER...

Would do if I new how,

Sorry no idea what you are after

J.

The current stored procedure below which I just duplicate when I have a new client (by just changing the ID number).

I tried to add my other stored procedure but get...

Hi,

Thanks for this will test,

Would it be easier to show you the code for the other stored procedure?

In the current stored procedure I copy the code down and change the...