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 =...

Marios Philippopoulos (11/19/2008)

Service Broker won't help you with this...

First of all,...

Hopefully the following test code will help you figure out what you need:

create table #MyTest (

Number int,

Code char(4),

...

Not sure what you are talking about here. You never did answer my question or...