Hi,

My requirement is to calculate the Maturity Date - (Yr_Num+Month_Num+Last Day of the month) and here we have to take Maturity date from one table and Year no,Month no. from...

Hi,

My requirement is Maturity Date - (YR num+Month num + Last day of the month).

Here we have to take Maturity date from one table and Year no. and Month no....

Hi,

Thanks a lot for your reply.I need to do it to test Proactive caching.I need to test the data by inserting/updating/deleting rows and see with which Storage mode I'm achieving...

Hi,

Does anyone know how we can print the report along with the plus/minus signs in the drill down report.

Thanks in Advance,

Samyuktha

iPolvo (12/19/2011)

will the updates, deletes, inserts only involve recent data?...

I think so,but not sure about this.

Thanks a lot for your suggestions.

But,this is the Initial phase of design document.

Please suggest by taking this into consideration.

I just have a data model and some report specs which we...

Thanks a lot!

But,there will be Updates and deletes too along with Inserts.

What is your suggestion.Which storage mode can we use.

Even if I'm not including null values its showing the same error

insert into AdventureWorks.Production.Product(ProductNumber)

SELECT

TOP 400000

ProductNumber

FROM AdventureWorks.Production.Product

CROSS JOIN sys.columns s1

CROSS JOIN sys.columns s2

ORDER BY 1

I wrote this Query.

But its showing error saying

Cannot insert the value NULL into column 'Name',...

I'm new to SQL server.Please do help me with this

Yes Eric.

I want to add more data to the existing table.I think we need to enter data into the Fact table so that it gets reflected in the other tables.

After adding these additional 400,000 rows, I need to check my SSAS cube whether its processed immediately or not.

So,Please let me know in this scenario.

What is the exact script to...

How to do that?

I need to add rows to the Adventure works DW table.