Phil Parkin (4/1/2016)

---

Or run an...

This should be a pinned post, so I'm bringing it back to the top of the list. 😉

You need to use a format file to identify the quotes as part of your delimiter. BCP won't remove the quotes for you otherwise.

You can also check the stairways on this site.

There are also lots of videos explaining how to work with SSMS, as well as books.

As mentioned, one option is to just...

Brandie Tarvin (4/1/2016)

---

One thing broke.

The most important thing broke....

Spiff (4/1/2016)

---

The value of a multi-value parameter is an array of the selected items.

You can use Array.IndexOf to test if a value is in the array, i.e. selected in the...

mschaper (4/1/2016)

---

That is a much better look. The drop down with multiple values gives them what they want. Now the question is how do I create an expression...

Why do you have multiple checkboxes instead of allowing to have one parameter that allows multiple values?

I really shouldn't be posting any code without being able to test it. But it seemed so cumbersome that I couldn't help myself.

You shouldn't use functions on your columns in...

Sergiy (3/31/2016)

---

GilaMonster (3/31/2016)

---

No. Temp tables are session-scoped, you cannot access a temp table created in another session,...

Gail,

I was trying to picture the OP giving the presentation and using your advice. I simply couldn't get the whole picture, I just start laughing.

The confusion on the term "heap index" might have raised because a heap (no index or table need to be added to the term) is included in the view sys.indexes

The alternative is using cross tabs, which will make the query run faster.

SELECT PlacementMonth,

MAX(CASE WHEN TimeZoneNamePlaced = 'Eastern Placed' THEN NumberOfActiveAccounts END) AS [Eastern Placed],

...

ScottPletcher (3/31/2016)

---

Hmm, not sure what you mean there. There's no problem at all explicitly creating a PK as nonclustered,...

I was going to give you the "correct" answer, but I'll lead you...