The localhost server, is it the default instance?

The best way would be to use a stored procedure, to which you pass @database as a parameter.

Inside the stored procudure, you construct a dynamic SQL statement using 3 part...

Is it necessary to duplicate all tables for each client, even if it is in the same database but in a different schema?

rupesh.rams (8/9/2013)

---

This issue with the log file size.You can verify the below url to rectify easily.

The transaction log for database 'mydb' is full. To find out why space in the...

The thread I mentioned gives some examples.

This article takes a lightly different approach:

SQL Server Reporting Services Using Multi-value Parameters[/url]

It uses a splitter to split the parameters, put it into a...

Essentially they do the same, but you CONVERT has an optional third parameter you can use for formatting (mostly for conversions between dates and strings).

CAST is defined in the ANSI...

The flight recorder is the log for Analysis Services.

Maybe the disk ran out of space?

A cursor is horrible horrible thing. You usually try to avoid this in SQL Server and go for a set-based solution.

This article describes a very performant function to split your...

As I read this thread, it doesn't seem to be that easy (maybe Brian used integers in his video, which is a lot easier than strings):

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/c02370b5-aeda-47ec-a3a8-43b2ec1e6c26/reporting-services-multi-value-parameter

You need to parse the...

kl25 (8/8/2013)

---

Interesting topic. I've been...

aaa121 (8/8/2013)

---

Thanks for your time on this. The conclusion I kept coming to was two fact tables as well.

What did you think about the mini dimension solution for those more...

Which permissions does the role have?

The number of rows is not a problem.

If the number of columns are dynamic, that's a problem.

Another one of those A-HA moments, was when I discovered you could select a block of text in SSMS while holding ALT (which is also possible in other Microsoft products).

Really...

Jeff Moden (8/8/2013)

---

There are even "language gaps" right here in the U.S.A. In the mid west, if someone were to say "I have a silver colored truck", I would...