David Lester (12/9/2011)

---

Thanks Paul, and yes I do.

Thankfully, after years of attempts, IT has ceased to be a wall. While they are still not ready to listen to me, they...

Let's keep it public meaning, no private messages unless you are planning to hire me 😀

So... as per your message the idea is to keep the data of all your...

andychurry (12/9/2011)

---

Finally, I was hoping to see what everyone here thinks of Oracle. Right now, I'm kind of down the middle as to if I should take the MSSQL path...

Do you realize we are talking dimensional...

Long time ago I saved the recipe below - credits to Nathan (no last name) who was the original poster. Let me quote:

In BIDS, do the following:

1.Click on Report...

gopalchettri (12/8/2011)

---

Hello thanks for the response.

The scenario is as follow:

ERP is web based application so there will be many different organization going to use it.

1. Yes: ERP modules need...

sun37 (12/7/2011)

---

Dev (12/7/2011)

---

Don't you need to connect Army with Soldiers? Think on...

john_nyasani (12/2/2011)

---

I am trying to change my career focus from batch scheduling into the BI,Data analytics area. I know that SQL is a powerful BI tool. I would like to...

I'm pretty sure this is homework, that's why I'm just pointing poster's nose in...

Olalekan Adewale (12/8/2011)

---

- My question is how can I place SCD type 2 on email column?

- My approach of updating the table is truncate and load, what other best approach...

ashisht4u (12/8/2011)

---

I'm new to cursor. I want to compare the b_date and e_date of two records having same emp_num.

DECLARE @emp_num VARCHAR(30)

DECLARE @begin_date DATETIME

DECLARE @end_date DATETIME

DECLARE cur CURSOR

SELECT emp_num, b_date, e_date...

Derek Markel (12/7/2011)

---

I am building a new dimensional data warehouse for the financial institution I work for and I need to include goals for various metrics such as 'Percent of...

I think that's the sensitive thing to do.

By the way, have you checked Metalink note #370921.1 "ASM - Scalability and Limits"?

Please take a look at this: http://sqlservercorner.blogspot.com/2009/03/linked-servers-for-64-bit-sql-2005-sp3.html

You are correct Lowell.