Search results for query: *

We have a batch script running on our server that we have no idea why its running. It was something that was written before the current techs took over and would like to find what is the name of the file that keeps opening the cmd window and running something. Is there any way to catch this or...

i would like my data to show a 1 if PlayerID exists in GameRoster and a 0 if it doesn't my currently working script returns null if the playerid doesnt exist. using the if exists it crashes.

I have a table that contains ArchiveID (PK, AutoIncrementing) and FileName. When inserting an item into the database i would like to insert the filename originally spreadsheet.xls as spreadsheet141.xls where the 141 is the archiveid that is given on insert. is there a way to append this before...

im trying to restrict my query to the first 5 record but its not working it keeps returning all records. // Performing SQL query $query = 'SELECT GameID, Date(GameDate) AS GameDate, G_Time, R_Name, (SELECT Concat(Team.SchoolName,\' \',Team.Mascot) FROM Team WHERE Team.TeamID=A_TeamID) AS...

SELECT Loan.LoanID, Max(A.DateAdded2) AS DateAdded, A.StatusValue FROM Loan INNER JOIN (SELECT Loan.LoanID, Max(AdditionalStatus.DateAdded) AS DateAdded2, AdditionalStatus.StatusValue FROM Loan INNER JOIN AdditionalStatus ON Loan.LoanID=AdditionalStatus.LoanID INNER JOIN...

i have a table where i need to select the Status from the MAX(DateAdded) for each month for each loan. Table [AdditionalStatus] Structure LoanID DateAdded Status EXAMPLE 001 2/15/06 ABC 001 2/17/06 GHI 002 2/18/06 ABC in the above example the first one would not be selected because the max...

insert into iProf_Status_History (LoanID, StatusDate, UserName, StatusCode) Values (a,b,c,d) a,b,c will be coming from a specific table (MortPayoffCalc) where Approved=1 b is a varchar that has datetime vaules. I need to convert them to datetime for the new table. a : Mortpayoffcalc.LoanID b...

In the beginning of my proc i want to drop the temp table if it exists. in mysql it would be... DROP TABLE IF EXISTS Temp_Table how do i do it in MSSQL?

I have an excel spreadsheet which contains data that we had exported a few months ago. We cant export the report again since it was a snap shot in time at that moment but we wanted to add a state field to each loan in the report. THe loanids are in the A column. We have the Q column open to...

Its telling me there is a syntax error near IF but i can't see whats wrong with it. Im going insane here. If i dont assign it to the variable its returns the correct result. DECLARE @LoanID varchar(10), @INV_SF decimal, @Comm_Bonus decimal SET @LoanID = '1234567890' -- RETRIEVE DATA FROM...

i wanna update rows with numbers greater than 5 to have the same closingdate as their openingdate would it be update table set closingdate=openingdate where num>5 now these records all have different openingdates so will they all be updated with the correct closingdate?

i have an int field that auto increments by 1 in my temp table. How do i reset this number so i can start fresh everytime i use the temp table?

i have two tables TABLE A LoanID HistoryCounter DateMailed TransactionCode TransactionAmt TABLE B LoanID HistoryCOunter TransactionDate TransactionCode TransactionAmt All i want is to have a view where i can select all items in table a and b at the same time. VIEW LoanID HistoryCounter...

I have a view i have created that im trying to select into a coloumn the previous TransactionDate of a loan. How can i do this all in the same view. EXAMPLE LOAN TranDate PrevTranDate 0001 1/1/07 null 0001 1/2/07 1/1/07 0002 1/4/07 null 0001 1/5/07 1/2/07 SELECT...

i have a table where im trying to update multiple rows based on a date. I was getting an error with my trigger because it was trying to update another table 1 row at a time. so i created a procedure to look at the inserted table but i get invalid object 'Inserted' How do i create a procedure...

i have a form that on sumbit calls a page to do the mysql statements. After a successful insert or update i would like to return the user to the same page with a note at the top say "Insert successful" how do i do this?

Purpose: To calculate the interest earned on on disbursements while loan is open. Idea: Insert all disburements into a table and calculate the days open based on when payments are recieved. If loan is or becomes closed no more interest may accumulate on disbursements. Anything with a CODE...

im trying to include a page based on what page the user selects <?PHP if(isset($_GET['Page'])) { include('/admin/'.$_GET['Page'].'.php'); } ?>

I have a stored procedure that i call when ever there is an insert on the database. The problem is is that in the stored procedure i have an insert statement that will then recall the stored procedure causing it run while its already running. How can i run the procedure on inserts with out...

im trying to create a select to allow users to select from multiple options. The problem is for some reason i cannpt get it to work right with php. when i put <select> in php tags it doesnt redirect the page but when i remove the <select> tags from the php it does work. Please help i...