Search results for query: *

Cheers guys both of those look like they'd work. The actual queries pretty big and has a few more lookup tables. I'll give both of these a try for performance and post back. Top Work [thumbsup2]

I have the following query. There are two tables in the DB, one with supplier details and one with supplier rates:- SELECT SupplierID, RatesTable.* FROM SupplierTable INNER JOIN RatesTable on SupplierTable.SupplierID = RatesTable.SupplierID WHERE RatesTable.RateTypeID IN (11, 14) At the...

I am creating a report based on a single dataset in crystal report 10/.NET Webforms. As there are too many fields in the dataset to show on one A4 landscape sheet of paper I would like to be able to output the fields horizontally over two pages. It would then be possible to lay 2 printed A4...

Managed to solve the problem by setting iis to use an account with permission to view the folder and using the following code to change the thread user for the web service 'Grab the current Http context Dim context As HttpContext = HttpContext.Current 'Set up a Service Provider based on this...

At the moment the error occurs locally on the development machine. The only thing that is on another machine is the foxpro free table directory. Since the last post I have -Installed the latest version of the OLE DB drivers from the MSDN site, but to no avail. -Changed the local IIS account to...

I'm getting the following error when connecting to a visual foxpro database using a web service. The 'VFPOLEDB.1' provider is not registered on the local machine. The exact same code works fine in a windows forms application, so I know it's not an issue with the connection string. Any help...

I am using the AxSHDocVw.AxWebBrowser on a windows form and wondered if anyone knew of an easy way to read parameters from the URL passed to the control. Are there any properties that I can use or do I have to just pull out a substring from the URL. Thanks in advance for any help on this one...

I need to keep the format of the tables that do exist in the destination database since this is a new (latest version) of the database structure. I suppose what I really want to do is use the copy data only option, but skip those tables that are in the source database but not the destination...

I am trying to copy data from one database to another using a DTS package I created. All the steps in the package work until it gets to the final stage and runs the Copy SQL Server Objects module to copy data from one database to a new structure in another The problem that I am having is that...