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 |
|
rjtj
Starting Member
3 Posts |
 Posted - 2011-05-03 : 17:25:51
|
| I have data going from a production server database to a database in a report server. I haven't yet figured out how the data gets there, but I need to bring over two more columns. If I go into the database on the report server and create the two columns, I can refresh the db and see them as columns. However, when I do a "Select Top 1000 Rows" I can see the two colums filled with Nulls (fine for now) but even the query itself lists the fields as undefined. I've never seen this before. Does anyone know what's going on? |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-05-03 : 17:29:09
|
| >> the query itself lists the fields as undefinedWhat do you mean by that?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
rjtj
Starting Member
3 Posts |
Posted - 2011-05-03 : 18:54:22
|
| The 2 new fields have a red squiggle line underneath. When I hover the cursor over either, I get a "Invalid column name" warning. All other colums report as the actual column and type. |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-05-04 : 03:07:41
|
| I think you mean in management studio. That's just because intellisense doesn't have a record of them as they were created after it loaded it's data. You can reconnect or refresh the cache (edit, intellisense, refresh cache) or I think it's ctrl-shift-R==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
rjtj
Starting Member
3 Posts |
Posted - 2011-05-04 : 12:57:43
|
| Yes, I did mean in Management Studio. I had quit the application to refresh everything but, for some reason, that didn't work. I used your suggestion to use intellisense under the edit menu and they are now valid. Thanks much. |
|
|
|
|
|
|
New columns, complex report