Hi Jason...

Yaa we use Visual Studio 2008....

Is there anyway we can do it from Visual Studio ?

Hi Jason,

Thanks for your response and i tried that but the problem its not giving column level details.

If we want till table level i think its best tool..

Regards,

Krishna

Hi,

By Any chacne did you update the Source query of fact table in the DSV like adding new columns like that if so...you also need to update the same query...

Thanks for the suggestion...now i am not getting any error

Hi Jeff,

I just modified your code little bit to get count at the month level instead of day level and wants to drill down day level at report instead of...

Hi Jeff,

Thanks for your reponse and the code...

However becuase of some design constraints...i have to implement the logic at the Datawarehouse level and i dont want to create extra rows...

Thanks for the info.....so basically i need to create a XSLT file for my XML file so that i can use XML Task Editor for the conversion.

This is really awesome...thanks...

Thanks for your suggestion ,however our team is looking for something Open source.let me know if we have something like XML Spy which is open source.

I have the XSD...

Hi,

Thanks for your response ,I know we can do it in T-SQL, however my output needs to be XML.

So I dont see any need to populate CSV data to a...

Other way of doing is to use staging table...

First insert the data from excel to a staging table and then write union all Query on the staging table to...

Hi Gail Shaw,

So you mean to say its another way of appling unique constrain ...?

Thanks to everyone for the quick response.

However there is one more clarification i need...I.e ..what is the need of NonClustred Unique Index..?

Thanks for the responses ,i really appreciate your help...

Yaa...if they use windows authontication...I dont have to go through this pain.....

Anyway thinks for the Idea ,I will try to find out reasons behind using sql authentications. instead of windows...

Thats...my plan B..:-).