Forum Replies Created

Viewing 15 posts - 16 through 30 (of 162 total)

  • RE: Oracle reserved words problem

    millerfw (10/31/2009)

    Recently my company moved from SQL Server 2005 to Oracle. In SQL Server certain field names like name, date and description were used. I had no problem...

    October 31, 2009 at 5:51 am

    #1073499

  • RE: SQL query

    newbieuser (10/22/2009)

    I tried this, but not sure if it is right.. it returns 267 rows though..

    SELECT Q.*, p.pmtco, p.pmtno, p.pmtbk, p.pmtrcn, p.pmtamt

    FROM qtral Q left outer join pymt p on...

    October 25, 2009 at 5:17 am

    #1070430

  • RE: Calculating the Number of Business Hours Passed Since a Point of Tme

    Jeff Moden (9/24/2009)

    I get it... you're not running the same code as in the article. Please post the code you are running. Thanks.

    You are right Jeff. The code...

    September 25, 2009 at 3:50 am

    #1058395

  • RE: Calculating the Number of Business Hours Passed Since a Point of Tme

    Jeff Moden (7/26/2009)

    If I may suggest...

    1. We don't need RBAR to do this... no WHILE loops please. :sick:

    2. We don't need 8 functions to do this... that's a lot...

    September 24, 2009 at 9:07 am

    #1058089

  • RE: equivalent for rownum

    PaulB (9/13/2009)

    Mazharuddin Ehsan (9/11/2009)

    Let us say I have a flat file containg rows of data and I want to uplaod the file to a database table with an additional column...

    September 14, 2009 at 10:07 am

    #1053316

  • RE: equivalent for rownum

    Paul White (9/11/2009)

    Cool. While you are correct that the article I referened talks about SELECT INTO, the situation with INSERT INTO is similar.

    The code INSERT INTO @Employees SELECT Emp_No...

    September 11, 2009 at 10:27 am

    #1052429

  • RE: equivalent for rownum

    Your solution there relies on IDENTITY values being assigned in the same 'order' as the query processor inserts the rows. Before SQL 2005, the assignment order was not defined even...

    September 11, 2009 at 5:01 am

    #1052183

  • RE: equivalent for rownum

    PaulB (9/10/2009)

    Mazharuddin Ehsan (9/9/2009)

    PaulB (9/9/2009)

    Please note that it doesn't work as OP expected to work in Oracle

    It is for the OP to tell us what he intends to do...

    September 10, 2009 at 11:37 am

    #1051845

  • RE: equivalent for rownum

    .

    September 10, 2009 at 11:26 am

    #1051839

  • RE: equivalent for rownum

    Bruce W Cassidy (9/9/2009)

    [font="Verdana"]In versions of SQL Server prior to 2005, I emulated it using an identity field. Since then, I use row_number(). Neither is exactly equivalent, but...

    September 10, 2009 at 11:03 am

    #1051831

  • RE: equivalent for rownum

    PaulB (9/9/2009)

    Please note that it doesn't work as OP expected to work in Oracle

    It is for the OP to tell us what he intends to do with the rownum....

    September 9, 2009 at 3:54 pm

    #1051475

  • RE: equivalent for rownum

    In this specific case OP was relying on rownum to get "ordered" rows from a table which would never happen.

    Here is one way to make it happen in SQL Server...

    September 9, 2009 at 1:02 pm

    #1051371

  • RE: Strip Non-numeric characters from string function

    It worked fine for me for the task as follows. The Phone numbers in a table in two fields as shown in the below example was required to be changed...

    August 11, 2009 at 4:26 am

    #1037309

  • RE: Data Import

    Senthil Kumar Rajendran (7/23/2009)

    I just want to import data from oracle to sql server.....

    i got an error on this... can you just me to rectify this error...

    TITLE: SQL Server Import...

    July 26, 2009 at 4:21 am

    #1030266

  • RE: Oracle for the SQL Server Guy - Instances and Databases

    Thanks Jagan for a very 'to the point' writeup. Special thanks to Rich for the valuable inputs.

    Maz

    July 3, 2009 at 9:38 am

    #1019805

Viewing 15 posts - 16 through 30 (of 162 total)