Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Why ISNULL Eliminates Blank Lines
George, Thank you for a very detailed and helpful explanation!- valis99
- Post #5
- Forum: Microsoft SQL Server: Programming
-
Why ISNULL Eliminates Blank Lines
I have created a view using this code, my intent is to return a line for each day for each product, with ISNULL causing zero values for days on which that product had no sales. Instead it omits product/day combinations that had zero sales. It is important to have the zero value lines because...- valis99
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
