Getting the list of tables and Columns that are embedded in a view ,function or a procedure is simple sp_depends ‘viewName or ProcedureName‘ Documented in MSDN http://msdn.microsoft.com/en-us/library/ms189487.aspx
Apr
6
2009
6
2009
Apr
6
2009
6
2009
Null value is eliminated by an aggregate or other SET operation
The Problem occurs when an aggregate function(max,sum,avg..) exists on null values. Trying to get rid of the null values may be the solution but in certain cases..you may need the extra data relying on the null values. So whats the solution? Append set ANSI_WARNINGS OFF on the beginning of the sql statement. When using the [...]
