That sums it up pretty good

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries

L' Eomot Inversé (11/22/2011)

---

I had a look in IKEA in Arrecife a couple of years ago, and was appalled at the office...

Sounds like my standard reports here :-D.

I still don't see how union is usefull here. You need to add data here, not de-deplicate it.

Yes allow null with an or in the where clause for each parameter.

Or not allow null and set impossible ranges (like -1 to 100 000 miles).

It comes down to what is best for your system.

Watch all of those for a much deeper understanding.

http://www.youtube.com/watch?v=RZ4YTg4S7HI&feature=plpp_video

http://www.youtube.com/watch?v=Kcnj5bQghjY&feature=plpp_video

http://www.youtube.com/watch?v=XmE_Utp8CY0&feature=plpp_video

jerry-621596 (11/22/2011)

---

Includes in an index typical reference columns that cannot be part of the index itself such as bit columns. The includes also enable an index with more than...

JimS-Indy (11/22/2011)

---

Thanks for that catch. I'll fix it.

I'm currently stuck on a union query that's lockin up for some reason.

I am enjoying the learning, though.

Again, thanks for the...

Budget?

What's that weird word :hehe:, never heard of it!

What's so secret about your plan that we could steal your company and force you to close the doors.

It's possible, but I've yet to see anything of that value ever...

Maybe you should read those and then come back if you need more help (diy basic ssrs tutorials).

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

http://www.sqlservercentral.com/stairway/72382/

Stefan Krzywicki (11/22/2011)

---

Ninja's_RGR'us (11/22/2011)

---

Stefan Krzywicki (11/22/2011)

---

Ninja's_RGR'us (11/22/2011)

---

Stefan Krzywicki (11/22/2011)

---

Koen Verbeeck (11/22/2011)

---

In Belgium, that would be a cheap house :blink:

It...

Stefan Krzywicki (11/22/2011)

---

Ninja's_RGR'us (11/22/2011)

---

Stefan Krzywicki (11/22/2011)

---

Koen Verbeeck (11/22/2011)

---

In Belgium, that would be a cheap house :blink:

It certainly looks nice....

jpg please.

People are usually frisky about opening a vba activated file made by a programmer 😉

Jack Corbett (11/22/2011)

---

Brandie Tarvin (11/22/2011)

---

Jack Corbett (11/22/2011)

---

I start a new job in less than 2 weeks and it is a telecommute. I need to buy a new monitor and...

Good visual explaination here too

http://technet.microsoft.com/en-us/sqlserver/gg429790.aspx

Whole list of vids by category

http://sqlskills.com/T_MCMVideos.asp