Forum Replies Created

Viewing 15 posts - 12,676 through 12,690 (of 15,381 total)

  • RE: How to convert this XML into columns

    njdevils39 (3/23/2012)


    This is the easy sample data query:

    select em.emp_name, em.emp_organization, em.emp_department, eo.rate_history

    from

    employee as em

    join

    employee_other as eo

    on

    em.emp_id = eo.emp_id

    Now rate_history column is in XML FORMAT in the employee_other table for...

  • RE: How to convert this XML into columns

    You do know that we are volunteers right??? You have not even thought about considering somebody else's ability to help you. Look at that insert you posted. I don't have...

  • RE: Variable not getting reset inside the loop

    Eugene Elutin (3/23/2012)


    ...

    Object oriented COBOL is a perfect example of what we talking about. Yes it can be done, but that does not mean it is a good idea...

    It is...

  • RE: How to convert this XML into columns

    I can imagine you are getting frustrated. If you can post ddl and sample data you will get some help. You are obviously too lazy to actually that article to...

  • RE: How to convert this XML into columns

    Start by providing us something to work with. DDL and Sample data. I can't write code for you without some tables.

  • RE: Variable not getting reset inside the loop

    Eugene Elutin (3/23/2012)


    ...

    It is a paradigm shift that is difficult for some to make, sort of like moving from 3rd generation programming languages like COBOL to object-oriented languages.

    Is it really...

  • RE: How to convert this XML into columns

    DDL, SAMPLE DATA!!! READ THE ARTICLE THAT HAS BEEN SUGGESTED OVER AND OVER!!!!! This is not rocket surgery. Pay attention and listen to what the people who are trying to...

  • RE: Tracking Data Changes

    If you are willing to share what you did I would be interested to see it.

  • RE: Variable not getting reset inside the loop

    Eugene Elutin (3/23/2012)


    Sean Lange (3/23/2012)


    Please! "Even better, don't use loops."? Why? :w00t:

    I do not agree!

    If you say that, you should say it right!

    OK, don't use loops in general. They...

  • RE: Make query Simple

    Not really sure what you mean by more simple? I can offer a quick suggestion to make it about a million time more readable. Look at using CamelCase http://en.wikipedia.org/wiki/Pascal_case.

    youcanusecamelcasetoamakealongstringofwordscrammedtogetherreadable.

    What is...

  • RE: Tracking Data Changes

    Yeah you are going to have to maintain your audit table and your trigger as you make changes to the base table. This is pretty much unavoidable if you need...

  • RE: Variable not getting reset inside the loop

    Please! "Even better, don't use loops."? Why? :w00t:

    I do not agree!

    If you say that, you should say it right!

    OK, don't use loops in general. They tend to be horribly...

  • RE: error plz solve its urgent

    There is definitely a solution to this problem. The first step in finding your solution will come to you magically when you read the first link in either my signature...

  • RE: Variable not getting reset inside the loop

    capn.hector (3/22/2012)


    Sean Lange (3/22/2012)


    capn.hector (3/22/2012)


    Sean Lange (3/22/2012)


    Even better, don't use loops. :hehe:

    i was waiting for that one. :w00t:

    Somebody had to say it...and I was kind of surprised that neither...

  • RE: Variable not getting reset inside the loop

    capn.hector (3/22/2012)


    Sean Lange (3/22/2012)


    Even better, don't use loops. :hehe:

    i was waiting for that one. :w00t:

    Somebody had to say it...and I was kind of surprised that neither Eugene nor Anthony...

Viewing 15 posts - 12,676 through 12,690 (of 15,381 total)