Skip to main content

marcelsa

marcelsa 's Public Library

22 Mar 08

Using Inner Joins

  • USE AdventureWorks;
    GO
    SELECT *
    FROM HumanResources.Employee AS e
    INNER JOIN Person.Contact AS c
    ON e.ContactID = c.ContactID
    ORDER BY c.LastName
  • USE AdventureWorks;
    GO
    SELECT DISTINCT p1.ProductSubcategoryID, p1.ListPrice
    FROM Production.Product p1
    INNER JOIN Production.Product p2
    ON p1.ProductSubcategoryID = p2.ProductSubcategoryID
    AND p1.ListPrice <> p2.ListPrice
    WHERE p1.ListPrice < $15 AND p2.ListPrice < $15
    ORDER BY ProductSubcategoryID;
  • 2 more annotations...

Using common table expressions in SQL Server 2005 queries

  • WITH cte_Employee
    AS
    (
          SELECT  e.EmployeeID, c.FirstName, c.MiddleName, c.LastName,
                  e.Title AS JobTitle, c.Phone, e.ManagerID
          FROM    HumanResources.Employee AS e
          INNER JOIN Person.Contact AS c ON c.ContactID = e.ContactID
    )
    SELECT E.FirstName + ' ' E.LastName Employee,
           M.FirstName + ' ' M.LastName Manager
    FROM    cte_Employee AS E
            LEFT OUTER JOIN cte_Employee AS M
            ON E.ManagerID = M.EmployeeID

Subquery Fundamentals

  • Subquery Fundamentals
  • SELECT Ord.SalesOrderID, Ord.OrderDate,
    (SELECT MAX(OrdDet.UnitPrice)
    FROM AdventureWorks.Sales.SalesOrderDetail AS OrdDet
    WHERE Ord.SalesOrderID = OrdDet.SalesOrderID) AS MaxUnitPrice
    FROM AdventureWorks.Sales.SalesOrderHeader AS Ord
  • 1 more annotations...

Diigo Releases Version 3 - Beyond Bookmarks

  • Web 2.0 was and is about Web innovation. So many startups have focused on everything from video to business applications, and much more. However, the list of startups that actually have practical and/or productive capabilities is still – rather limited. Diigo is one innovation that comes to mind when we think of actual utility and practical function. Diigo has continually adapted and developed into what is effectively the Web’s best research tool. Now, with their launch of Version 3, Diigo has refined a social annotation and collaboration service into an even more effective “personal and group oriented tool”.
20 Mar 08

Corrector ortográfico em PT no office 2007 - Tecnologia, Software, Tutoriais

  • Para tal é necessário ter o Microsoft Office 2003 em português e seguir os seguintes passos:

    Inserir o CD do Microsoft Office 2003 em PT e escolher “instalação personalizada”

Skilled workers and professionals: Provincial nominees

  • Persons who immigrate to Canada under the Provincial Nominee Program have
    the skills, education and work experience needed to make an immediate economic
    contribution to the province or territory that nominates them. They are
    ready to establish themselves successfully as permanent residents in Canada.
1 - 16 of 16
Showing 20 items per page

Diigo is about better ways to research, share and collaborate on information. Learn more »

Join Diigo