I am running an query to count number of a specific failure by week. I need data for only one ProductFamily and that information is available in a seperate view and I used join to obtain that data. The query runs without any errors but it keeps executing without any output. Is this a server issue or is my code wrong?