I have adapted a style of "We don't use that (anymore)" when called by sales people.

One person called and talked about a new BI solution they had developed and how...

One of those moments before morning coffee, I guess....

Of course it is, thank you.

Sean Lange (5/29/2013)

---

dan-572483 (5/28/2013)

---

How about in a WHERE EXISTS clause?

According the the Querying SQL2012 exam prep book, a SELECT * inside an EXISTS clause returns true or false only -...

sheetalsh (8/20/2008)

---

Hi,

The query below is working fine for the date as 04/08/2008 and 08/08/2008, however it is not working for the date 11/08/2008 and 15/08/2008.

It is because it considering 15th...

Thank you for the tips.

Specifying the index as unique did shave off time in the overall processing from what I had tested previously.

But creating the index after the insert adds...

That works perfectly.

Thanks for pointing me in the right direction on these issues.

What I'm doing is replacing a certain value CHAR(2) when it is present in a row under a certain heading, since the value becomes "illegal" in the eyes of our...

Hi Andy,

Thanks for making it crystal clear to me.

Andy, thanks for taking the time and effort to write something like this. It is a very interesting read for me, who are just coming into the BI-world.

As a side...

MERGE is what you want in SQL Server 2008. This piece of code is untested, in fact, I've never used the COALESCE command myself (being a self-taught SQL-novice).

This piece of...

Thanks for putting the effort into writing this complete guide. It's made a lot of things and issues a lot more clear to me.