SQLRNNR (8/22/2014)

---

Grant Fritchey (8/22/2014)

---

I hadn't heard, but now that I know... I'm bummed. They made the...

sqldriver (8/22/2014)

---

ChrisM@Work (8/22/2014)

---

Here's something I wrote some time ago (inspired by something Jack Corbett wrote years ago) which explains why you have two joins followed by two ON clauses:

The order...

SQLRNNR (8/22/2014)

---

Ed Wagner (8/22/2014)

---

The bug that was afflicting the thread is fixed!!! Thanks very much, Steve. I, for one, have missed the water cooler. 😉 If you're...

My preference is for developers to work on a subset (defined set of development data) locally for doing development and unit testing. Then pushing changes to a shared...

mario17 (8/21/2014)

---

<<What it's saying is that IF the Left join row exists , INNER join to that other table.

Otherwise, treat it like a regular LEFT join and put NULL in...

I can't get the code to parse as it either. Something must be missing.

If you create the new columns as NOT NULL with a DEFAULT constraint then the columns will be populated with whatever you put in for the DEFAULT. Like this:

USE...

What version of SSDT/BIDS are you using (2008, 2010+)?

The grouping pane typically is at the bottom of the report design screen. It isn't a popup. See the attached...

mkbhagat4u (8/21/2014)

---

Yes,

Its not possible.

I have one more question.

I have report which is parameterized..

Can I provide 2 level filter in report.

1st level- When I pass parameter then click on...

This, http://msdn.microsoft.com/en-us/library/dd220419(v=sql.105).aspx walks you through how to work with groups in SSRS.

GBeezy (8/20/2014)

---

Thanks Jack for the response.

I have another question, I just started at this job and I am seeing tables that do not have a PK or a...

A windows security patch shouldn't change the recovery model of a database.

I'd look in the default trace to see if it still has information about an alter database...

Neither is another option.

When working on indexing you need to consider the all the ways a table will be queried to come up with the best indexes. In your...

Looks like you need a crosstab/pivot. I suggest reading the last 2 articles in my signature (Cross Tabs and Pivots...) which, in my opinion, are the standard for how...

Unfortunately the built-in interactive sort in SSRS only allows you to sort on one column at a time. Another option is to have Sort By parameter (or parameters) on...