this is code
<% If B_go = "Go" Then DBInit() Select Case qtype Case "Average Management report of a User" REGSQL = "select FT.FILE_DEPARTMENT,u1.user_designation,U1.USER_NAME,(count(u1.user_designation)/30)*24 as avg_file_disposal_in_hours from filetrans FT,USERS U1 where U1.USER_NAME LIKE '%Secretary/Pr. Secretary/Addl. CS%' AND FT.OFFICE_CODE=U1.OFFICE_CODE AND FT.DESPATCH_DATE_TIME between sysdate-30 and sysdate and FT.RECEIPT_DATE_TIME between sysdate-30 and sysdate group by FT.FILE_DEPARTMENT, u1.user_designation, U1.USER_NAME" End Select 'Response.Write(REGSQL) RStoTable(REGSQL, qtype & ";filelist;filelist", "100%;400", 5, 50, -1, "", "") End If %>
on go button data can be displayed or not.........?..kindly suggest.......
see code suggest me.masters
thanks and regard love4csharp
SYSDATE is not a correct TSQL function. Use GETDATE()
SYSDATE is used in ORACLE.
Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/
MS SQL optimization: MS SQL Development and Optimization
MS SQL Consulting: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
SQL Server Integration Services: Business Intelligence