.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Sql help

Posted By:      Posted Date: September 09, 2010    Points: 0   Category :Sql Server
Hi all, when running the below: SELECT proj.month   FROM   dbo.t_res_f_balancesheet                      fact            INNER JOIN t_res_d_projdate                    proj          ON fact.projdate_key                        = proj.projdate_key WHERE        proj.YEAR = 2011          AND proj.month = MIN(proj.month)   I get the following error message:   Msg 147, Level 15, State 1, Line 10 An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference.  

View Complete Post

More Related Resource Links

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend