This query JOINS tbl_Order to tbl_Agreement ON O.OrderNo = A.OrderNo AND O.Type < 3.

The FULL JOIN then adds the rows from tbl_Order and tbl_Agreement which were not included in the...

This thread may be of interest:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=349243&p=1

This is a basic outline:

Locks in SQL are only held for the duration of a transaction. If you do not define your own transactions, each command is its own transaction....

In SP2, assuming the same filter condition for the SELECT and UPDATE of table1, is it possible that new rows can be added to table1 between the time of the...

or:

SELECT P1.MAIN_CODE

     ,P1.SUB_CODE

    ,P1.[NAME]

    ,P2.INTVALUE AS Days

FROM pinf P1

    LEFT JOIN pinf P2

        ON P1.MAIN_CODE = P2.MAIN_CODE

            AND P1.SUB_CODE = P2.SUB_CODE

            AND P2.[NAME] = 'DAYS'

WHERE P1.MAIN_CODE = 'RET'

    AND P1.[NAME] <> 'ENDS'

[Edit] Sorry Sean, you had already...

In SQL2000, you need to monitor @@ERROR after each statement. With your example, in testUnique do something like:

EXEC (@strSQLExec)

RETURN(@@ERROR)

and in launchtestUnique do something like:

DECLARE @Err int

EXEC @Err =...

Maybe:

DECLARE @TenantID int

SET @TenantID = 1 -- ID for Tenant

SELECT B.*

FROM Building B

    JOIN (

            SELECT BA1.BuildingID, COUNT(*) AS MatchingAttributes

            FROM Requirements R1

                JOIN BuildingAttribute BA1

                    ON R1.AttributeID = BA1.AttributeID

                        AND R1.TenantID = @TenantID

            GROUP BY...

I would be interested in knowing how well something like the following works:

-- *** Test Data ***

CREATE TABLE #YourTable

(

    StartTime datetime NOT NULL

    ,EndTime datetime NULL

)

GO

INSERT INTO #YourTable

SELECT '20070419 08:32', NULL UNION...

SELECT *

FROM RSAccouts A

WHERE A.Level1Account = (

        SELECT A1.Level1Account

        FROM RSAccouts A1

        WHERE A1.AccountCode = '000009'

    )

Obviously you will have to join to Table1 outside of the derived table as well. Something like:

SELECT T1.*, T2.*

FROM Table1 T1

    JOIN Table2 T2

        ON T1.col1 = T2.col1

    JOIN (

            SELECT T4.col1, MAX(T4.colDate) AS...

Derived tables can be regarded as inline views so you cannot pass parameters. Something like the following should work:

SELECT T.col1, T.colDate, T.col3

FROM Table2 T

    JOIN (

            SELECT T2.col1, MAX(T2.colDate) AS maxDate

            FROM Table1...

The quick method of doing this from the command prompt is:

echo.>>YourFile.csv

You could put this in a batch file.

Maybe:

SELECT MIN(ProductCode)

FROM YourTable

WHERE ProductCode >= '12'

If you need dynamic SQL, you can insert the results into a temp table. eg:

CREATE TABLE #Multi

(

    Attribute varchar(100) NOT NULL

)

INSERT INTO #Multi

EXEC ('SELECT attribute FROM dbo.Staging WHERE CHARINDEX('','', attribute) >...

A table variable cannot be used as a parameter. (Also, it seems to be defined as @tMulti not @Multi.)

I see no point with dynamic SQL here. Why not just:

DECLARE @Multi...