Does the stored prcoedure in question return a resultset ?

If yes, you have to account for network bandwidth in getting that resultset back to QA, then QA's memory requirements in...

The answer is "maybe".

It depends on type of index and data distribution. If you query on A, and there are large numbers of repeating values of A in the index,...

If it's just 1 simple process, of a single spreadsheet, you can do it all in T-SQL using OpenRowSet:

SELECT *

INTO ExcelDataCopy

FROM  OPENROWSET('Microsoft.Jet.OLEDB.4.0',

   'Excel 8.0;Database=c:\YourServerFolder\YourFile.xls', [Sheet1$])

You now have...

Does this apply to your situation >

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q276043

If the requirement is to store a version number and then to later implement processes that perform arithmetic comparisons on that number, then a varchar(200) stuffed with version descriptions like "version 1.0"...

The only issue here is the classic mistake of LEFT JOIN, but then placing a WHERE condition on the joined table, thereby implicitly forcing it back to an INNER JOIN:

FROM        ...

http://support.microsoft.com/?id=239530

What is the datatype of column mmdate, what does it contain and what is the calculation trying to achieve ?

Although having solved that, I think all those "While 1 = 1" infinite loops are going to be slightly more of a problem ...

You can't declare tables in the same declare statement as other tables/variables.

declare @id int,

  @textptr varbinary(16), @patternPtr int,

  @geoType char(30)

Declare @h1 table(SW_MEMBER int, WKT text)

Declare @h2 table(SW_MEMBER int,...

Doh. Derived table isn't generating a tru date/time datatype. Need to CAST() it:

select CAST( DATEADD(day, (DATEPART(weekday, convert(char, mmdate, 112))-2)*-1, convert(char, mmdate, 112)) As datetime)  as WeekBeginning

If I run this:

create table test

( RowID int )

go

Create trigger tr_test on test for insert as

begin

  declare @h1 table(SW_MEMBER int,WKT text)

end

... it...

You need the DECLARE keyword with @table variables:

DECLARE @h1 table (SW_MEMBER int,WKT text)

I fat fingered the delete key and dropped the 101 format code:

Select top 26 convert(varchar(10), WeekBeginning, 101) As WeekBeginning

I would use a derived table to calculate the required date, but keep it as a true date/time type.

Then outside the derived table, format/sort accordingly:

Select top 26 convert(varchar(10), WeekBeginning) As...