Hi:
I have a simple stored procedure that takes a begin and end date as parameters and builds a table of values. Both paramenters are smalldatetime types. There are two dates in the query that are compared to those and both are also smalldatetime. When I put the stored procedure into SSRS and go to the Query Builder, I can see a results grid but get this message:
"Could not generate a list of fields for the query. Check the query sytnat or click Refresh Fields on the query toolbar.
Implicit conversion from data type sql_variant to smalldatetime is not allowed. Use the CONVERT function to run this query."
I can execute the SP perfectly in SSMS.
DB is in SQL2008 but must use SSRS 2005 to comply with eventual UI restrictions.
Any help is appreciated.
Thanks
I have a simple stored procedure that takes a begin and end date as parameters and builds a table of values. Both paramenters are smalldatetime types. There are two dates in the query that are compared to those and both are also smalldatetime. When I put the stored procedure into SSRS and go to the Query Builder, I can see a results grid but get this message:
"Could not generate a list of fields for the query. Check the query sytnat or click Refresh Fields on the query toolbar.
Implicit conversion from data type sql_variant to smalldatetime is not allowed. Use the CONVERT function to run this query."
I can execute the SP perfectly in SSMS.
DB is in SQL2008 but must use SSRS 2005 to comply with eventual UI restrictions.
Any help is appreciated.
Thanks