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: *

  1. whitestorm

    teradata insert command issue

    Are there only 5 fields in SSI_Calls2care? If yes,Try this: Insert into BI_DW.SSI_Calls2care select dim_device_id ,date_yyyymm ,sum(call_cnt)...
  2. whitestorm

    Adding the results of 2 results sets

    FYR. SELECT SUM(C1) FROM (--1st select stmt SELECT SUM(balance) c1 FROM table1 WHERE date='2008-11-30' AND arrears='5 Days' UNION ALL --2nd select stmt SELECT SUM(balance) c1 FROM table2 WHERE date='2008-11-30' AND section='Retail_outlet' AND arrears='10 Days') T;
  3. whitestorm

    SELECT UPDATE QUERY HELP

    FYR. UPDATE B FROM TNATDATA.FACT_HR_ASCPAYINFO A, TNATDATA.CYBPRCU01 B SET SHOP_NBR = A.HOME_SHOP_NBR WHERE A.EMP_NBR = B.PAYROLL_NBR AND A.WK_END_DATE = '2007-03-17'
  4. whitestorm

    Two samplings in one Macro

    You mistook the SQLs which I posted. I tried to insert into ttemp.t1 which is 'MULTISET' and no matter SET or MULTISET ttemp.t2 is, the answer will always be: 2 2 which means that the fisrt sampling in the macro DOES NOT work. The STRANGEST thing is that the inserted rows of 'exec...
  5. whitestorm

    Two samplings in one Macro

    I knew that and I think it is not correct! Because, the table which I inserted is "MULTISET". The STRANGEST thing is that the inserted rows of 'exec ttemp.test_mac' in "RELEASE V2R.05.00.02.03,VERSION 05.00.02.06" are 2 rows, but in "RELEASE V2R.05.00.00.11 VERSION 05.00.00.11" are 3 rows.
  6. whitestorm

    Two samplings in one Macro

    Dear All, When I created a macro (see below, ttemp.test_mac, DB Version: "RELEASE V2R.05.00.02.03,VERSION 05.00.02.06") and ran this macro, a strange thing happened! The inserted rows of "exec ttemp.test_mac" ARE "2", NOT "3"!! AND, There is only one "SAMPLING" in the EXPLANATION. Does...

Part and Inventory Search

Back
Top