Forum Replies Created

Viewing 15 posts - 34,651 through 34,665 (of 59,099 total)

  • RE: Serialising tabular and relational data.

    Phil, I have to mostly agree with djackson above. The editorial almost sounds like whining about the disparities of transmittable data formats. A "universal" data format has been...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    March 12, 2011 at 12:16 pm

    #1298029

  • RE: Serialising tabular and relational data.

    djackson 22568 (3/12/2011)

    The universities would distain such a practical task.

    Oh please, let's not involve the universities! Seriously, I am tired of the better than you attitude of American universities....

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    March 12, 2011 at 12:04 pm

    #1298027

  • RE: Fixed Length Flat File

    josetur12 (3/11/2011)

    I have a flat file with over 200 fixed length columns

    We're just guess here because we can't see your file.

    Do you have a record layout for this file and...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    March 12, 2011 at 11:07 am

    #1298021

  • RE: working and stopped time from devices logs

    Sorry, forgot to post the results...

    Device StartDateTime StopDateTime ...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    March 12, 2011 at 10:50 am

    #1298020

  • RE: working and stopped time from devices logs

    Nuno Martins (3/11/2011)

    I have a table with devices logs and I need calculate the working time and stopped time, how making in sql?

    The sample log table:

    device1 0 ...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    March 12, 2011 at 10:48 am

    #1298019

  • RE: Cursor use in Oracle

    I absolutely agree but, just like I said a year and a half ago, too many people simply give up too easily on finding a high performance set based solution....

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    March 12, 2011 at 9:21 am

    #1298013

  • RE: ISDATE difference from client and server

    Stuart Davies (3/11/2011)

    Hi,

    Can anyone help out me please.

    If I run select isdate('27/1/2011') from my local install of SQL against a server I get 1

    If I run the same query directly...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    March 12, 2011 at 9:15 am

    #1298012

  • RE: Types of Composite Keys

    My recommendation is "Try it". You may forget what you've been told but you won't forget what you've done. 😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    March 12, 2011 at 9:02 am

    #1298011

  • RE: Columns to Row?

    jason-772533 (3/12/2011)

    I'm probably just being a bit stupid and missing the point.

    Nope. You're alright, Jason. 🙂 It's a bit difficult to understand the concept when it comes to...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    March 12, 2011 at 8:57 am

    #1298010

  • RE: Correspond multiple values to a single username

    Everything is good there except I wouldn't make the delimited list for the front end. Just return a result set and consume it at the front end. I...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    March 12, 2011 at 7:38 am

    #1298006

  • RE: Group by

    Brandie Tarvin (3/11/2011)

    It wouldn't work if Roy was using some other data or delimiter

    It only takes one well place REPLACE to fix that little nuance.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    March 11, 2011 at 11:02 pm

    #1297978

  • RE: Correspond multiple values to a single username

    jashwantsingh (3/11/2011)

    Hello friends , I am newbie here.

    In my project a user can have multiple friends and I need to store friends of a each user. What I am...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    March 11, 2011 at 10:53 pm

    #1297977

  • RE: Stored procedure question

    mtillman-921105 (3/11/2011)

    Also, you should rewrite the query to use an INNER JOIN rather than the older way its using more than one table.

    There's no performance gain in it. The...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    March 11, 2011 at 10:41 pm

    #1297976

  • RE: Avoiding Logging

    Eric M Russell (3/11/2011)

    Generally speaking, transaction logging is trivial during the normal day to day operations of a OLTP database, especially if the log files are on separate storage from...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    March 11, 2011 at 5:06 pm

    #1297934

  • RE: Group by

    Lowell (3/11/2011)

    how about using the PARSENAME function to chop up the IP address?

    --using Stefan's setup:

    /*--Results

    (No column name)(No column name)

    1172.24

    322.25

    3223.25

    */

    SELECT Count(IPAddress),parsename(IPAddress,4) + '.' + parsename(IPAddress,3)

    FROM #tempIPTable

    Group By parsename(IPAddress,4) + '.' +...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    March 11, 2011 at 4:50 pm

    #1297933

Viewing 15 posts - 34,651 through 34,665 (of 59,099 total)