I am sorry did not posted properly,I want to find out the last position of following paragraph

(1)-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

(2)-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

(3)-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

-SOMETHING-SOMETHING-SOMETHING

(4)-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

(5)-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

Thanks

It is working fine the example you gave but not on my data.

My data looks like the following

SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

(1)-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

(2)-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

(3)-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

-SOMETHING-SOMETHING-SOMETHING

(4)-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

(5)-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

--------------------------------------------------------------------------------------------------

-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

(1)-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

(2)-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

(3)-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

-SOMETHING-SOMETHING-SOMETHING

(4)-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

(5)-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

--------------------------------------------------------------------------------------------------

-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

(1)-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

(2)-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

(3)-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

-SOMETHING-SOMETHING-SOMETHING

(4)-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

(5)-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

--------------------------------------------------------------------------------------------------

-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

(1)-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

(2)-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

(3)-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

-SOMETHING-SOMETHING-SOMETHING

(4)-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

(5)-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING-SOMETHING

I need to find out the last occurrence of last (1)%(5), Any ideas...

TEXT type

Hi Eletuw,

Copy data to temp table before do BCP.

did you modify tnsora file on client machine?.

open cmd promt

type tnsping

post the result.

Try This

UPDATE Claims

SET injuryStatusid = 4

FROM claims clm,(SELECT clm.claimID

INTO #tbl_temp_claims

FROM claims clm

INNER JOIN tblpayments p ON (p.claimid = clm.claimID)

WHERE (clm.addeddate < @todaysDate)

AND (clm.settle_date < @todaysDate OR clm.settle_date...

Phil, Ans to your question

For the import from A to B, do you have any transformations, or is it a straight Datapump from one table to the other?

Nothing just table...

I am using 'Other (ODBC Data Source)'

So is there any way to copy objects from non sql server database to sql server database by program.

Thanks

Can i do some thing like this?.

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

CREATE PROCEDURE EXPORT_IMPORT_DATA(@direction CHAR(20))

AS

DECLARE @Table_Name CHAR(100)

DECLARE @sql CHAR(200)

...

One DTS package.

Yes all 25 tables importing in DTS, DBMS on A is informix.

Hi cmore,

Q.What is the number and size of the rows you are dealing with? Just a general idea would give me a better feel for how much of the time...

sp_change_users_login 'Auto_fix',your user name, NULL

Phill,

I can't export the data to flat files because server A is not a SQL box and also i have onlyaccess through DSN.

And Server B and Server C are on...