Ok thanks for the update Steve, I thought it used to be a white font. Must be a change in how my web email client is handling it then.

Jack Corbett (4/9/2009)

---

Have you posted all the code you are running? When I run this (I have to create the table first since I don't have it):

IF OBJECT_ID('temp') IS...

Can you post your fix, to help anybody else that does a search on the same issue?

If you have SQL 2005 and have the reporting pack installed, you can right click on your database, select reports->standard reports -> Disk Usage. Below the graphs it has...

jaimearqueza (11/24/2008)

---

Hi SSC

I tried your suggestion and it seems to have a progress. However, how would I pass two parameters to it. I actually created a link from the summary...

Books Online Reference: http://technet.microsoft.com/en-us/library/ms155391.aspx%5B/url%5D

http:// /reportserver?/Sales/YearlySalesSummary&rs:Command=Render&rs:Format=HTML4.0&rc:

Parameters=false&Year=2002

The rc:Parameters=false hide's the parameter's prompt in the report.

http://ReportServerURL/reportserver?ReportPath&rs:Command=Render&%5Bb%5Drs:Format=EXCEL%5B/b%5D

I think this is what you might be looking for. This will give you a direct link into the report that will open in Excel format so...

Sorry Jeff, I did not notice that the function had an embedded function in it.

Thanks for the assistance.

I've also seen this approach taken when looking for GUID's in a input list of GUIDs. This method looks up every value in the table in your list of...

Have you tried something like this? I found it in the built in templates under calculations for the cube. The function template is called moving average under the...

IF Exists(Select * From inserted Where ContactId > 10)

BEGIN

Insert Into Person.ContactLog ...

This should also work for you. It uses the built in pivot function, and it save join and case statements if you wish to add another phone type to...

I might try looking at replacing the table in your Data Source View with a "With New Named Query". To find this right click on the table and select...

SELECT

Case

When LT.Quantity/60 = 1 Then

Convert(nvarchar(10),LT.Quantity/60) +' Hour'

Else Convert(nvarchar(10),LT.Quantity/60) +' Hours'

End + ' ' +

Case

When LT.Quantity%60 = 1 Then

Convert(nvarchar(2),LT.Quantity%60)+' Minute'

Else Convert(nvarchar(2),LT.Quantity%60)+' Minutes'

End As [Time]

I...

This is the space that the table has reserved for it's self though table growth. Have alot of records been added and then removed from the tables? as this...