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 |
|
AdamWest
Constraint Violating Yak Guru
360 Posts |
 Posted - 2011-08-30 : 08:35:50
|
| HI I Have 4 tables all relating to orders. Master, detail, status, and a log. the log is very key for the application.I would like to see how I am going to access the records with a status of ACTIVE. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-30 : 09:26:47
|
| what all your table contains? without understanding that its quite difficult to give a suggestion. post some sample data from tables and then explain what you want giving required output------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
gwilson67
Starting Member
42 Posts |
Posted - 2011-08-30 : 09:53:17
|
| 1) Create a new view. 2) Add the tables master, detail, status and log. 3) In the where clause, specifiy status = 'Active'4) Run the view or copy the SQL that is produced.Greghttp://www.freewebstore.org/tsqlcoderepositoryPowerful tool for SQL Server development |
|
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2011-08-30 : 11:17:24
|
quote:
Originally posted by AdamWest
<snip>I would like to see how I am going to access the records with a status of ACTIVE.
If you don't know how to access your own tables, why do you think we would know? |
|
|
|
AdamWest
Constraint Violating Yak Guru
360 Posts |
Posted - 2011-08-30 : 14:55:45
|
| OK should have said i am in new job. so i was trying to understand some of the tables i have to use for an app.it turns out i only need one table actually so i am good to go. |
|
|
|
|
|
|
How to get the tables or database schema