How about select distinct(symbol), min(price) from Order group by symbol

Database FAQ

I hope this isn't a repost:~ http://www.w3schools.com/downloadwww.htm[^]

Database FAQ

Have a look at http://www.hostingphpbb.com/forum/viewtopic.php?t=15&mforum=databasefaq[^]

Database FAQ

I've written an article about XPs (http://www.codeproject.com/database/extended_sp.asp[^]). You may find this helpful.

Database FAQ

Excellent..:laugh::laugh::laugh:

Database FAQ

I've never seen it do that before. Is it a big table? Does it have the relevant indexes on it?

Database FAQ

As far as TSQL is concerned, an XP is the same as a normal SP. If you can execute SPs using this method (I don't see why you can't), then you should be able to execute XPs also.

Database FAQ

Have a look at the Application.ExecutablePath property.

Database FAQ

Its not a bug, the current working directory has been changed by the file open dialog so the current working directory is no longer that of your application hence you can't see the database. You need to give the full path to your database. You should be able to get the path of your exe, and then append the database name on to the end of it, so wherever you app is installed it will always work.

Database FAQ

I've seen a similar thing when using Names Pipes if you don't have sufficient authentication to connect to the server. Are you using names pipes? If so, try changing to TCP/IP and see if the problem goes away. If it does, then its a security issue.

Database FAQ

If you're ever going to have more than one user acces your database, then you have to use AutoNumber. Max+1 could potentially give problems if two people (or processes) inserted into the datbase at the same time.

Database FAQ

I like Thunderbird, but I do find that it doesn't get rid of that much spam. In my case it probably gets rid of 70%. Is that good? I was expecting it to be higher.

Database FAQ

Does this link help? http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForSQLServer[^]

Database FAQ

If you have more than one instance, you need to specify the machine and instance name to connect. i.e. instead of connecting to "server_name", you would connect to "server_name\instance_name".

Database FAQ

You need to use a two phase commit mechanism. What database are you using?

Database FAQ

Have a look at the following: Inserting/retrieving files into a database

Database FAQ

Always read the data into a Byte[] rather than a Char[] and it will work for both binary and text files. You shouldn't really need to read it into a char[].

Database FAQ

psvSource needs to be set to a DSN that you have registered in ODBC administrator. If you haven't specified one, that is probablky why you can't connect.

Database FAQ

That looks OK. What is psvSource set to?

Affordable and reliable hosting? Click here!

I don't know why a FileStream wouldn't work for text data but would for binary. Can you post your code that doesn't work so we can have a look?

Affordable and reliable hosting? Click here!