• my effort...too much time on my hands 😀

    DECLARE @Question VARCHAR(100) =

    'The Answer to the Ultimate Question of Life, the Universe, and Everything'

    DECLARE @Source VARCHAR(100) =

    'The Hitchhikers Guide to the Galaxy'

    DECLARE @Answer VARCHAR(10)

    SET NOCOUNT ON

    IF object_id('tempdb..#ParallelUniverse') IS NOT NULL

    DROP TABLE #ParallelUniverse

    SELECT top (len(@Source)) IDENTITY(INT, 1, 1) n

    INTO #ParallelUniverse FROM master.sys.all_columns

    SET @Answer = (select len(@Question) - (SELECT MAX(n) from

    ((SELECT n FROM #ParallelUniverse )

    EXCEPT

    (SELECT (PU1.n * PU2.n) AS cn

    FROM #ParallelUniverse AS PU1, #ParallelUniverse AS PU2

    WHERE PU1.n BETWEEN 2 AND CEILING (SQRT (1000))

    AND PU2.n BETWEEN 2 AND CEILING (SQRT (1000))

    AND PU1.n <= PU2.n

    AND (PU1.n * PU2.n) <= 1000) )x))

    PRINT @Question + ' is.. ' + @Answer

    SET NOCOUNT OFF

    /*code to find primes courtesy of J Celko in this discussion:

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/90a58cc7-dada-476a-8d27-f744c71940e6/how-to-find-whether-is-a-prime-or-non-prime-with-one-select-statement?forum=transactsql

    */

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day