I'm not sure if there's a conflict of interests by posting the following but...

If you're looking for a nice tool that can be easy for the execs to work with,...

SQLRNNR (8/7/2012)

---

Luis Cazares (8/7/2012)

---

SQLRNNR (8/7/2012)

---

mtassin (8/7/2012)

---

And what happened to Steve's statement of NO MORE IMAGES for queries?

Steve? Come on...

Not that it matters for this one... but it did...

SQLRNNR (8/7/2012)

---

mtassin (8/7/2012)

---

And what happened to Steve's statement of NO MORE IMAGES for queries?

Steve? Come on...

Not that it matters for this one... but it did look like a...

JasonRowland (8/7/2012)

---

Luis Cazares (8/7/2012)

---

You might find this article interesting.

http://msdn.microsoft.com/en-us/library/ms190309.aspx

So you won't have to wait for Celko to "do some digging". Here are the exact rules for implicit conversion in SQL...

You might find this article interesting.

http://msdn.microsoft.com/en-us/library/ms190309.aspx

So you won't have to wait for Celko to "do some digging". Here are the exact rules for implicit conversion in SQL Server. It's not...

This is a tricky question and even though I knew the answer I got it wrong, but I blame myself for not putting enough attention.

However, the explanation is wrong and...

I guess you're wrong. This codes executes and returns 0 rows and no error.

SET @str4 =...

I guess I figured out how to reduce that over 5 hours query to a 5 minutes query (at least for the first run) and that's a really nice improvement.

There...

Peter Brinkhaus (8/3/2012)

---

Well, in that case, here's another one. Only works on INT's >= 0.

SELECT

N,

LEFT(CAST(N % 10 AS CHAR(1)) +

...

I'm not sure what are you trying to do.

Does a model_id can have more than 3 vinno?

Would this help?

SELECT DISTINCT

A.vinno,

...

shahsn11 (8/3/2012)

---

I really appreciate you for your answer thanks. And the output was the same as i was thinking.

Since i am a newbie , i am having some problem while...

Role Based...

Why would you upgrade to SQL 2008 if SQL Server 2012 has been released now?

I misread, your question. I have some information at home, but I believe that from SQL...

This is shocking for me, I've run both queries several times and using the view is at least twice faster. Am I missing something?

This is the code I used to...

Thank you Sean, I know it might be a lot of work looking at it in depth (when is not really your job).

About the NOLOCKs they were there when I...