Re: Possible?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Although I have the access to the database, I don't have the know-how
to create the stored procedure. Creating views I think I could handle,
but I'm having a hard time understanding how they solve my problem.
Currently I'm importing from about 10 different tables, with link
correspondences out the wazoo. Say in my original report I needed
columns from Tables 1, 2, and 3. Now in one of my new reports I need
columns from Tables 1, 2, and 4. Can I create views so that I will be
able to run just one query and get what I need?

....I'm in over my head.

.

Relevant Pages

  • How to list atributes of all tables in Query Analyzer
    ... I need to know the properties of all tables in a given database on MSSQL ... I know that there is a stored procedure with the name "sp_MShelpcolumns" ... Prev by Date: ...
    (microsoft.public.sqlserver.clients)
  • Re: Finding a record in a TADOTable
    ... comming from. ... If it is already in another table in the database then ... the stored procedure will not generate any network traffic other than ... Prev by Date: ...
    (borland.public.delphi.database.ado)
  • Re: Why the performace differs?
    ... this database is accessed by only me no one is using it. ... really, this slow performance is really weared, ... I have tested it and when i run the Stored Procedure the sql server ... Prev by Date: ...
    (comp.databases.ms-sqlserver)
  • Re: WSS text search does not seem to handle phrases
    ... got the wrong database? ... I just tested it and replaced the stored procedure of a new WSS site ... Prev by Date: ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Possible?
    ... > Although I have the access to the database, I don't have the know-how ... > to create the stored procedure. ... UNION ALL in your view. ...
    (microsoft.public.vb.crystal)