Андрей Ласточкин

SELECT ID, IF_TRUE Result
INTO Table3
FROM Table1
LEFT JOIN Table2
   ON (COMPARE COLLATE SQL_Latin1_General_CP1_CS_AS) LIKE '%' + PHRASE + '%'

SELECT * 
FROM Logon
JOIN 
(
SELECT [Date] D, MIN([Time]) T
FROM Logon
GROUP BY [Date]
) X
ON [Date]=D AND [Time]=T

SELECT uName, 
(
SELECT MIN(uDate) 
FROM Res 
WHERE uName = T.uName AND CAST(uDate AS Date) = D
) FirstDate
FROM 
(
SELECT DISTINCT uName, CAST(uDate AS Date) D
FROM Res
) T

...
        if (reader.Read())
        {
            Response.Write(reader["id"]);
            Response.Write(reader["level"]);
        }

        var ok = reader.NextResult(); // <---

        if( !ok ) return;

        if (reader.Read())
        {
            Response.Write(reader["lid"]);
            Response.Write(reader["sublid"]);
        }
...

update cred_zaborg 
set Suma_zaborg = kurs*Suma_zaborgVAL
from cred_zaborg 
inner join credit_rah on Credit_Rah.Credit_rah=Cred_zaborg.Credit_rah
inner join valuta  on Credit_Rah.Valuta_name=Valuta.Valuta_code

CREATE PROCEDURE usp_DropNonUsedTables @LastDateUse date
AS
BEGIN

    SET NOCOUNT ON

    DECLARE @TablesWithLastSeek AS TABLE (
        TableName varchar(100),
        LastAccessDate date
    );

    WITH LastDates
    AS (SELECT
        SCHEMA_NAME(T.schema_id) + '.' + OBJECT_NAME(T.object_id) AS TableName,
        (SELECT
            MAX(last_user_date)
        FROM (VALUES (last_user_seek), (last_user_scan), (last_user_lookup)) AS AllValues (last_user_date))
        AS AccessDate
    FROM sys.dm_db_index_usage_stats IUS
    RIGHT OUTER JOIN sys.tables T
        ON IUS.object_id = T.object_id)

    INSERT INTO @TablesWithLastSeek
        SELECT
            TableName,
            MAX(AccessDate)
        FROM LastDates
        GROUP BY TableName
        HAVING MAX(AccessDate) <= @LastDateUse

    DECLARE @TableName varchar(100)
    DECLARE @LastAccessDate date
    DECLARE @Command varchar(1000)

    DECLARE C CURSOR LOCAL FOR
    SELECT
        *
    FROM @TablesWithLastSeek

    OPEN C

    WHILE 1 = 1
    BEGIN
        FETCH C INTO @TableName, @LastAccessDate
        IF @@FETCH_STATUS != 0
            BREAK

        SET @Command = 'DROP TABLE ' + @TableName + ';'
        EXECUTE (@Command)
    END

    CLOSE C
	
END;
GO