In other words:

SELECT A.NOME,

A.MATRICULA,

CASE P.TIPO_AULA

WHEN 1...

You're doing the LEFT OUTER join correctly. What is tripping you up is what you are leaving in the WHERE clause.

Leaving

H.SALA 0

means that only those rows that have...

Frankly this is one where I would go CLR. In other words - write it in C# or VB and use it in SQL. You will have a...

Here's my full test set. Looks pretty close to right.

One additional adjustment I made in the calculation of the average is to make sure that it was float (not...

JP Sabin (8/24/2009)

---

Guys, thanks for the help. I renormalized the table and converted the data type and then I'm using

"Select ID,

datediff(month,...

Keep in mind that unless those datasets are REALLY small, changes are fairly good that they will be turned into Worktables anyway, so you don't ever completely get away from...

Using Dave's idea of renormalizing the data (i.e unpivoting the data), it's actually a lot easier than it looks:

Select ID,

datediff(month, min(month),...

Using OPENXML in this way means you can only do inserts one row at a time, and restricts your options.

You should look over the solid advice from Jacob Sebastian here...

Are you rebuilding indexes/shrinking stuff/updating statistics?

Ells (8/19/2009)

---

I thank you. I cant imagine why rhey consider an approximate value a good idea.

Any suggestions for a suitable dtat type to hold the value 10.1 that is not...

So have you managed to get to the bottom of what is making it run long?

Would the proc actually finish if you just simply let it process long...

Keep in mind that testing with SELECT * guarantees a bookmark lookup. Are you sure you're not picking up the slowness of those bookmarks? If it's not selective...

You want to read up on the PATINDEX function, which may allow you to find the space you need. I use the word "MAY" because trying to break up...

..per machine/IP address. It's probably a given, but it is sometimes useful to add the obvious in...

We've had mixed results with outsourcing some of those roles. We have some amount of our coding and maintenance work being performed off-shore, and we've found that it vastly...