SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


showing a version of my Application in result


showing a version of my Application in result

Author
Message
fawad.majid
fawad.majid
SSC Rookie
SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)

Group: General Forum Members
Points: 43 Visits: 119
Hi There..

I have 69 SQL DB servers and every server have identical tables but on three database when I am querying the table it populating the Application version in the column compare with other database servers which running the same table (most of them have the same information in the result) not populating the Application version information in the result

can anyone tell me why it populating the application version in the result
fawad.majid
fawad.majid
SSC Rookie
SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)

Group: General Forum Members
Points: 43 Visits: 119
its should not include the Application version in the result.. and its hard coded so its not like someone doing it when entering the data..
Lowell
Lowell
One Orange Chip
One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)

Group: General Forum Members
Points: 28566 Visits: 39977
fawad.majid (11/25/2013)
Hi There..

I have 69 SQL DB servers and every server have identical tables but on three database when I am querying the table it populating the Application version in the column compare with other database servers which running the same table (most of them have the same information in the result) not populating the Application version information in the result

can anyone tell me why it populating the application version in the result



so you are saying in three specific databases, you get an additional column of data you were not expecting?

sounds to me like someone modified the structure of the tables in those three databases, and added the data/applciation version to the table as well.

the Answer, if it's not obvious to you yet, is to explicitly list the desired columns

so instead of this:

exec sp_msForEachDB 'SELECT * FROM [?].dbo.MyTableName;'

--do this instead
exec sp_msForEachDB 'SELECT Column1,Column2,OtherColumns FROM [?].dbo.MyTableName;'





Lowell

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Lynn Pettis
Lynn Pettis
SSC-Forever
SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)

Group: General Forum Members
Points: 40054 Visits: 38567
Unfortunately, there is no way to answer this question as we don't know anything about your databases, application(s), environment to be able to tell you anything. We don't have crystal balls.

Cool
Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
fawad.majid
fawad.majid
SSC Rookie
SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)

Group: General Forum Members
Points: 43 Visits: 119
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"
Lowell
Lowell
One Orange Chip
One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)

Group: General Forum Members
Points: 28566 Visits: 39977
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

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search