Database

SELECT CONTACT.FIRSTNAME, CONTACT.LASTNAME, CONTACT.COMPANYNAME, CONTACT.USER2, first(EMAIL.ADDRESS)
FROM dbo.CONTACT CONTACT
inner join dbo.EMAIL EMAIL on CONTACT.CONTACTID = EMAIL.CONTACTID
GROUP BY CONTACT.FIRSTNAME, CONTACT.LASTNAME, CONTACT.COMPANYNAME, CONTACT.USER2
ORDER BY CONTACT.LASTNAME DESC

SELECT TOP 1 CONTACT.FIRSTNAME, CONTACT.LASTNAME, CONTACT.COMPANYNAME, CONTACT.USER2, EMAIL.ADDRESS
FROM dbo.CONTACT CONTACT, dbo.EMAIL EMAIL
WHERE CONTACT.CONTACTID = EMAIL.CONTACTID
ORDER BY CONTACT.LASTNAME DESC

SELECT *, 
    (SELECT TOP 1 dbo.EMAIL.Address
       FROM dbo.EMAIL 
      WHERE dbo.EMAIL.ContactId = dbo.CONTACT.ContactId)
  FROM dbo.CONTACT

I are troll

SELECT     * 
FROM tblWeb_E_Catalog_Categories 
WHERE ((Active) = -1)

or

SELECT     * 
FROM tblWeb_E_Catalog_Categories 
WHERE ((Active) = TRUE)

or

SELECT     * 
FROM tblWeb_E_Catalog_Categories 
WHERE (Active = TRUE)

Ebube wrote:

i develop my application backend on ms sql 2008. but my client is using 2000

Ebube wrote:

should i script all the database object( tables, storeprocedures .e.t.c)