Sean Lange (6/17/2015)

---

tomsharp85 (6/17/2015)

---

Hi, I have a flat table with 17 columns of contact information with columns to seperate those contacts into different business classes. Here is the table:

USE DataCompany

CREATE...

Hopefully the OP isn't still looking for that procedure.

TomThomson (6/15/2015)

---

Ed Wagner (6/15/2015)

---

Steve Jones - SSC Editor (6/15/2015)

---

Jeff Moden (6/15/2015)

---

The thing that scares me about that is that it worked. Add a mobility unit, a carbon power cell,...

oops, misread the question.

Time for Excel to get an upgrade!

Trying to do this without VBA is getting to be a pain in the ...

tsobiech (6/12/2015)

---

Thanks for the link!

However, when I...

Take a look at the link below. It should provide most of the information you need to do this from Excel.

http://realworldsql.com/2012/06/07/stored-procedures-with-parameters-in-excel/

Edit: oops. I didn't see the Luis' response before...

Sean Lange (6/12/2015)

---

tsobiech (6/12/2015)

---

I think I'm just going to have to resign myself to the fact that I'm going to have to "manually" change the dates, every time, then copy/paste/format...

If you want the view to always look at last quarter, then you could also dynamically calculate, in the view, what the start and end dates need to be.

Ed Wagner (6/12/2015)

---

Yeah, and it's been going on for a...

homebrew01 (6/12/2015)

---

I have a simple SSIS package that imports an Excel Spreadsheet into a table. The column heading got changed, so the package failed, as expected, but I would...

Disk unformatting is not that hard. Use DBCC TimeWarp with the correct value for parameter 83. 😎

Lynn,...

It should be country_id. 😀

(just kidding)

My Invoice Header dimension probably could be referred to as a degenerate dimension. It was created to hold values that apply to the whole invoice for cases where a separate...