Forum Replies Created

Viewing 15 posts - 91 through 105 (of 125 total)

  • RE: Advanced T-SQL

    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

    December 11, 2003 at 1:53 pm

    #485833

  • RE: Advanced T-SQL

    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...

    December 11, 2003 at 1:41 pm

    #485829

  • RE: Advanced T-SQL

    TEXT type

    December 11, 2003 at 9:48 am

    #485757

  • RE: Need to send result set to a file

    Hi Eletuw,

    Copy data to temp table before do BCP.

    December 9, 2003 at 2:12 pm

    #485428

  • RE: Linked server to an Oracle database

    did you modify tnsora file on client machine?.

    open cmd promt

    type tnsping

    post the result.

    December 4, 2003 at 3:20 pm

    #484715

  • RE: Help with a Select Statement

    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...

    December 3, 2003 at 11:25 am

    #484496

  • RE: Import and export data

    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...

    November 25, 2003 at 8:11 am

    #483544

  • RE: Import and export data

    I am using 'Other (ODBC Data Source)'

    November 24, 2003 at 3:59 pm

    #483466

  • RE: Import and export data

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

    Thanks

    November 24, 2003 at 9:42 am

    #483400

  • RE: Import and export data

    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)

    DECLARE tablename_cursor...

    November 21, 2003 at 8:00 am

    #483107

  • RE: Import and export data

    One DTS package.

    November 20, 2003 at 7:28 am

    #482856

  • RE: Import and export data

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

    November 19, 2003 at 4:21 pm

    #482768

  • RE: Import and export data

    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...

    November 19, 2003 at 3:15 pm

    #482758

  • RE: Reseting Logins after detach and attach

    sp_change_users_login 'Auto_fix',your user name, NULL

    November 19, 2003 at 11:05 am

    #482719

  • RE: Import and export data

    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...

    November 19, 2003 at 7:40 am

    #482638

Viewing 15 posts - 91 through 105 (of 125 total)