Search results for query: *

I did a little digging and I found that the GROUP BY Clause does exactually what I was looking for.

works perfect thanks

Yes I can. I can do anything after the FROM clause in a SQL statement. SO ORDER BY and Subqueries work too.

I can do anything that can follow after the FROM Clause. So Group BY works too but as far as I know this only groups the duplicate member numbers and not returns the unique/distinct numbers.

I have an app at work that will only allow me to customize the WHERE clause on a SQL statement. Currently the SQL Statement is hard coded something like this: SELECT * FROM `ERRORS` Is there a way to do a DISTINCT in the WHERE clause that would return the same results as: SELECT DISTINCT...

I have an app at work that will only allow me to customize the WHERE clause on a SQL statement. Currently the SQL Statement is hard coded something like this: SELECT * FROM ERRORS Is there a way to do a DISTINCT in the WHERE clause that would return the same results as: SELECT DISTINCT...

I have an app at work that will only allow me to customize the WHERE clause on a SQL statement. Currently the SQL Statement is hard coded something like this: SELECT * FROM ERRORS Is there a way to do a DISTINCT in the WHERE clause that would return the same results as: SELECT DISTINCT...

Thanks for your input. I think better indexing will fix our situation. I know some of these columns are already indexed but I think they are indexed too many times and not properly.

I have a query that is taking about 10 seconds to execute. I'm trying to optimize the query. Here is the code: SELECT ACCOUNT_LEVEL,PROGRAM,ANNUAL_FEE, APR_FLOOR_RATE,CASH_ADV_RATE,LATE_FEE,NSF_FEE,APR_RATE,APR_BASIS,LATE_GRACE_DAYS...

Solved my own problem with: function parseResults() { var response = xmlHttp.responseText; document.getElementById('serverResponse').innerHTML = response; }

What I want to do is use ajax to return a table that was generated using a jsp. I am getting the table back and it is displaying on the page but it is returning all of the tags with it. IE. <table><tr><td></td></tr></table> My parsing javascript method looks like this: function...

I finally fixed my problem. I had 2 problems. Both of which was in my BranchBCO file. I didn't say that the class implements the interface and second I had is set up as public static and my interface was only public. This is why I was getting the type cast error. Thanks for trying to help...

What I'm doing is I have a website that sends a command property to a front controller servlet and then forwards onto a class. All that I want this class to do is get the command property and dynamically call the appropriate class and its method. For example if the command is "Login" then I want...

The company that I work for just upgraded to sql server 2005. In doing so I expected them to also upgrade their reporting services so I rolled out a report using 2005 RSS. I turns out that after I finished I went to deploy my reports and found that they are still running RSS 2000 and don't...

Yes the 2.0 framework is installed on the server. I guess a big question is can you uses the reportViewer tool to view 2000 reports or only 2005? And if you can't then how do you view your report?

I am trying to get my SRS 2000 reports to hook up with my ASP.NET 2.0 reportViewer. Currently I have a page that has a reportViewer Control. The control is pointing to a remote SQL server 2005 database . I can view my reports just fine on the server so I know that they work. When ever I...

To be honest I don't have any connection calls in my page code. I thought that I could just make my connection to the database by changing my web.config file.

I found an example of what I need to do but I can seem to get it too work. http://www.c-sharpcorner.com/UploadFile/amit_agrl/EnablingMembershipProviderforSQLServer2005.doc08222005044400AM/EnablingMembershipProviderforSQLServer2005.doc.aspx?ArticleID=01cc2bd6-c790-4f00-90dd-030e05feb404 Here...

Like I said I'm a newbie at this so could be elaberate on how I change my connection to the sql 2000 database.

I'm a newbie at this so bare with me. I created a login screen for a website using Visual Studio 2005 using their login tools. Our webserver is running SQL server 2000. I ran aspnet_regsql.exe and imported the database into sql server 2000. Now I just need to change the web.config file to...