..............................
.....................................

        <asp:SqlDataSource 
            ID="SDS1" 
            runat="server" 
            ConnectionString="<%$ ConnectionStrings:CSDFW %>" 
            SelectCommand=
"
DECLARE @P01 datetime
SET @P01 = @PTX1 
DECLARE @P02 datetime
SET @P02 = CASE WHEN @P01 = '01/01/2090' THEN (SELECT Max(TP.TPInP) FROM TP) ELSE @P01 END
DECLARE @P03 nvarchar(8)
SET @P03 = CAST(YEAR(@P02) AS nvarchar) + RIGHT(('0' + CAST(MONTH(@P02) AS nvarchar)),2) + RIGHT(('0' + CAST(DAY(@P02) AS nvarchar)),2)
;

WITH 
Z01 AS (
SELECT DISTINCT 
RIGHT('0' + CAST(DAY(TPInP) AS nvarchar), 2) + N'/' + RIGHT('0' + CAST(MONTH(TPInP) AS nvarchar), 2) + N'/' + CAST(YEAR(TPInP) AS nvarchar) AS C01, 
DATENAME(dw, TPInP) AS C02, 
'' AS C03, 
'' AS C04, 
NULL AS C05, 
'' AS C06, 
'' AS C07, 
NULL AS R01, 
CAST(YEAR(TPInP) AS nvarchar) + RIGHT('0' + CAST(MONTH(TPInP) AS nvarchar), 2) + RIGHT('0' + CAST(DAY(TPInP) AS nvarchar), 2) AS O01, 
NULL AS O02, 
'a' AS O03
FROM         
dbo.TP
WHERE 
CAST(YEAR(TPInP) AS nvarchar) + RIGHT('0' + CAST(MONTH(TPInP) AS nvarchar), 2) + RIGHT('0' + CAST(DAY(TPInP) AS nvarchar), 2) >= @P03
),

Z02 AS (
SELECT TOP (100) PERCENT 
dbo.TN.TNome AS C01, 
RIGHT('0' + CAST({ fn HOUR(dbo.TP.TPInP) } AS nvarchar), 2) + '.' + RIGHT('0' + CAST({ fn MINUTE(dbo.TP.TPInP) } AS nvarchar), 2) AS C02, 
dbo.TP.TPInO AS C03, 
RIGHT('0' + CAST({ fn HOUR(dbo.TP.TPUsP) } AS nvarchar), 2) + '.' + RIGHT('0' + CAST({ fn MINUTE(dbo.TP.TPUsP) } AS nvarchar), 2) AS C04, 
dbo.TP.TPPa / 3600 AS C05, 
dbo.TP.TPUsO AS C06, 
dbo.TP.TPNot AS C07, 
dbo.TP.TPId AS R01, 
CAST(YEAR(dbo.TP.TPInP) AS nvarchar) + RIGHT('0' + CAST(MONTH(dbo.TP.TPInP) AS nvarchar), 2) + RIGHT('0' + CAST(DAY(dbo.TP.TPInP) AS nvarchar), 2) AS O01, 
dbo.TP.TPTNId AS O02, 
'b' AS O03
FROM         
dbo.TP 
INNER JOIN
dbo.TN 
ON 
dbo.TP.TPTNId = dbo.TN.TNId 
WHERE 
CAST(YEAR(TPInP) AS nvarchar) + RIGHT('0' + CAST(MONTH(TPInP) AS nvarchar), 2) + RIGHT('0' + CAST(DAY(TPInP) AS nvarchar), 2) >= @P03
),

Z03 AS (
SELECT     
'' AS C01, 
dbo.Sc.ScOr AS C02, 
CAST(dbo.SD.SDAlleQ AS nvarchar) AS C03, 
'' AS C04, 
NULL AS C05, 
dbo.Sc.ScDesc AS C06, 
'' AS C07, 
dbo.Sc.ScId AS R01, 
CAST(YEAR(dbo.TP.TPInP) AS nvarchar) + RIGHT('0' + CAST(MONTH(dbo.TP.TPInP) AS nvarchar), 2) + RIGHT('0' + CAST(DAY(dbo.TP.TPInP) AS nvarchar), 2) AS O01, 
dbo.TP.TPTNId AS O02, 
'c' AS O03
FROM         
dbo.Sc 
INNER JOIN
dbo.SD 
ON 
dbo.Sc.ScId = dbo.SD.SDSc 
INNER JOIN
dbo.TP 
ON 
dbo.SD.SDTP = dbo.TP.TPId
WHERE 
CAST(YEAR(TPInP) AS nvarchar) + RIGHT('0' + CAST(MONTH(TPInP) AS nvarchar), 2) + RIGHT('0' + CAST(DAY(TPInP) AS nvarchar), 2) >= @P03
),

Z06 AS (
SELECT Z01.C01, Z01.C02, Z01.C03, Z01.C04, Z01.C05, Z01.C06, Z01.C07, Z01.R01, Z01.O01, Z01.O02, Z01.O03 FROM Z01
UNION ALL
SELECT Z02.C01, Z02.C02, Z02.C03, Z02.C04, Z02.C05, Z02.C06, Z02.C07, Z02.R01, Z02.O01, Z02.O02, Z02.O03 FROM Z02
UNION ALL
SELECT Z03.C01, Z03.C02, Z03.C03, Z03.C04, Z03.C05, Z03.C06, Z03.C07, Z03.R01, Z03.O01, Z03.O02, Z03.O03 FROM Z03
)

SELECT TOP (100) PERCENT 
C01, C02, C03, C04, C05, C06, C07, R01, O01, O02, O03
FROM Z06
ORDER BY O01, O02, O03
">

            <SelectParameters>
                <asp:ControlParameter ControlID="TX1" Name="PTX1" PropertyName="Text" Type="DateTime" DefaultValue="01/01/2090" />
            </SelectParameters>

        </asp:SqlDataSource>

................................................
..........................