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

    Computing Average

    Hi, There are 2 tables: Table A (SecurityID, SecurityName) Table B (SecurityID, Price, ClDate) The query is to find the average price with Name=ABC Corp in year 2005 I wanted to know if this query would be right. If not, then why? select avg(price) from B, A group by securityID having...
  2. mistektips

    Implementing Dynamic Drop-down Menu

    Hi, I am trying to make a dropdown menu which dynamically changes when a selection is made in another menu. So when a selection is made in the menu, another list of dropdown is shown. After the selection is made here, the user needs to click a button(go) and it should take it to the respective...
  3. mistektips

    Convert Numeric to Time

    Hi, There is a field which represents time, got from As400 table which is in numeric format(4283002). I want to convert this to time format(04:28:30) using vb scripts. Is there any cast function which will do this?
  4. mistektips

    get data from past 5 days

    Hi, I have to get data from past 5 days from AS400 table. I tried using this query: SELECT * FROM TESTSQL.C27AUDIT WHERE TESTSQL.C27AUDIT.C0027_DATE >= CURRENT (DATE) - 5 But it gives me an error. Also, I just wanted to clarify that the C0027_DATE field is a numeric field...
  5. mistektips

    Get data from past 5 days

    Hi, I have to get data from past 5 days from AS400 table. I tried using this query: SELECT * FROM TESTSQL.C27AUDIT WHERE TESTSQL.C27AUDIT.C0027_DATE >= CURRENT (DATE) - 5 But it gives me an error. Also, I just wanted to clarify that the C0027_DATE field is a numeric field...
  6. mistektips

    Convert Date Format

    I need to convert date which in this format (mm/dd/yyyy) to (yyyymmdd) format. Can someone suggest? Thanks!
  7. mistektips

    Get data from only past 5 days

    Hi, I have to write a query which gets data only from past 5 days from a table. This table has a column for date. Could someone suggest how do I write the query. Thanks!
  8. mistektips

    Error: Cdate

    Hi, I am getting 'Type Mismatch: cdate error" when I am running this script... Basically I am using DTS(Sql server) to transfer data... And one of the columns is date... Could someone suggest as to why I am getting an error? Any help will be appreciated. Thanks The script is as follows...
  9. mistektips

    newid() error

    Hi, I am trying to run this stored procedure, but I am getting an error saying: Server: Msg 170, Level 15, State 1, Line 2 Line 2: Incorrect syntax near ')'. The stored procedure is as follows: CREATE PROCEDURE usp_Insert_Met_File_New @GUID uniqueidentifier, @Class_Code char(5)...

Part and Inventory Search

Back
Top