Another concern with leaving deleted records in the table is primary key issues. If a user enters a record that was previously deleted, it will fail on the primary...

I assume you want to delete the records from wce_history.

delete h

from wce_history h

join...

You're going to need to be more specific on what you want. Can you provide table layouts, sample data and expected results? See the first link in my...

select *

from #orders o

inner join (select orderLocation_FK, order_FK, max(orderLocationHistoryTS) orderLocationHistoryTS

...

Are you looking for this? I think there's a better way to write this, but I want to make sure I have the correct result set first

select * ...

What are you looking for? All records where there was a OrderLocation of Not Processed?

select *

from #orders o

inner...

I re-read your problem. See how this works? I found this concept from another thread on this site. I'm not going to take credit for all of...

I think you just did!! Glad I could help!

we're going to need a little more than this. Can you provide table layouts, sample data, and expected results? It'll be better than us guessing at what the...

here is the setup that I am using. The final query returns all insurers regardless of activity. Then if the activity is in the year 2010 it is...

That won't work since it will only return 2010 data. You need to add the filter to the sum statement. Keep in mind that since there is no...

I'm not sure what you did or what you are looking for. Can you post what you did? If you are looking for all records for the Year...

what are the constraints on the new table? You will probably end up with something like Field1 not in (1,2,3) and Field2 not in (4,5,6), etc...

not really sure what your question is. Can you pare down your code and add a little more detail to your question?

If you did want to use a pivot table, here's the syntax for that, but it's a little more difficult. Both examples had the same explain plan

Select InsurerID, [January],...