--I made a mistake...Sorry

I only want to see the records where count of Code >=2 group by GroupID

however, if and only if count of same type >= 2 group by...

That worked! Thank you so much! 😛

Ian Scarlett

these are the two tables with excessive IO:

Table 'MyValueR'. Scan count 1, logical reads 27179, physical reads 5, read-ahead reads 27173, lob logical reads 0, lob physical reads...

Ian Scarlett

Thank you for the reply.

I already check all those tables and they do have a foreign key in reference to that table. All the tables have indexes...

I attached the execution plan and the table schema. This table is less than 200 records. Yes I am sure there is only one record with that criteria....

No it is not block by anyother process.

Thank you very much, this worked very nice! 🙂

I do appreciate your help!

Are you join temp tables with your regular tables?

Ggraber,

One row for each of them will be better because there may be several dependencies.

Thank you so much!

Mark,

So, I cannot select from a field of a table?

I need to select from a file?

I have this table from reporting services and I need to pull data...

Ggraber,

Here is the file of one value and one field.

Thank you!

I am creating a report in reporting services.

Ggraver,

Than you so much! That was it!

Jeff helped me with this code, but I do have a problem with row 26. The counter should start with 1 at row 26 because the value is between...

Jeff and Graber

Thank you so much, and thank you for the explanation. It helps a lot to understand where my problem was. I really appreciate your help.