SQL View returning different results
-
Hi I have a SQL view that returns different results depending on how I run it. If I run it in Design mode, all of the records in some of the columns come back as NULL. However, when I SELECT TOP 1000 rows from the view, the records in these columns are returned with the correct values. Any ideas why this happens?
-
Hi I have a SQL view that returns different results depending on how I run it. If I run it in Design mode, all of the records in some of the columns come back as NULL. However, when I SELECT TOP 1000 rows from the view, the records in these columns are returned with the correct values. Any ideas why this happens?
What is your database? What is your client (app or SSMS) or ? It may be caused by the transport layer not liking the volume.
Never underestimate the power of human stupidity RAH
-
Hi I have a SQL view that returns different results depending on how I run it. If I run it in Design mode, all of the records in some of the columns come back as NULL. However, when I SELECT TOP 1000 rows from the view, the records in these columns are returned with the correct values. Any ideas why this happens?
Etienne_123 wrote:
some of the columns come back as NULL. However, when I SELECT TOP 1000 rows from the view, the records in these columns are returned with the correct values
Sounds like a data conversion issue.
Common sense is admitting there is cause and effect and that you can exert some control over what you understand.