SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 How to get the tables or database schema
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

AdamWest
Constraint Violating Yak Guru

USA
353 Posts

Posted - 08/30/2011 :  08:35:50  Show Profile  Reply with Quote
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

India
52317 Posts

Posted - 08/30/2011 :  09:26:47  Show Profile  Reply with Quote
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 MVP
http://visakhm.blogspot.com/

Go to Top of Page

gwilson67
Starting Member

USA
42 Posts

Posted - 08/30/2011 :  09:53:17  Show Profile  Visit gwilson67's Homepage  Reply with Quote
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.

Greg
http://www.freewebstore.org/tsqlcoderepository
Powerful tool for SQL Server development
Go to Top of Page

Lamprey
Flowing Fount of Yak Knowledge

4614 Posts

Posted - 08/30/2011 :  11:17:24  Show Profile  Reply with Quote
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?
Go to Top of Page

AdamWest
Constraint Violating Yak Guru

USA
353 Posts

Posted - 08/30/2011 :  14:55:45  Show Profile  Reply with Quote
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.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000