>>>
>>>SELECT Date, DatePart(hour,Date) as Hr, reading
>>>FROM TABLE1 A
>>>WHERE Date IN
>>>
>>>(SELECT Min(Date) as date
>>> FROM TABLE1 B
>>> WHERE DatePart(hour,A.Date)= DatePart(hour,B.Date)
>>>
>>>UNION
>>>
>>> SELECT Min(Date)as date
>>> FROM TABLE2 C
>>> WHERE DatePart(hour,A.Date)= DatePart(hour,C.Date))
>>>
>>
>>
>>
>>Thanks sir your codes work fine in sqlserver new query window
>>But I want to create a view from these codes instead of using codes every time.
>>I shall pickup required data from view.
>>
>>To do this I put your codes under view like shown in image but it is displaying an error messages
>>
>>I think there will be use JOIN clause but I am unable to do this.
>>Please help me to create a view with your codes
>>
>>Thanks
>
>Try the following Statement, which error do you receive?
>
>CREATE VIEW Test
>AS SELECT Date, DatePart(hour,Date) as Hr, reading
>FROM TABLE1 A
>WHERE Date IN
>(SELECT Min(Date) as date
>FROM TABLE1 B
>WHERE DatePart(hour,A.Date) = DatePart(hour,B.Date)
>UNION
>SELECT Min(Date) as date
>FROM TABLE2 C
>WHERE DatePart(hour,A.Date) = DatePart(hour,C.Date))
Sir view created but when I try to click on design then it display error message shown in attachment.