Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ang90
  • Content: Threads
  • Order by date
  1. ang90

    decode result

    Hello, I want to see '000.00' in a decode result. Can someone tell how to print it? I can print 999.99 but not 000.00. Its converting into 0.
  2. ang90

    full outer join

    Hello, Can someone show an example of full outer join on multiple table joins .. If I am joining 5 different tables using 4 different fields ... In my situation, I have no idea how much data is missing in various tables and so I am considering using full outer joins in all join clauses. Just...
  3. ang90

    logical model view

    Hello, I downloaded a database tool that reverse engineered the database creating logical model of the database. Its an ER diagram. The database has around 100 tables and so, the diagram won't fit in one screen. Does anyone has any idea how that diagram should be shown to someone or printed on...
  4. ang90

    day calculations

    I have a table as shown below. The table is: EmpId Week Year Day0 Day1 ..... Day14 100 20 2005 8 8 8 200 22 2003 0 0 8 300 25 2004 8 8 0 400 06 2005 0 8 8 500 08 2002 8 0 8 I am trying to select emp records as follows: EmpId, Date...
  5. ang90

    calculate sum

    Hi, I am trying to select sum of two columns in a table for each row .. The table has ID, Value1, Value2 columns. I am trying to select ID, Value1, value2, sum(value1, value2) for every row. Can someone help? Thanks.

Part and Inventory Search

Back
Top