Database

declare @stuff xml
set @stuff = '<xml><thing>Word</thing></xml>'
select @stuff.value('/xml[1]', 'varchar(20)')

    DECLARE curMasterGames CURSOR FOR
    SELECT MasterGameID FROM MasterGames
 
    OPEN curMasterGames
    DECLARE @GameID bigint
 
    -- Prime the pump.
    FETCH NEXT FROM curMasterGames INTO @GameID
    -- Check to see if the FETCH failed on the first record BEFORE we try
    -- to do any processing on that records data.
    WHILE @@FETCH_STATUS = 0
        BEGIN
            -- It seems the FETCH worked, do something with it.
            EXEC UpdatePlayerScoresOnMasterGameID @GameID
            -- Get the next record.
            FETCH NEXT FROM curMasterGames INTO @GameID
        END
    CLOSE curMasterGames
    DEALLOCATE curMasterGames
 
    -- Do the same exact pattern for the next cursor you open.
    -- Prime, test for failure, then process your loop.

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"""

    "HDR=Yes;" indicates that the first row contains columnnames, not data
    "IMEX=1;" tells the driver to always read "intermixed" data columns as text
    TIP! SQL syntax: "SELECT * FROM [sheet1$]" - i.e. worksheet name followed by a "$" and wrapped in "[" "]" brackets.

toxcct wrote:

it is simply not a good thing to place spaces inside identifier names...

consider revising your schema.