Forum Replies Created

Viewing 15 posts - 1,216 through 1,230 (of 3,061 total)

  • RE: assignment from boss is to take out hard coded colulumn values out of query. Not 100% sure how to do that

    steveb. (1/18/2011)


    even if you went with stored procedures you will still have to 'hard-code' the values somewhere. to me the opposite of hard-coding is to put the values...

  • RE: Books

    GSquared (1/20/2011)


    What I always recommend is, write down a list of questions you need answered about SQL Server, take the list to a bookstore, pull a stack of SQL books...

  • RE: Query or View

    blackwell (1/23/2011)


    I'm just getting started using MSS and wanted to know what exactly is the difference between a query and a view?

    A view is nothing but a catalogued query you...

  • RE: Error single row sub query returns more than one column.

    single row sub query returns more than one column

    mmmhhh... I think message says "more than one row", isn't it?

    If that's the case, that's exaclty what it is happening -...

  • RE: Help an Oracle newbie out

    Resender (1/20/2011)


    OK in the past 72 hours I had 2 major successes involving oracle 11g

    1)Working Oracle 11g R2 Enterprise on a SUSE Linux 11 SP1

    2)Using SSIS to pump data from...

  • RE: Help an Oracle newbie out

    Gianluca Sartori (1/13/2011)


    ... SQL*Plus is the only tool to perform lots of tasks. Command line tools???? Come on, we're in 2011!!!

    Let me start by saying that every single point you...

  • RE: Help me understand this

    varunkum (1/13/2011)


    DECODE(addr.pk_dynreport.f_chk_omit('ccard_auto_renew'),'Y', NULL, circ.subs_bill_util.ccard_status(account))

    Guyz someone please hep me understand this sql above. I know the decode statement and addr&circ are databases. When i did

    select * from addr.pk_dynreport.f_chk_omit

    it said sql...

  • RE: Does database desingning means normalization? How much weightage goes for it in DB Design?

    David Portas (1/12/2011)


    PaulB-TheOneAndOnly (12/27/2010)


    sawantpl@gmail.com (12/27/2010)


    3- Different definitions of 1NF, 2NF and 3NF in different documents? really? I know there are good and bad documents in the net but failing to...

  • RE: Help an Oracle newbie out

    Gianluca Sartori (1/10/2011)


    Lynn Pettis (1/8/2011)


    I am enjoying the opportunity to learn Oracle, but the more I work with it the more I'd like to come back to SQL Server.

    Agreed. Fortunately...

  • RE: Help an Oracle newbie out

    Lynn Pettis (1/8/2011)


    I have found many simularities between the two (SQL Server and Oracle) but also many differences.

    This is because of these are two independent, totally different implementations of the...

  • RE: Dates

    Building on Danilo's answer - please remember SYSDATE() returns the date down to the "second" therefore if you want whole dates you have to truncate the date by including TRUNC()...

  • RE: creating dimention table and fact tables

    veena.jokhakar (1/8/2011)


    I want to creat a cube, i have goe through the business intelligence, but have still not understood when we slect the DSV data souse view, we select the...

  • RE: Help an Oracle newbie out

    Resender (1/7/2011)


    The laptop has 3.8 GB of workable RAM, I configured the EXAMPLE(orlc) database to ma manual, I replaced the one I intend to use for testing and exercises with...

  • RE: Help an Oracle newbie out

    Resender (1/7/2011)


    today i spend trying to figure out why the laptop i'm working on slowed down seriously in the past 24 hours

    the best answer i can think off atm is...

  • RE: Help an Oracle newbie out

    Resender (1/5/2011)


    One of the things i'm currently stuck at is savepoints

    i create one

    create savepoint a1;

    but if i want to rollback to it i'm getting the ora-01086 saying its not established...

Viewing 15 posts - 1,216 through 1,230 (of 3,061 total)