Database

Select count(*) from tbl_Sz where Sz='NUG(4'''')'

SELECT PersonId, Firstname  
FROM #person  
WHERE  
PersonId IN ( 
    SELECT PersonId 
    FROM #member 
    GROUP BY PersonId 
    HAVING COUNT(*) = (SELECT COUNT(*) FROM #team) 
  ) 

PRINT GETDATE()
--|OUTPUT:
--|Jul  4 2008  9:45AM
PRINT CONVERT(NVARCHAR, GETDATE(), 121)
--|OUTPUT:
--|2008-07-04 09:45:45.477
PRINT CONVERT(NVARCHAR(10), GETDATE(), 121)
--|OUTPUT:
--|2008-07-04
PRINT CONVERT(NVARCHAR, GETDATE(), 112)
--|OUTPUT:
--|20080704

dlarkin77 wrote:

go about writing the SQL Select statement?

SELECT     OD.ProductCode, O.DeliveryDate, CASE WHEN O.DeliveryDate IS NULL THEN NULL ELSE OD.Quantity END AS quantity<br />
FROM         dbo.Products P INNER JOIN<br />
                      dbo.OrderDetails OD ON P.ProductCode = OD.ProductCode LEFT OUTER JOIN<br />
                      dbo.Orders O ON OD.ID = O.ID AND O.AccountNumber = 1234

<br />
SELECT     OD.ProductCode, O.DeliveryDate, CASE WHEN O.DeliveryDate IS NULL THEN NULL ELSE OD.Quantity END AS quantity<br />
FROM         dbo.Products P INNER JOIN<br />
                      dbo.OrderDetails OD ON P.ProductCode = OD.ProductCode LEFT OUTER JOIN<br />
                      dbo.Orders O ON OD.ID = O.ID AND O.AccountNumber = 6789

CREATE TRIGGER dbo.insertNum
ON testIcreTrigger  
INSTEAD OF INSERT 
AS
BEGIN
  INSERT INTO testIcreTrigger (Num)
  SELECT MAX(Num)+1 FROM hitTheatre
END