CREATE TABLE [dbo].[test](
    [LeadId] [nvarchar](255) NULL,
    [PgNm] [nvarchar](255) NULL,
    [Start_Date] [datetime] NULL,
    [End_Date] [datetime] NULL,
    [UsrNm] [nvarchar](255) NULL
) ON [PRIMARY]

INSERT INTO [dbo].[test]
    ...

Hi,

Actualy in #DueAmount table,

whenever the due for next month is added a new column with next month should be added.

there is...

Hi,

Thanks for the suggestions,

I just wanted to understand,how to identify the payment recieved is against which payment Due.

create table #Temp

(

lnno varchar(15),

Due...

Thanks Koen

Hi Koen,

This is really a greate article,

but according to it,I done me setting to

TypeGuessRows

ImportMixedTypes

IMEX=1

but according solution part II in this article,

I...

Thanks GilaMonster and thanks Jeff!!

Hi,

I want to create this string dyanamically,

based on the data in the table.

Ok Thanks.

Hi,

But my requirement is to insert into table from a select query conationg for "xml keyword"

Hi thanks Abu,

Is any other alternative way for this.

Hi,

On right clicking Agent Start option is gray.

i had check in services also it is showing me as running.

hi Cris and Jeff,

Actualy we had requirement upto 3 levels only.

So I done changes accordingly.

So its working for me.

Thanks...

Thanks cris!!!!

Its working as per my requirement.

Hi Koen,

I don't want all the requirement to be done by you,

I just described by whole requirement,

I...

Thanks!