Thread: SQL Help
View Single Post
  #4 (permalink)  
Old 30-01-08, 03:39 PM
MartinS's Avatar
MartinS MartinS is offline
Senior Member
  

Join Date: Jul 2002
Location: Redhill, Surrey
Posts: 1,550
MartinS paddles in the seaMartinS paddles in the seaMartinS paddles in the seaMartinS paddles in the seaMartinS paddles in the seaMartinS paddles in the seaMartinS paddles in the seaMartinS paddles in the seaMartinS paddles in the seaMartinS paddles in the seaMartinS paddles in the sea
Thanks Ron.
I tried the first one, and it works, but the ISNULL function requires two parameters, so i added this to the end instead:
Code:
HAVING(ISNULL(SUM(AA.AssetPercentage),NULL)ISNOTNULL)
and it works a treat!
Thanks for the pointers.
Martin
__________________
Never test the depth of the water with both feet!
69 Divers SAC
Yorkshire Divers
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote