[ create a new paste ] login | about

Link: http://codepad.org/jREAd5EM    [ raw code | fork ]

Plain Text, pasted on Jun 2:
SELECT 
    [Extent1].[Id] AS [Id], 
    [Extent1].[Nome] AS [Nome], 
    [Extent1].[Data] AS [Data]
    FROM [dbo].[tbDatas] AS [Extent1]
    WHERE  EXISTS (SELECT 
        1 AS [C1]
        FROM  (SELECT 
            [UnionAll8].[C1] AS [C1]
            FROM  (SELECT 
                [UnionAll7].[C1] AS [C1]
                FROM  (SELECT 
                    [UnionAll6].[C1] AS [C1]
                    FROM  (SELECT 
                        [UnionAll5].[C1] AS [C1]
                        FROM  (SELECT 
                            [UnionAll4].[C1] AS [C1]
                            FROM  (SELECT 
                                [UnionAll3].[C1] AS [C1]
                                FROM  (SELECT 
                                    [UnionAll2].[C1] AS [C1]
                                    FROM  (SELECT 
                                        [UnionAll1].[C1] AS [C1]
                                        FROM  (SELECT 
                                            1 AS [C1]
                                            FROM  ( SELECT 1 AS X ) AS [SingleRowTable1]
                                        UNION ALL
                                            SELECT 
                                            2 AS [C1]
                                            FROM  ( SELECT 1 AS X ) AS [SingleRowTable2]) AS [UnionAll1]
                                    UNION ALL
                                        SELECT 
                                        3 AS [C1]
                                        FROM  ( SELECT 1 AS X ) AS [SingleRowTable3]) AS [UnionAll2]
                                UNION ALL
                                    SELECT 
                                    4 AS [C1]
                                    FROM  ( SELECT 1 AS X ) AS [SingleRowTable4]) AS [UnionAll3]
                            UNION ALL
                                SELECT 
                                5 AS [C1]
                                FROM  ( SELECT 1 AS X ) AS [SingleRowTable5]) AS [UnionAll4]
                        UNION ALL
                            SELECT 
                            6 AS [C1]
                            FROM  ( SELECT 1 AS X ) AS [SingleRowTable6]) AS [UnionAll5]
                    UNION ALL
                        SELECT 
                        7 AS [C1]
                        FROM  ( SELECT 1 AS X ) AS [SingleRowTable7]) AS [UnionAll6]
                UNION ALL
                    SELECT 
                    8 AS [C1]
                    FROM  ( SELECT 1 AS X ) AS [SingleRowTable8]) AS [UnionAll7]
            UNION ALL
                SELECT 
                9 AS [C1]
                FROM  ( SELECT 1 AS X ) AS [SingleRowTable9]) AS [UnionAll8]
        UNION ALL
            SELECT 
            10 AS [C1]
            FROM  ( SELECT 1 AS X ) AS [SingleRowTable10]) AS [UnionAll9]
        WHERE [UnionAll9].[C1] = [Extent1].[Id]
    )}


Create a new paste based on this one


Comments: