I agree on the processing time.  Currently we are using a design requiring numeruus temp tables and cursors to calculate the cost.  With approximately 35,000 rows in the customer table the...

Thanks Rockmoose!  Your scenario fits my situation well.

What your saying makes sense but, the cost that is being calculated involves items being bought at one price and sold at another.  Profits then need to be calculated at...

I note that the boys at Microsoft and BOL don't use alias names in their queries.  I don't either.  It only creates confusion and makes the code more criptic.

Being new...

I thought we said programmaticlly . . .

      Dim WithEvents Con As ADODB.Connection

      Private Sub Form_Load()

         Set Con = New ADODB.Connection

      End Sub

      Private Sub Form_QueryUnload(Cancel As Integer, _

        ...

Your right.  It should look like this . . .

USE NORTHWIND

SELECT * FROM Orders WHERE (OrderID = (SELECT TOP 1 OrderID FROM

Orders WHERE (OrderID < 10250) ORDER BY...

Upon giving this some thought.  In the real world, from an application point of view, we probably only know the OrderID of the current record so this seems to make...

Why does the result set from the example return Steve?

This seems fairly straight forward and returns Andy and Brian as should be expected.

SELECT TOP 2 * FROM Orders WHERE (OrderID >...

Correction . . .

If IsEmpty(alphnumbs(pos)) Then

Razvan Socol,

Yes, I agree that using the cursor is heavy and slow. 

Since this problem is a little short on business rules (it doesn't have any) and we really don't...

This is bit complex but it seems to work . . .

Create table #Temp1 (value varchar(20))

Insert into #Temp1 (value) values ('15A')

Insert into #Temp1 (value) values ('15B')

Insert into #Temp1 (value)...

Your violating the rules of normalization.  You need a third table to store each atomic value for table1_Col1 . . .

CREATE TABLE [dbo].[Table1] (

 [Col1] [int] IDENTITY (1, 1) NOT...

Ooops!  That word is accordingly

Create an ODBC database connection pointing to your Access database.  Go to Excel and use DATA | IMPORT EXTERNAL DATA | NEW DATABASE QUERY.  On the third page in the...

For starters, check the following url . . .

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag01/html/BLOB.asp

I used this and other articles I found to build a Web application for an online catalog.  The images are initially...