Search results for query: *

I did added extents still Iam getting same error. Thanks

I'm getting ORA-01652 unable to extend the temp segmentby 16 in tablespace temp01 Thanks in advance

I did no use it increase the logical read Thanks

SELECT od.patient_sys, od.visit_sys, CONVERT(NVARCHAR, p.dob, 101), p.name_last + ', ' + p.name_first, p.reg_num, COUNT(od.patient_sys), (CASE WHEN DATEDIFF(MM, p.dob, GETDATE())/12 >= 2 AND...

I have a activity field which consists of administration, protection, support records. I want to display administration record as admin in my tblrequest. How to do this? Thanks in advance

Hi Leslie! I have made those changes still If I one pick animals in one combo box it is not filter in second combo box. what I need was suppose if user picks animals in cbocause it should bring all the animals codes in second cboprotect. Thanks in advance

I have need to limit selection available in a combox based on another combo box If Not IsNull(Me!cboProtect) Then Me!cboProtect.RowSource = "SELECT tblProtect.ID, tblProtect.Description" _ & " FROM (tblProtect Left Outer JOIN tblCauselookup ON...

I have want to count no of DP,St,pm in mpitems.no field. Any formula help would be appreciated. Thanks in advance

I have a Mpitems.no consists of DP,ST,PM records. I want count no of DP in mpitems.no field which is grouped by mpitems.no field. Thanks in advance

I have following query to update tbl materail UPDATE Material RIGHT JOIN Engcost ON Material.[PART NO]=Engcost.[PART NO] SET Engcost.[PART NO] = Material.[PART NO], Engcost.[MATERIAL DESCRIPTION] = Material.[MATERIAL DESCRIPTION], Engcost.[COST EACH] = Material.[COST EACH], Engcost.CD =...

Thank you for your note PHV. Can you explained me steps by steps process how to do this?

I have a combo box cause based on tbl causelookup which consists of ID, Description and code fields on form outage. I have another combo box field protect based on tblprotect which conists of ID, description and code fields. I need limit selection of values of combo protect based on selection in...

I need to have carriage return in @combine_nn field which is 80 characters i need at 81 character. How to do this . Thanks in advance

How to get new page after each sort record. Iam sorting by N and Y records. I need to get new page after N records. Thanks in advance

Iam getting error in where clause near As can someone fix for me this statement

SELECT ACCT_NO, (SELECT SUM(tran_record.amount) FROM tran_record WHERE tran_record.acct_no = T1.acct_no) AS balance, (SELECT SUM(tran_record.amount)...

How do you calculate total for count field Business Id Ptype count American Dryer 1 American Ac 1 I want to get 1 on count field for every record Thanks

I Have businessiD Ptype fields. I need to count fields in this format BusinessID Ptype count American Dryer 1 American Ac 1 Total business ID 2 How to do this ? Thanks in advance

I want to get Acct no, amount, duedate for the last record in the table. Thanks

I have tbl payment with AcctNo, amount, Due date fields. How to get last duedate records from the tbl if you have multiple duedate records