BEGIN

Update TABLE1

Set Column1 = (Select convert(date,CallStart) as CallStart

From TABLE1

Inner join TABLE2 P ON A.ProcessID = P.ProcessID)

END

When I execute the above Query i am faing the following error.

Msg 512, Level 16,...

Update T2

Set CallDate = ( select CallStart

from T1

where convert(Date, CallStart)

its an syntax error.

thanks.

Thanks

any suggestions!

IS that if we create the cubes and dimensions in visual studio does come into AS database which we can open through SSMS?