patrickmcginnis59 10839 (7/7/2014)

---

Koen Verbeeck (7/7/2014)

---

patrickmcginnis59 10839 (7/7/2014)

---

Luis Cazares (7/7/2014)

---

I'll start using Oracle :sick: at my job. As a SQL/BI Developer, it seems that most of the knowledge can be transferred...

patrickmcginnis59 10839 (7/7/2014)

---

Luis Cazares (7/7/2014)

---

I'll start using Oracle :sick: at my job. As a SQL/BI Developer, it seems that most of the knowledge can be transferred easily between tools, but...

Luis Cazares (7/7/2014)

---

I'll start using Oracle :sick: at my job. As a SQL/BI Developer, it seems that most of the knowledge can be transferred easily between tools, but I'm just...

Could you explain your problem a bit more clearly?

Take a look at UNPIVOT[/url].

Can you give an example of the desired output?

Nice question, thanks.

Be careful with all of those WITH(NOLOCK) though. Unless you like dirty data.

An example:

=FormatNumber(89.12346,2,True,False,False) & "%"

What do you get when you browse to that url?

I would just format the number and then append the % to it.

Formatting Numbers [SSRS][/url]

The book mentions at page XXII where you can download the code.

Those introductory pages are sometimes really important 😉

Which book are we talking about?

Any link?

Avoid Excel at all cost.

Export to CSV comma delimited and then convert it with SSIS to tab delimited.

Or just write a very small .NET app that replaces the commas with...

Package parameters are only for the new project deployment model.

Regarding the configurations: there are lots of different ways to handle configurations within multiple environments. Choose one and stick with it...