• Select last 3 transactions

    Hello Can someone help me to put together an SQL statement to select the last 3 transactions from a transaction file. In TransactSQL I would do something like this: select top 3 CustID, TransDate, Amount from Trans where CustID= '12345' order by TransDate desc. I believe there must be a more...

    SuhelAC0 pointsBadges:
  • How to create blocks in SPSS

    I have a data file with 12,00 trial inputs. When I run my descriptives, I want to combine every 100 trials together as 1 block so instead of comparing 12,00 trials, I am looking at 120 blocks and comparing those. Is there anyway to do this without first going through and running the statistics on...

    Audreye5 pointsBadges:
  • Crystal report

    I just started a job as a data analyst and wanted to see if any want can help me build a report on crystal report. Claims billed by month Claims outstanding by month Monthly report showing write off ‘bad dept’ Thanks

    Mosaidi5 pointsBadges:
  • security problem

    Hello, I have small workgroup having 10 computers in my office. I do some personal work in office like using yahoo messenger, checking personal e-mails and some online banking site. But how does one of my senior knows it? I do everything lonely and securely so that nobody in the office knows it....

    BinooDas123410 pointsBadges:
  • messaging and collaboration

    What is messaging and collaboration,how does it works,how to set it up ,where can it be implemented and how

    Eduado0 pointsBadges:
  • Windows Server 2003 connection problems

    I am seeing converstions with my IIS6 server terminate after about 15 min during a download of a large file. A tcpdump shows the server is sending out a rst/ack packet (not good) followed by 20 more rst packets to the destination IP. I was able to capture the failure as it happened but I have no...

    Fullerine0 pointsBadges:
  • Define a field using a query

    I'm trying to create a date field from a numeric field and can't seem to get the syntax correct and can't find any help on line.

    Cbab10190 pointsBadges:
  • Need help for Dynamic tables

    In a normal table all the field are defined before.. For example; let's say that we have a Cars Table, it probably will be like this: TABLE_CARS CAR_CODE BRAND MODEL VERSION SPEED COLOR GEAR_TYPE PRICE In such a table a single row contains all the data for a single car, so by querying any field of...

    DetayMan5 pointsBadges:
  • Updating one record with a field of another record where two other fields match

    I have the following Table: XREF Group Projid id1 id2 ----- -------- ----- ----------- AEEC SOCAL 71 442760 CAG AWPE 71 442780 CAG MONDPL 71 447585 CAG PLANDI 71 442780 CAG SMCECA 71 442780 CAG AWPE 84 442781 CAG MONDPL 84 447588 AEEC MONDP 84 447589 CAG PLANDI 98 288923 CAG SMCECA 98 288923 CAG...

    Donnewbee0 pointsBadges:
  • RUN TIME ERROR 339

    I have an application written in Visual Basic. The application runs on windows XP system with oracle 8i and Crystal report 8.5 The application suppose to interface with an oracle 8i database. In attempt to run the application it gives this error: 'Run-Time Error 339 component 'CRYSTL32.OCX' or one...

    IdongesitDaniel5 pointsBadges:
  • Mail sending error in certain domains through excahnge server 2003

    Hi all Recently I have installed exchange server2003, and configured outside email also its working fine, I can send and receive mails form yahoo, hotmail, gmail, but some domain I can not send but I can receive mails from these domains. I am getting following error message Your message did not...

    Management0 pointsBadges:
  • MS SQL Server 2000

    Hi All, Can we connect remotely (from outside LAN) to a MS SQL server 2000 using enterprise manager? If so, what are the steps?

    Sudh2k0 pointsBadges:
  • can strqmqry be run as remote command

    I am trying to run strqmqry via a dos/cmd ftp session. command: QUOTE RCMD STRQMQRY QMQRY(lib/qry) ... where ... are other options I followed various instructions posted here and on as400 tech sites on how to create the query. I was able to do all of that via a dos/cmd ftp session (except for...

    Bdatadigger0 pointsBadges:
  • OPNQRYF’s MAPFLD

    I am trying to create an OPNQRYF and use MAPFLD. I need to place conitionally one of two fields into ALPHANAME, I defined in MAPFLD. These fields are conditionally placed as follows: LNAME ===> ALPHANAME if LNAME is filled. BUS_NAME==> ALPHANAME if LNAME is blank APHANAME is defined this way...

    JohndeCoville0 pointsBadges:
  • Document scanning and organizing

    Does anyone know of an open source/cheap document management system? (Windows-based system) I would like the ability to have a searchable database of scanned documents/photos/receipts/etc. I do not need OCR. For example, a folder name "Job1" that I can click on and see subfolders of...

    Skepticals0 pointsBadges:
  • Data migration strategies-2

    Hi All I am embarking on a Data Migration project which involves migrating data from one I-Series database application to a different I-series database application. I guess as with all migrations the data does not excatly match in both appplications. I have identified that i need to populate Excel...

    Hazermark0 pointsBadges:
  • terminal server and gpo

    i have a server 2003 that configure as a terminal server, and i want implement a strict acess to this server from client (xp pro) to that server, i create ou that called "for terminal users" and create for that ou a gpo, now,, i want to know how should i change the gpo to achive the next goals: 1....

    Drorbeny0 pointsBadges:
  • Cannot copy from CD…

    Does anyone have insight into why when I upgraded the hard drive and restored a system, all the restore CDs work except for the MS Works application. I thought maybe the CD was damaged but I was able to copy the data to a different system. So, I bought a copy of MS Office 2003 and that CD doesn't...

    DboiSOBE0 pointsBadges:
  • Problem calculating something in Excel

    The production goal for a quarter is 1.474 now if they meet that goal they get 100% of the bonus but if their number is 1.54844 then they get 180% of the bonus and if their number is 1.43036 they only get 50% of the bonus. so if their number is 1.52 they should get approx. 170 % of the bonus....

    Imazing0 pointsBadges:
  • Can’t login as Administrator

    Hello Everybody, I can't login to adminstrator profile in my standalone win 2000 adv server. I use this system for my study purposes. What happened actually is when I was shuting my system, it got powered off because of some UPS problem and the next time when I logged in using Administrator, it...

    BinooDas123410 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following