i haven't tried it yet but will try

Thanks

Shaun

Hi

You can use rownumber

Select * from (

SELECT ROW_NUMBER() over(partition by columna order by columnname <desc or asc>) Get_Rows

FROM Table_Name

) m where Get_Rows = 2

I...

the client wants to see one e-mail only either been success or failed..

thanks.. i will test it.let u know..

shaun..

so what should i do.. I am always saving the connection password but it is saved as "EncryptSensitiveWithUserKey"..

So wht should i do to make it run in the prouction..

i am still getting error.. as i moving oracle data from one source to destination. and destination columns will not accept null values..so any idea how to move data for...

thank u its working but how to do for date column..

thank you so much, it is working now..

Shaun..

i had created variable but not sure how to use it in the execute sql task query.

I had created varriable

Mydate as datetime- data type.

and i have execute task to delet...

U need to connect to the Cube datasource. To conenct the datasource go to the data tab and click on connections from u can select ur cube datasource and then...

Hi Jeff,

I never got the time to test it, got involved some other project. So as i test it i will definitely let u know!!

Thanks!!!

Hi Jeff,

Thanks for the code, but i will be test the code tommorrow @ my work and i will be able to tell you the performance of this logic with...

Hi Jeff,

Yes, i'm gonna have more than 1000 could be from 5000 to no limit.

So could you please show me the better way in sql 2008

thanks

i had tested this code in sql 2000

SELECT id,

days,

days - COALESCE((SELECT max(days)

...

hi,

it is working but will it work in sql 2008 using same function for coalesce.

thanks