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 Chriss Miller 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. jgurgen

    Windows script to record activity of another script

    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...
  2. jgurgen

    Can't write encrypted data

    * varchar(16) md5 i know returns a 16 byte string
  3. jgurgen

    Can't write encrypted data

    what is the type of field your trying to insert it into? Is it varchar(1)??
  4. jgurgen

    if exists select help

    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.
  5. jgurgen

    Appending Auto incrementing id to another field

    i went with the long way on doing this, inserting, selecting the id then updating. Its not the way i wanted to but it works for now and im going to look into bborisov's method in the future to clean it up. Thanks for the help
  6. jgurgen

    Appending Auto incrementing id to another field

    because im not inserting the id its being done on the insert so i dont know what number its going to give
  7. jgurgen

    Appending Auto incrementing id to another field

    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...
  8. jgurgen

    Problem with top N records using limit

    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...
  9. jgurgen

    Not returning max date

    Lamprey13 that doesn't work, it still returns mutliple dates for each loanid.
  10. jgurgen

    Not returning max date

    ok i think this would work but i keep getting syntax error near keyword ON why? SELECT AdditionalStatus.LoanID, Max(AdditionalStatus.DateAdded) as DateAdded, AdditionalStatus.StatusValue FROM AdditionalStatus INNER JOIN (SELECT Distinct LoanID FROM R_IFS_AdditionalStatus) ON...
  11. jgurgen

    Not returning max date

    Basically this sql statement is returning all the results i need. From here i need to take the max(dateadded) for each LoanID where the date is less then a specified date from @EOM_Date. SELECT AdditionalStatus.LoanID, AdditionalStatus.DateAdded, AdditionalStatus.StatusValue FROM...
  12. jgurgen

    Not returning max date

    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...
  13. jgurgen

    Max Date only per month

    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...
  14. jgurgen

    Insert into table a from table b HELP

    thank you
  15. jgurgen

    Insert into table a from table b HELP

    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...
  16. jgurgen

    Drop Table if exists

    thanks for all the help works great
  17. jgurgen

    Drop Table if exists

    would i be better in doing CREATE TABLE #Temp_Table then would i have to check if the table exists in case the procedure crashed?
  18. jgurgen

    Drop Table if exists

    right now i have it as CREATE TABLE TEMP_TABLE
  19. jgurgen

    Drop Table if exists

    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?
  20. jgurgen

    Linking Excel and SQL Server

    awesome that worked perfectly thanks

Part and Inventory Search

Back
Top