Search results for query: *

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

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

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?

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

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

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

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!

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

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)...