GilaMonster (1/7/2009)

---

SQL 2005 caches the structure of frequently used temp tables. It's an optimisation to reduce the impact of frequently creating and dropping the same table. That may be what...

As Christopher Stobbs suggested, post your dilemna and we can try to find a more efficient solution than nested cursors. This is one of those problems that most of...

No problem. Just seemed to notice a correlation. I suppose I could be way off, maybe there are other factors involved.

What? Do you want to add...

You could also use SSIS to read the excel file and use a lookup component to compare to the policy numbers and output the missing numbers to a table or...

Steve Jones - Editor (1/7/2009)

---

I see most everyone saying the documentation from the code point of view is critical. And that does make some sense, make notes in the code...

Michael Earl (1/7/2009)

---

I moved out of there years ago - that entire section of the country is creepy.

Now I'm in CT - we only burn cars at Dave Mathews concerts...

Are you connecting using server\instance?

Here's what I look for:

1. IT valued by management

2. Flexible work hours.

3. Upgraded equipment and software

4. Training opportunities

I've worked for a company that did all 4,...

Right. The environment which includes the people and the work area are...

Certainly people are important, but having the "extras" help keep the good people.

Matt Whitfield (1/6/2009)

---

Erm... that version doesn't actually do what's required does it? What happens if a new type other than 'Loan' or 'Insurance' is added?

Not that the schema makes that...

My current position has the nicest office I have ever had. My first job was probably the best place to work as I was learning a lot and we...

Are the 2 views accessing the same table 2 times? Sometimes when you join views you actually are better off writing the whole query without the views. Views...

I'd just use a query like this:

Select

S.name as schema_name,

O.name as table_name,

P.rows ,

O.type

from...