Database

CodingLover wrote:

Thanks a lot. It works fine as I expected

CodingLover wrote:

Could you have any articles written by your related to views?

Mika Wendelius wrote:

Good idea, perhaps someday I'll contribute an article touching this subject.

I appreciate your help all the time...
CodingLover

select * 
from lead_free_certs
join (
  SELECT TOP 1 * 
  FROM [Order Status] 
  WHERE OrderStatusID > " & CurrentRecordID & " 
  ORDER BY OrderStatusID
) t on (CAST(t.[Project #] AS nvarchar(255)) = Lead_Free_Certs.[Project Num]) 

SELECT TOP 1 * FROM [Order Status] WHERE OrderStatusID > " & CurrentRecordID & " ORDER BY OrderStatusID JOIN (SELECT * FROM Lead_Free_Certs) t ON t.[Project Num] = CAST([Order Status].[Project #] AS nvarchar(255))

CREATE TABLE #Money
(ID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED,
 Date DATETIME,
 Amount INT,)

SET IDENTITY_INSERT #Money ON
INSERT INTO #Money(ID,Date,Amount)
SELECT '1', ' 2/10/2010 ','12' UNION ALL
SELECT '2', ' 2/11/2010 ','13' UNION ALL
SELECT '3', ' 2/12/2010 ','14' UNION ALL
SELECT '4', ' 2/13/2010 ','15' UNION ALL

SELECT SUM(AMOUNT) FROM #Money