Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Joiner

    READTEXT - text data type

    Does anyone know if it is possible to retrieve data from a text field in the same select statement with other fields? For example - I have a text field that cannot be retrieved with a simple select statement due to size. The following obviously does not work. Does anyone know if/how I can do...
  2. Joiner

    Documentation

    if you're just looking for a visual diagram, you can use the diagram tool in enterprise manager. there is a wizard to help you with the process.
  3. Joiner

    Optional parameters

    Thanks Terry. I have actually noticed that myself but was convinced that it was a fluke. I have since; however, found other stored procedures of mine similar to the one above that run faster when converted to a dynamic statement. Any ideas on why? I'll need to be able to support this...
  4. Joiner

    Optional parameters

    Hi. Can anyone recommend the best way to handle this situation? I have a stored procedure that returns a list of properties. I also have optional parameters that can be passed, for example, if a state parameter is not passed, it is assumed that the user wants to see all properties, if a state...
  5. Joiner

    Field Names as variables in stored procedures

    Thanks again.
  6. Joiner

    Field Names as variables in stored procedures

    Terry - I have a situation where the user is allowed to build their own WHERE clause. Would you recommend building the SQL string to support this in a stored procedure and executing with sp_executeSQL? Other than a single storage place, are there any advantages to using a stored procedure...
  7. Joiner

    Query record numbering and/or Select Next 50

    Thanks for the quick and informative response!
  8. Joiner

    Query record numbering and/or Select Next 50

    Thank you Terry. Those links were very helpful. I have one more question - if the TOP operator is used without an ORDER BY clause in a query like the one below , does it automatically use the first field to determine TOP number of records? Meaning, will the records always be sorted in...
  9. Joiner

    Query record numbering and/or Select Next 50

    Hi all. Forgive me for beating a dead horse but after reading many archived posts on this subject I still need some help. I have a stored procedure that returns a huge recordset to the end user. I would like to split this and take the Top 50, Next 50, Next 50 and so on. I've reviewed several...
  10. Joiner

    Huge result set using many joins and grouping

    Thank you! Both of your comments are very helpful, in addition to supporting my case.
  11. Joiner

    Huge result set using many joins and grouping

    Hi. I have been given a stored procedure request that would return about 100,000 records at a time. The record length would be approximately 1,500 bytes and the criteria includes about 17 left joins and an aggregate function which would group about 60 fields. The programmer wants to take this...
  12. Joiner

    Select statement processing order

    Hi there. I'm trying to learn more about the basic implementation of SELECT statements in MSSQL. My understanding is that SQL will first evaluate the WHERE clause, followed by the ORDER BY and GROUP BY clauses (if any), then the HAVING clause (if any), and finally evaluate any aggregate or...
  13. Joiner

    Distribute VFP7 app for terminal server

    So, it seems there is no difference in supporting runtime file requirements for a terminal services installation. Is this true? Thanks again for the help. It is much appreciated.
  14. Joiner

    Distribute VFP7 app for terminal server

    Hi there. Has anyone had any experience distributing their VFP7 app on a machine running terminal services? I need to know if there are additional VFP7 runtime libraries or other files that must be packaged for this type of installation. Thank you very much for your help.
  15. Joiner

    VFP7 Distribution Process

    Thank you both. All of this information has been very helpful.
  16. Joiner

    VFP7 Distribution Process

    I answered my own question: "Feature Changes since the Previous Version of Visual FoxPro The following features from the previous version of Visual FoxPro have been removed from the product: The Setup wizard is no longer included with the product. A Microsoft Installer based deployment...
  17. Joiner

    VFP7 Distribution Process

    Ramani - In VFP6 I can easily find the setup wizard under Tools/Wizards. This is not the case with my installation of VFP7 - am I missing something? Thanks again.
  18. Joiner

    VFP7 Distribution Process

    Thank you very much. I will give it a go.
  19. Joiner

    VFP7 Distribution Process

    Hi there. I apologize in advance for the elementary level of my post but I am a SQL DBA that (due to limited resources) has been assigned the unusual task of deploying our VFP7 application to the client. My situation is this: We have an existing client that is currently using our application...
  20. Joiner

    Maintenance Plan - index pages

    Can anyone tell me the "best practice" for optimizing index pages? Our indexes were created with the default fill factor of zero as recommended in BOL. I am now creating a maintenance plan and I'm wondering if it is better to reorganize pages with the original amount of free space or...

Part and Inventory Search

Back
Top