Hi,

we have built the date warehouse with snowflake schema and also it is difficult to process the incrematal load . so any suggestions on this could be more use full...

http://www.mssqltips.com/sqlservertutorial/2000/sql-server-analysis-services-ssas/

Deadlock:- A deadlock occurs when two or more tasks permanently block each other by each task having a lock...

If we set...

can you share the solution which you found ?

Hi, friends thanks for your reply and quick response

Ken McKelvey (11/17/2011)

---

I think you are going to have to calculate the hour and minute values separately and then combine them.

You will probably have to use both a Calendar and...

Cadavre (11/17/2011)

---

I don't understand how you're working out your "Peak". Explain that part and I'll edit the script. Also, I think you've missed out the 3 records that...

Cadavre (11/17/2011)

---

SLNo Date Time ...

im expecting the below output

SLNo Date Time Total...

Hi Guys , Thanks For your Reply

Regards - Deepak

I have asked peoples who are interested in reading FQA's the most frequent asnwer i heared is to get the good job by memorizing the Q & A ,...

Hi stewart,

Is there anyway we can achieve this using script task or script component ?

Regards -Deepak

Hi Stewart,

Thanks for your reply , but the solution is not meeting my requireemnt , i want to generate the separate excel files dynamically for each locations.

Regards

Deepak

Suresh B. (11/3/2011)

---

Yes. There are reasons to avoid DETACH/ATTACH.

Mohammed Moinudheen has already mentioned a good reason.

If replication is involved, do not use detach\attach method. You would have to drop replication...