In which cube browser?

Measures in the cube have a format string property that most browsers seem to support.

Anyone catch the question before it was edited?

http://www.sqlservercentral.com/Forums/Topic614696-146-1.aspx

Go Steve for calling someone's question silly...

You mentioned GUID's. Do you have a clustered index on a GUID on the table? If you do, I would recommend you try to find another field you...

The answer is no. You would not always want a covering index.

In your example, you are referring to a table that is used for a specific report that calls...

Do you have some reindexing or other maintenance happening on the SQL 2000 box at night? A lot of maintenance is logged, so it may be causing numerous transactions...

Yes, but the syntax does not use IF or ELSE.

It uses "?" and ":"

@Var==1 ? "A" : "B"

Will they be in the same folder?

One of the simplest ways to deal with this is to change the name of the file or copy it to a static location...

What are you planning on using the output of this for?

It's a rather ugly design regardless, but it will make a big difference in what you can do if you...

I am not sure you understand web-based software development. "Most" web-based applications are thin clients that do not require anything other than a web browser or possibly a plug-in.

I...

Can you post more about what you are trying to accomplish rather than how you are trying to do it? When you find yourself trying to run dynamic SQL...

If you are building a web application, isn't your client just running a web browser?

I am not sure how you want someone to respond to this post. Do you want someone to answer these questions so you can interview someone else? Are...

To start with, right-click in the middle of the control flow and select "Logging" to turn on package logging. This will log events such as starts and ends of...

That custom component is a nice find.

Thanks Jack.

You can convert or cast it to a VARCHAR and strip off the time:

SELECT CONVERT(VARCHAR,GETDATE(),101)

Look up CAST or CONVERT in books online.

If this is just for display purposes, stripping time...