Are you saying that ColumnA is your primary key and that ColumnA is also a foreign key referencing ColumnA in the same table??? That doesn't make sense to me. That...

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 select all...

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 data out...

Well it seems that your connection is perfectly fine. What does the sql do? Does it revoke permissions? Does it create this table?

It seems that this is not a problem...

That is a permissions issue. Do you have the same database username in both XP and Win7? The error message itself is pretty self explanatory.

I can't understand what you are asking here. Can you try to explain your issue more clearly?

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,

...

I see a couple of issues pretty quickly here. First, the query you posted is not the same query as the plan. The one you posted did not have the...

Being a web developer myself I went back to FF 3.x when they released 10. It just so totally sucked that I can't stand it. It seems that FF is...

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, '1730.77' as...

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, '1730.77' as...

I think you are asking if you can define the order or the identity? Why do you think this is important? An identity is NOT going to work like that....

Then definitely do NOT try to make this the first column. Why do you care if this is the first column or the last column?

Here is a code example of...

A lot of people are not able to get to flickr (our net nanny prevents it). You should post your file as an attachment to the post. When posting, scroll...

I would agree with cap'n about ISNULL in your where clause but you are right that would not affect performance running this in different environments. This sounds like a classic...