Here's a sample way to normalize your structure:

CREATE TABLE ArticleType 

(

  Code CHAR(2) NOT NULL

, Description VARCHAR(100) NOT NULL

)

CREATE TABLE Article...

This link should be a great headstart:

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

Also check out the white paper on transaction control performance comparison in the same area...

HTH,

Jay

Remember quotes and put date in a proper date format with a day included:

SELECT a.site_id,a.RegisterDate

from cdh_slt a 

where a.RegisterDate between '03/01/1992' and '12/31/1994'

order by a.RegisterDate 

...

Completely agree with joshcsmith13: his suggestion will be much more maintainable... 🙂

try:

CHECK((Field1 IN ('C', 'X', 'R')) Or (

Field1 = 'B' AND Field2 <> 0000))

Another possible solution:

SELECT   l.[date],  l.contractornum   FROM logs l LEFT JOIN missing_logs m where l.[date] = m.[date] and l.contractornum = m.[ID Number]

WHERE...

On a personalization note, it might be nice to be able to specify which forums you would like to see displayed in the Active Threads section. That way, if...

If you post the ASP code, we could have a look for errors/suggestions...

Thanks

AFAIK, you need to get the ODBC Driver for Progress 9.x or greater. I don't think there is a download anywhere; you have to buy it... Set up...

As always in our wonderful world of programming, ... it depends 🙂

This is an EXCELLENT resource article that will address many of your questions:

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

Edited by - jpipes on 03/14/2003 ...