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)