Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pinkpig27
Starting Member
2 Posts |
 Posted - 2009-05-07 : 11:46:41
|
| I am new to T-SQL so forgive me my terminology if it is not completely accurate.Info:1)SQL Server 2005 - 2)Database is set to SQL server 2000 compatibility level because the app requires it DilemaI have a COTS DB a with a corrsponding windows client app, in the db I have a Table that has 6 columns, the subject column is a VARCHAR(255), the values for this column should contain characters that equate to a Remarks field in the db's corresponding application. However instead of remarks, all rows for this column return the words "Text_Placeholder" . I need to develop reports that include these remarks but I am having great difficulty finding them. I have looked in all of the tables to see if I have made an error about where the data is stored but did not find it. I have tried Cast and Convert and some other things that were probably wrong. Any help would would be great. I do not need to update or change the text, just return it in a result set.Thanks in Advance, |
|
|
nhess80
Yak Posting Veteran
83 Posts |
Posted - 2009-05-07 : 19:01:50
|
| Can you post the code you are using? |
 |
|
|
pinkpig27
Starting Member
2 Posts |
Posted - 2009-05-08 : 07:06:02
|
| Thanks for the response, this is similar code that I am using to retreive the data.SELECT * FROM t where t.b = 399Result Set:t.a t.b t.c t.d(VARCHAR(255) t.e174339 399 18443 TEXT_PLACEHOLDER 6206157 399 20189 TEXT_PLACEHOLDER 6 270739 399 23486 TEXT_PLACEHOLDER 6 |
|
|
|
|
|
|
Out of Row Data