Search results for query: *

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...

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.

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...

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...

Thanks again.

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...

Thanks for the quick and informative response!

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...

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...

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

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...

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...

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.

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.

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

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...

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.

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

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...

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...