Database

CREATE FUNCTION dbo.fnGetTwoDates
(
   @searchCriteria varchar(30)
)
RETURNS @twoDates TABLE
   (
      FirstDate     datetime,
      SecondDate    datetime
   )
AS
   BEGIN
 
   INSERT INTO @twoDates
   SELECT
      /* Perform selection here */
   
   RETURN

   END
 
Usage:
SELECT FirstDate, SecondDate
FROM dbo.fnGetTwoDates( 'criteria' )

SELECT [ID], Title, NodeType, ParentID, [Language], Description 
FROM SourceCode 
WHERE (Title LIKE '%Title%' OR Code LIKE '%Title%') 
AND (Language = 1 OR Language = 2 OR Language = 3 OR Language = 4 OR Language = 5)
AND (NodeType = 1 OR NodeType = 2 OR NodeType = 3 OR NodeType = 4 
OR NodeType = 5 OR NodeType = 6)
AND (ParentID = 4 OR ParentID = 6)

SELECT [ID], Title, NodeType, ParentID, [Language], Description 
FROM SourceCode (nolock)
WHERE (Title LIKE '%Title%' OR Code LIKE '%Title%') 
AND Language IN (1,2,3,4,5)
AND NodeType IN (1,2,3,4,5,6)
AND ParentID IN (4,6)

Tiny problem with said member has been corrected.
Chris Maunder

Tiny problem with said member has been corrected.
Chris Maunder

Tiny problem with said member has been corrected.
Chris Maunder

SELECT DISTINCT scala_A_OR200100.FNSalesmanNo AS 'Salesman', scala_A_SYCD0100.FNCurrencyShortName AS 'Currency', scala_A_OR120100.FNOrderNumber AS 'Ordernumber', scala_A_OR120100.FNLineNumber AS 'LineNumber', scala_A_OR120100.FNStockCode AS 'StockCode', scala_A_OR120100.FNDescripLine1 AS 'DescLine1', scala_A_OR120100.FNDescripLine2 AS 'DescLine2', scala_A_OR120100.FNUnitPrice AS 'UnitPrice', scala_A_OR120100.FNQty AS 'Qty', scala_A_OR120100.FNDelDate AS 'DelDate', scala_A_OR120100.FNOrderDate AS 'OrderDate' <br />
FROM scala_A_OR200100 right outer join scala_A_OR120100 <br />
ON scala_A_OR120100.FNOrderNumber = scala_A_OR200100.FNOrderNo <br />
right outer join scala_A_SYCD0100 <br />
ON scala_A_OR120100.FNUnitCode = scala_A_SYCD0100.FNCurrencyCode <br />
WHERE scala_A_OR120100.FNCustCodeDel = '400002' <br />
ORDER BY scala_A_OR120100.FNOrderNumber Desc, <br />
scala_A_OR120100.FNLineNumber asc"