SQL Server 2005 Code Error

Hey,

I need someone to look at a small piece of code and tell me where I'm going wrong in SQL 2005 Server. Where should I post?

Thanks in advance,

Danny

Problem: When I run this I'm told NoOfContractsCount is an invalid column name when I try creating my cusor

USE SLXDEV

SELECT Count(MCS2_CONTRACT.accountid) AS NoOfContractsCOUNT, MCS2_CONTRACT.accountid, CONTACTID

INTO #TempTable

FROM sysdba.MCS2_CONTRACT, CONTACT

WHERE MCS2_CONTRACT.accountid = CONTACT.accountid

GROUP BY MCS2_CONTRACT.accountid, CONTACTID

HAVING Count(MCS2_CONTRACT.accountid) > 1

DECLARE @CountTemp int

DECLARE @accountIDTemp CHAR(12)

DECLARE @ContactIDTemp CHAR(12)

DECLARE @AccountName VARCHAR(128)

DECLARE @LastName VARCHAR(32)

DECLARE @FirstName VARCHAR(32)

DECLARE @WorkPhone VARCHAR(32)

DECLARE @Fax VARCHAR(32)

DECLARE @Mobile VARCHAR(32)

DECLARE @Email VARCHAR(128)

DECLARE @Title VARCHAR(64)

DECLARE @UserField1 VARCHAR(80)

DECLARE @UserField2 VARCHAR(80)

DECLARE @UserField3 VARCHAR(80)

DECLARE searchCursor CURSOR

FOR

SELECT NoOfContractsCOUNT, accountid, ContactID

FROM #TempTable

OPEN searchCursor

FETCH NEXT FROM searchCursor INTO @CountTemp, @accountIDTemp, @ContactIDTemp

While (@@FETCH_STATUS <> -1)

BEGIN

IF (@@FETCH_STATUS <> -2)

BEGIN

PRINT 'GOT HERE'

SELECT @accountIDTemp = AccountID, -- SELECT DISTINCT?

@AccountName = Account, @LastName = LASTNAME, @FirstName = FIRSTNAME,

@WorkPhone = WORKPHONE, @Fax = FAX, @Mobile = MOBILE, @Email = EMAIL,

@Title = TITLE, @UserField1 = USERFIELD1, @UserField2 = USERFIELD2,

@UserField3 = USERFIELD3

FROM CONTACT

WHERE AccountID = @AccountIDTemp

declare @counter int

set @counter = 1

while @counter < @CountTemp

begin

INSERT INTO CONTACT(CONTACTID, ACCOUNTID, ACCOUNT,

FIRSTNAME, LASTNAME, WORKPHONE, FAX, MOBILE, EMAIL,

TITLE, USERFIELD1, USERFIELD2, USERFIELD3)

VALUES

(@ContactIDTemp, @accountIDTemp, @AccountName, @FirstName,

@LastName, @WorkPhone, @Fax, @Mobile, @Email, @Title,

@UserField1, @UserField2, @UserField3)

set @counter = @counter + 1

end

END

END

DROP TABLE #TempTable