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 dencom 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: Ericordina
  • Content: Threads
  • Order by date
  1. Ericordina

    DTS error DATA pump WRONG POINTER

    Hello, I'm trying to create a DTS statement wich must transfer records from DATABASE1.TABEL1 to DATABASE2.TABELTEMP. Select Distinct ID ID2 getdate () as 'DATE' from TABEL1 where not exists (select id,id2 from DATABASE2.user.TABELTEMP)...
  2. Ericordina

    Creating % ON SUBTOTAL

    Hello, I become mutch better with webfocus. And right now i have an report wich have have 2 hold files to combine 2 statements in one report. To give them an total i have used the subtotal option. However when i tried to create an compute to calculate the % than the result is not goed...
  3. Ericordina

    Getting the last 5 years automatically throug where clausile

    Hello, I'm trying to create an report in wich i can use automatically the information of the last 5 years. the field in the table is filled till 2099 and the max year must be the year eq system year. I hope someone can give me some advise to solve this greetings eric
  4. Ericordina

    count with accross

    I have also an other problem (sample from empdata) If i have an collumn salary and thats accrossed by year How is then possible to generete an formule wich can count the salary of year minus salary-1 /salary of year *100
  5. Ericordina

    COLUMN TO ROW WITH TITLE

    Hello, I'm not working for so long with webfocus and i tried to made an report with an accros by and sum The numbers are hard fields in the tabels. But how can i get the columns defined as single rows instead of columsn accrossed year. I have tried also the command OVER I hope i made it...

Part and Inventory Search

Back
Top