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 |
|
Pinto
Aged Yak Warrior
590 Posts |
 Posted - 2006-05-03 : 11:05:35
|
I am creating a view in SQL using the View tab in the database and adding the table and the fields I need. For criteria I need to have 28 'or' s . How do I insert more columns on the end of my view ?  |
|
|
Pinto
Aged Yak Warrior
590 Posts |
Posted - 2006-05-03 : 11:30:40
|
| This may make it clearer exactly What I want to do. I have 28 fields P1 to P28. I am grouping the records by a Room Number and then summing each of the P1 etc fields. I need to check if any one of these fields is =2 or > 2 |
 |
|
|
Pinto
Aged Yak Warrior
590 Posts |
Posted - 2006-05-05 : 09:58:22
|
| I just edited the code and the columns appeared |
|
|
|
|
|
|
Add Column to a view - RESOLVED