Search results for query: *

I'm trying to create a query that will display our database field with Upper and Lower case (currently the data is saved as all Upper case). So for vchBusinessName = ARROW PLUMBING AND SERVICES, INC. I want it to display = Arrow Plumbing And Services, Inc. I've created this query: SELECT...

I have not created many insert statements and I'm not sure how this one should be coded. Please help. I need to insert a record based on a select query that will give me a record set of what needs to be inserted. select query will give me intCaseID from tblCase. 12345 23456 34567 Then I...

I have a Select Query that I have tested and is pulling the results I want, now I need to create an UPDATE statement and I'm not sure how to with a MAX involved in the update. Please help!! I'm not familiar with writing UPDATE stmts. Thanks in advance. SELECT STATEMENT SELECT...

I need help I have a very long query. That I know could be written better and more efficient but, I'm not sure how. The query works except for in the First Select Stmt, it wont let me include the ORDER BY (I put *** by it). Someone suggested for me to user the feature of CUBE, but I have to...

I've created a very long and complicated Derived Query in order to Combine Two Queries and but my problem is its not giving me the correct results. My extremely long query is below, but here are my results and then I'll show you what I need it to do. Thanks in advance for any help! First of...

NEED SOME HELP!! I've created the query below. I need a query that will look in a table and if intCaseID is null, then will pull a date in another table, else will pull a date in that table. Right now it only works one way if the value is not null, it works correctly. If its null, then it...

I created a query and now I need to use the results from that query to get more detailed results. Any suggestions! 1st Query: SELECT c.vchTrustee, COUNT(ba.vchAccountNumber) AS total, ba.vchAccountNumber FROM tblBankAccount ba INNER JOIN tblCase c ON ba.intcaseID = c.intCaseID GROUP BY...

I need help! I have a table named tblCases that includes records with a field dteFiled. I need a query that will Count each record for each month with in a year. The query below does this but if there are no records within a particular month then it excludes that month. SELECT...