Sean,

I don't need any results, there is a problem, the database is not working. I just wanted to know what they are asking for in the result set. I might...

So here is my problem:

Could not open the editor: Assertion failed:

org.eclipse.jface.util.Assert$AssertionFailedException: Assertion failed:

at org.eclipse.jface.util.Assert.isTrue(Assert.java:185)

at org.eclipse.jface.util.Assert.isTrue(Assert.java:170)

at com.adobe.flexbuilder.editors.derived.editor.FlexMultiPageEditorPart.setActivePage(FlexMultiPageEditorPart.java:569)

at com.adobe.flexbuilder.editors.common.editor.CodeAndDesignEditor.setActivePage(CodeAndDesignEditor.java:643)

at com.adobe.flexbuilder.editors.mxml.MXMLEditor.setActivePage(MXMLEditor.java:483)

at com.adobe.flexbuilder.editors.derived.editor.FlexMultiPageEditorPart.createPartControl(FlexMultiPageEditorPart.java:235)

at com.adobe.flexbuilder.editors.common.editor.CodeAndDesignEditor.createPartControl(CodeAndDesignEditor.java:162)

at org.eclipse.ui.internal.EditorReference.createPartHelper(EditorReference.java:661)

at org.eclipse.ui.internal.EditorReference.createPart(EditorReference.java:428)

at org.eclipse.ui.internal.WorkbenchPartReference.getPart(WorkbenchPartReference.java:594)

at org.eclipse.ui.internal.PartPane.setVisible(PartPane.java:306)

at org.eclipse.ui.internal.presentations.PresentablePart.setVisible(PresentablePart.java:180)

at org.eclipse.ui.internal.presentations.util.PresentablePartFolder.select(PresentablePartFolder.java:270)

at org.eclipse.ui.internal.presentations.util.LeftToRightTabOrder.select(LeftToRightTabOrder.java:65)

at org.eclipse.ui.internal.presentations.util.TabbedStackPresentation.selectPart(TabbedStackPresentation.java:473)

at...

Sean Lange (5/15/2012)

---

I assume by your silence that you did in fact get your issue resolved. It is...

Sean Lange (5/7/2012)

---

njdevils39 (5/7/2012)

---

Sean Lange (5/7/2012)

---

You seem have me lost...

What does that mean? What is the question?

Did...

Sean Lange (5/7/2012)

---

You seem have me lost...

What does that mean? What is the question?

Did you notice that...

Sean Lange (5/7/2012)

---

njdevils39 (5/7/2012)

---

Sean Lange (5/7/2012)

---

njdevils39 (5/7/2012)

---

Sean Lange (5/7/2012)

---

What is wrong with what you posted? One thing I would do differently is don't bother creating temp table, then filling the...

Sean Lange (5/7/2012)

---

njdevils39 (5/7/2012)

---

Sean Lange (5/7/2012)

---

What is wrong with what you posted? One thing I would do differently is don't bother creating temp table, then filling the temp table, then...

Sean Lange (5/7/2012)

---

What is wrong with what you posted? One thing I would do differently is don't bother creating temp table, then filling the temp table, then select all the...

Sean Lange (5/7/2012)

---

OK using real tables here is the code...still works fine.

alter PROCEDURE [dbo].[WEB_HR_GetRateHistory]

(

@EMP_ID INT

)

AS BEGIN

with cteRates as (

select o.emp_id,

...

Here is my code when I involve the actual, not temp tables.

ALTER PROCEDURE [dbo].[WEB_HR_GetRateHistory]

(

@EMP_ID INT

)

AS BEGIN

DECLARE @x XML;

with cteRates as (

select o.emp_id,

...

Sean Lange (5/7/2012)

---

njdevils39 (5/7/2012)

---

Sean Lange (5/7/2012)

---

njdevils39 (5/4/2012)

---

select 1 as RowNum, 3 as EMP_ID, 'Whitehead, Molly' as EMP_NAME, 'Silver Manor' as EMP_ORGANIZATION, 'Administrative' as EMP_DEPARTMENT, NULL as EMP_DT_TERMINATION, '03/06/2011' as DATE_CHANGED,...

Sean Lange (5/7/2012)

---

njdevils39 (5/4/2012)

---

select 1 as RowNum, 3 as EMP_ID, 'Whitehead, Molly' as EMP_NAME, 'Silver Manor' as EMP_ORGANIZATION, 'Administrative' as EMP_DEPARTMENT, NULL as EMP_DT_TERMINATION, '03/06/2011' as DATE_CHANGED, '1730.77' as FROM_PAY_RATE,...

Lynn Pettis (5/4/2012)

---

njdevils39 (5/4/2012)

---

R.P.Rozema (5/3/2012)

---

njdevils39 (5/2/2012)

---

So, in my post to go off from this code:

ALTER PROCEDURE [dbo].[WEB_HR_GetRateHistory]

(

@ORG_LEVEL_ID INT,

@EMP_ID INT

)

AS

BEGIN

DECLARE @x XML;

...

R.P.Rozema (5/3/2012)

---

njdevils39 (5/2/2012)

---

So, in my post to go off from this code:

ALTER PROCEDURE [dbo].[WEB_HR_GetRateHistory]

(

@ORG_LEVEL_ID INT,

@EMP_ID INT

)

AS

BEGIN

DECLARE @x XML;

CREATE TABLE...

So, in my post to go off from this code:

ALTER PROCEDURE [dbo].[WEB_HR_GetRateHistory]

(

@ORG_LEVEL_ID INT,

@EMP_ID INT

)

AS

BEGIN

DECLARE @x XML;

CREATE TABLE #RATE_HISTORY

(

EMP_NAME VARCHAR(255),...