why are the second and third rows in the desired result set duplicates?

When you say the user shouldnt see the other databases i assume you dont want them to have the databases listed in the tree view on SSMS ,this wontbe possbile...

Video on using SSDT to perform schema compare

If your looking for comments on the code behind

try catch block and validations come to min.

At database side date format and timezone info could be useful.

You could use some...

Is there a question here ?

GilaMonster (9/7/2015)

---

Rollup generates a grand total row, which was not asked for. Easier to use Grouping Sets to just get the totals needed...

Jeff Moden (9/7/2015)

---

Minnu (9/7/2015)

---

Hi Team,

I have a list of 100+ tables in my SQL Database with most of the columns are declared as VARCHAR, I want to create the same...

GilaMonster (9/7/2015)

---

Jayanth_Kurup (9/7/2015)

---

Find and replace will change the varchar to nvarchar but you still need to account for the increase in the column width now. I think dynamic sql might...

Have you checked the sql syntax for the partitions being processed , are they same in all aspects except the where clause ? do they overlap in datasets ?

seems your getting dimension processing errors , have you tried processing the cube by changes the default processing options, can you post the xmla being used to process the...

after install you can check if the service is started and then connect using SSMS , if post insall the summary shows just green Tick marks then you dont need...

you need to use Group by ROLLUP

The error is there in the message it self , login failed, and thus couldnt qcquire connection manager , make sure all the logins and passwords are correct after the...

Find and replace will change the varchar to nvarchar but you still need to account for the increase in the column width now. I think dynamic sql might be the...

Tail returns a set you need {} aroud the measure m9