The first step I would take is to sit down with the Business and the users and establish exactly what they want / need. This will help you establish what...

Just one thing that jumped out at me:

Current architectural setup: We have a reporting database environment set up with 5-8 databases or components. This is highly normalized relational data set...

Mark Fitzgerald-331224 (4/26/2012)

---

kishore.sqlbi (4/25/2012)

---

I have table like this.

Name email ...

Hi

In what way is it not working what are you trying to achieve?

Andy

Your welcome 🙂

Hi

Its very difficult to help without table structures and test data however you could try something like the following:

SELECT *

FROM

(

ProductCode

,Date

,Value

,ROW_NUMBER() OVER (PARTITION BY ProductCode ORDER BY Value DESC) AS RowNum

FROM

Product

)...

opc.three (4/24/2012)

---

sql_ques (4/24/2012)

---

Hi,

When I export SSRS report (2008 report server) to excel the formatting is not the same as in report server. The rows are merged and collapsed. Is there...

So if I understand correctly you have a date parameter and for example if you select 01-03-2012 - 31-03-2012 the chart displays correctly however if you select 01-01-2011 - 31-12-2011...

GilaMonster (4/18/2012)

---

ravi@sql (4/18/2012)

---

Merger Join -- if the both left and right tables are sorted then merge join will take place.

Nested loop-- If the left side table having less number of...

Sorry I don't understand what you need, why is it wrong, what are you expecting to see?

If you can provide DDL's, sample data, expected results and a better explanation this...

Hi

I would certainly split them into 2 separate Dim's.

It used to also be agreed that all date and times should be converted to join onto the relevant Dim's however if...

I'll throw you a bone on the first question:

Think about it a primary key ensures a row is unique...

Aside from that google...

I got the impression that no rows were...

In SSMS right click on the database and script database as. You then just need to select the objects you would like to include in the generated script.

Andy

If you stick a data viewer between the OLEDB source and conversion and between conversion and destination, then you can check to see if any rows are going through the...