The most simplest way is when you want default data to be published when not existing is to use a Stored Procedure or a View to build it.
For example for field 'Single Male' if data is NULL then use a Select statement such as:
SELECT ISNULL(Single_Male,0) FROM mytable
will return 0 if data is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.