Thanks!!!!!!!!!!!!!!!

No,But I want it to stored as Numeric,

Please tell me is there any way to do this.

I...

Hi Koen,

Datatype of the Numeric column in SSIS is UNOCODE [DT_WSTR]

Create Table Temp2

(

channel varchar(10),

forthedatent Int,

forthedate Numeric(12,2),

forthemonthcnt Int,

forthemonth Numeric(12,2),

)

Insert Into Temp2

Values ('Others',0,0,16,1000),

('a',1,1000.00,14,1000),

('TOTAL',1,1000,30,2000)

Select * from Temp2

I cant remove the Merge columns,since this is user requirement.

Attached Herewith is excel ...

Thanks!!!!!!!!!!!!

Thanks a lot!!

No,we don't restore database through sql server agent.

we manulaly restore the database because time of recieving back ...

Hi dan

The meaning of the negative figures is,

In simple words,

if the collection 800,

we should adjust this collection against the...

Thanks!!

Hi,

Thanks for your feedback.I will sure take care of it.

This I want exactly.

Thanks !!

Hi,

I just checked that this parameters,

my requirement is fulfilled by @from_address parameter.

I have also tried @reply_to, but...

Create Table #Temp

(

Lnno Varchar(15),

Custcode varchar(10),

Flag varchar(10),

Amount Int,

Amount_Flag varchar(1)

)

Insert Into #Temp

Values ('1','A1','Cust',1000,''),

('1','A1','Cust',1000,'')

Select * from #Temp

/*

Hi,

As per my requirement it is...

As per Stefen_G,query it working expect in one case,

Create Table #Temp

(

Lnno Varchar(15),

Custcode varchar(10),

Flag varchar(10),

Amount Int,

Amount_Flag varchar(1)

)

Insert Into #Temp

Values ('1','A1','Cust',1000,''),

('1','A1','Cust',1000,'')

Select * from #Temp

/*

Hi,

...