Cheers that worked perfectly I'll run some check s now see if any thing breaks.

A big thanks to everyone who's helped ,thanks for you support.

That's it you've officially lost me now this is SQL way over my head LOL 

This Query

SELECT OPCQuality,
FROM Live
WHERE TagName IN ('Work-Shop-Email-Test') 

Returns a...

Thanks   I've got a query that returns the data I require:

SELECT OPCQuality,
  FROM Live
  WHERE TagName IN ('Work-Shop-Email-Test')

So now your saying I...

Ahh I see

Tried that this is what I get

USE [Runtime]
GO

/****** Object: View [dbo].[v_Live]  Script Date: 05/22/2018 13:22:07 ******/
SET ANSI_NULLS ON
GO

I doubt I could find that the data base wasn't created by me and its huge

Thanks Sue I know what I need to be looking at now many thanks

Hi Sorry your going to have to dumb it down for me a bit here whats a table DDL?