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...
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...
0 pts.
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...
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...
datamining SQL with access
I have been asked by the sales department to datamine our SQL database and pull the names and e-mails of all our guests for the last few years for a contact list. I am new to SQL but have worked with access in the past. Using access, how do I set things up so that access will see the database...
I have been asked by the sales department to datamine our SQL database and pull the names and e-mails of all our guests for the last few years for a contact list. I am new to SQL but have worked with access in the past. Using access, how do I set things up so that access will see the database...
how to create our own set up file in vb6.0
dear friends i want to know how to create setup file of our project in vb6.0 wait i know how to create setup file using package and deployment tool but i want to know how can i create a file in which we can include images, pictures, some animations i mean setup file with our own ideas and design...
dear friends i want to know how to create setup file of our project in vb6.0 wait i know how to create setup file using package and deployment tool but i want to know how can i create a file in which we can include images, pictures, some animations i mean setup file with our own ideas and design...
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...
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...
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...
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...
Excel Spreadsheets
We developed some kind of database with excel spreadsheets to draw monthly stats for diffrent departments. It works as follows: Individual spreadsheets(formulated)feeds into a master Link spreadsheets(data) we then use Pivots for our reports. The problem that I now expierence is that: 1. The...
We developed some kind of database with excel spreadsheets to draw monthly stats for diffrent departments. It works as follows: Individual spreadsheets(formulated)feeds into a master Link spreadsheets(data) we then use Pivots for our reports. The problem that I now expierence is that: 1. The...
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...
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...
Conversion Project
We are currently working on a project which will at a later date will require alof of data conversion on our existing system to fit the new file structures which are currently been developed. The project is been developed using COBOL on an iSeries, the old and new files will all be physical files....
We are currently working on a project which will at a later date will require alof of data conversion on our existing system to fit the new file structures which are currently been developed. The project is been developed using COBOL on an iSeries, the old and new files will all be physical files....
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...
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...
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?
Hi All, Can we connect remotely (from outside LAN) to a MS SQL server 2000 using enterprise manager? If so, what are the steps?
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...
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...
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....
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....
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...
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...
Monitoring the Network
Hi, I have multiple remote sites. I would like to monitor the network and analyze the traffic and its performance in general. For example, how the bandwidth is consumed, if certain activities are unnecessary and how to improve the networks performance by blocking through the firewall like...
Hi, I have multiple remote sites. I would like to monitor the network and analyze the traffic and its performance in general. For example, how the bandwidth is consumed, if certain activities are unnecessary and how to improve the networks performance by blocking through the firewall like...
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...
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...
Data migration strategies
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...
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...
Software based WIN Simulation
Hi, I need to test out an application over WAN. The testing includes the response time with different delays and bandwidth requirements. Is there any piece of software (preferably opensource/freeware)which can simulate the WAN for me? The idea is to install two NICs in the Windows/Linux machine,...
Hi, I need to test out an application over WAN. The testing includes the response time with different delays and bandwidth requirements. Is there any piece of software (preferably opensource/freeware)which can simulate the WAN for me? The idea is to install two NICs in the Windows/Linux machine,...
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....
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....
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....
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....
