fawad.majid (11/25/2013)
No No!not additional column ... there is a column name RPTBO_HTML column in the table, in the result it getting the same data as other database are but it adding the Application version as well.. its like this
query run and get the data from the table... and in above mentioned column not like other tables in other databases it also including this statement in the same column ... Ill post it to make it clear..
There is other data in this column plus its adding this line which causing the problem and its not in other databases ...
* Report results were calculated using Allscripts Professional EHR version: 10.0"
nope, not clear yet, at least for me.
show us the actual query you are running.
if you are getting DATA that doesn't match your expectations, you'll need to look at either why the data is wrong, or why your query is not gettign the "right" data...bad grouping, top 1 without order by, who knows...we'd need to see your query to help diagnose.
*edit*:
are you running a query in an applicaiton, or from SSMS?
the text you quoted implies some report application named "Allscripts Professional EHR version: 10.0" " was used, and not SSMS.
maybe the evaluation version inserts that data, but the "Professional " version does not?
Lowell