Apologies. Here it is....

round(cast(sum(columnname) as float)*100,3)PrcntSvcLvl

Thanks so much for the quick reply and the tablix/matrix tip. I figured that it wouldn't matter but wanted to be sure. I have a deadline for next Wednesday.

I am going to do this conversion on SSRS when I get authorization to complete this install. Thanks for your help all!

People are complaining that they want to see the number as 15.385. I am in the process of setting up a report server so that will be later. I need...

This isn't working. Please tell me what I am missing...

cast(DATEDIFF(hh, segstart, segstop)+':'+DATEDIFF(mm, segstart, segstop)+':'+DATEDIFF(ss, segstart, segstop)as nvarchar(25)) as a

Is there a way to mark a question as answered in SQL Server Central?

Thanks

Thanks for the reply.

So, would you say that it makes more sense to have a clustered index on a column besides an ID column? Seems like that would be the...

T-SQL process checking a table.

Thanks so much for your response!

Thanks so much for your quick response.

How would I write this query if it is just (- 4 weeks and 3 days)?

Precedence constrain was set to AND and not OR.

Thank you all anyway. I wish they were all this easy 😀

One more question about how the security is defined in the data source:

In the data source designer, under Impersonal Information, I selected to use the service account. Is this the...

Thank you for your quick response. I am using Share Point 2010. Here is the MDX query that is defined in the SQL Role in the SSAS cube. I am...

Thank you all for your responses.

Basically what I need to do is create a hierarchy based on multiple dimension tables. I can easily create a hierarchy per dimension table, however...

Worked perfectly 🙂