User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
DaniWeb is a massive community of 429,950 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,462 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Showing results 1 to 1 of 1
Search took 0.00 seconds.
Posts Made By: Mike_Meg
Forum: MS SQL Nov 12th, 2005
Replies: 8
Views: 55,065
Posted By Mike_Meg
Re: SQL SERVER 2000 Selecting a record based on an aggregate function

First I am new to all this but would the following work for you?

The first query gives the same error as you were stating but if you replace the group by with a sub query and a where clause that...
Showing results 1 to 1 of 1

 
All times are GMT -4. The time now is 11:16 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC