Let's ask a different question first. Are the dates you are using supposed to be the last day of every month?

What do you expect? You posted your problem in a SQL Server 2005 forum, you are going...

Which table is getting locked and scanned?

If you notice, the column you are commenting out is from the second table of your join.

Curious, and others may have a similiar problem, but what was done to resolve the problem?

In your original post, you indicated you are trying to do this on SQL Server 2000, correct?

xp_cmdshell does not need to be configured on SQL Server 2000. That change...

Visual studio works gret, if you have the Professional Version or greater. Standard Edition doesn't do it.

Double Posted. Please put all answers at the following forum:

http://www.sqlservercentral.com/Forums/Topic606008-146-1.aspx

Please avoid double posting. Most contributors watch all the forums, so doing so is not necessary.

What white space?????

This is the table you provided:

CREATE TABLE [dbo].[controlcloro](

[idcontrol] [int] IDENTITY(1,1) NOT NULL,

[fechahora] [datetime] NOT...

No cursor is needed. This is a variation on the running total problem.

Read this article, it may help you figure out this problem, and if not ask for more...

:unsure: What could be simplier? If you need to join multiple tables together, you have to use joins of some time...

Books Online should be able to answer all your questions about the fixed server and database roles.

Double posted. See this thread for more info: http://www.sqlservercentral.com/Forums/Topic605904-169-1.aspx

Please refrain from posting the same question in multiple forums. Most contributors watch all the forums.

Does this help you?

create table dbo.Table1 (

table1ID int primary key,

table1Data1 varchar(10),

table1Data2 varchar(10) null

)

create table dbo.Table2 (

...

raym (11/20/2008)CREATE TABLE dbo.tbComm_CurrentMonth(

LoanRefVARCHAR(20)NULL,

First_Perend_DateINTNULL,

BranchCHAR(5)NULL,

BalanceNUMERIC(13, 2)NOT NULL,

EvenInstalmentNUMERIC(13, 2)NOT NULL,

Jul08AMTNUMERIC(13, 2)NULL,

Jun08AMTNUMERIC(13, 2)NULL,

May08AMTNUMERIC(13, 2)NULL,

ProductCodeCHAR(1)NULL,

DescriptionVARCHAR(100)NULL,

Missed_InstalmentDECIMAL(18, 3)NULL,

Miss_Payment_FlagSMALLINTNULL,

threemonthmovingavgDECIMAL(13, 3)NULL,

RundateDATETIMENULL

)

DECLARE @sql VARCHAR(8000),@Col1 VARCHAR(10),@Col2 VARCHAR(10),@Col3 VARCHAR(10

)

SELECT @Col1 = COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME =...