try this method

Declare @OutputParameter Datatype

EXEC StoredProcedurename

...

try this one .........

SELECT tagname FROM history as h

inner join livedata as l on l.tagname = h.tagname

where value = 1

try this sample ........

/***********original table********************/

CREATE TABLE employeeData (

emp_id int NOT NULL,

emp_bankAccountNumber char (10) NOT NULL,

emp_salary int NOT NULL,

emp_SSN...

UQ = UNIQUE constraint

for complete reference

http://msdn2.microsoft.com/en-us/library/ms190324.aspx

it denotes Object type. Can be one of these values:

C = CHECK constraint

D = Default or DEFAULT constraint

F = FOREIGN KEY constraint

FN = Scalar function

IF = Inlined...