what is [DelimitedSplit8K] in your sql ?

Hi Expert,

thanks for your reply but its not worked

Thanks Sir..

Its worked thanks for your help 🙂

Yes your solution was very helpful for me

Thank you Sir for helping me out in this situation

Yes its very help full for me..

Thanks all of you Sir....for helping me out in this solution

Hi Sir,

I would like to show data in additional column by substrating end date column

(20790606-20130128) ---660478 days

(20130416-20130128) --288 days

(20130128-20130128) --1 days

if end date column would be null then pls treat as 20790606

please check only fg_end_dt_key column

(20790606-20130416) ---660190

(20130416-20130128) --288

(20130128-20130128) --0

not getting proper result Sir.

I have tried.

Thanks Experts Its work !

Thanks Expert..Its working as expected 🙂

Hi Expert,

Its worked but failes for below data....when i was inserting and testing

CREATE TABLE #tmp_end_date

(ID INT,

tgs_rec_eff_dt DATE,

tgs_rec_end_dt DATE,

SEQNUM INT )

GO

insert into #tmp_end_date values(12345,'15-Mar-2012',NULL,4)

insert into #tmp_end_date values(12345,'10-Feb-2012',NULL,3)

insert into #tmp_end_date values(12345,'2-Feb-2012',NULL,2)

insert...

I have to update my end date column as like above sample example.

🙂

Hi Thanks for your reply 🙂

But its not giving me proper result.

But How can I use #tmp table?

Indexes are there on my tmp_load table.

So please suggest me the best solution....In my above sql it giving me 50125 rows

thanks for your valuable reply,but whats about my other result....