🙂

http://www.sqlservercentral.com/columnists/jselburg/2824.asp

My experience with SQL Prompt has been nothing but excellent. Granted our production DB has about 500 procedures and only 100 tables and 50 views, but it works very well.

I'm...

Jeff,

*laughs* ....

Yes, but this was posted in the 2005 forum as well so I had to submit it here as well. 😀

CREATE TABLE #tmp (yourField varchar(100))

INSERT INTO #tmp (yourField)

            select 'Val1'

  union all select 'Val1'

  union all select 'Val1'

  union all select 'Val1'

 ...

Basically put, in the Color property box of the control you want to control put ...

=IIF(IIF(Fields!yourFieldName.Value="N/A","Gray",IIF(Fields!yourFieldName.Value<0,"Red","Black"))

Another tricky solution is to use some fields/cells in your table. Basically what you do is...

1. Using an unused cell in your table

1. Set it's color to White
2. Set the canGrow to FALSE
3. assign...

I humbly submit this link to my article. This is one methiod that allows you to name and manage your subscriptions, as well as adding the ability to have Data...

Look into "Custom Code"

http://www.odetocode.com/Articles/130.aspx

I think this is exactly what you need.

I know this is a SQL 2000 forum, but here's the 2005 solution....

CREATE TABLE #tmp (yourField varchar(100))

INSERT INTO #tmp (yourField)

            select 'Val1'

  union all select...

Use..

execute procedure t1 @fiscalyr, @beg_site, @end_site

and make sure that your parameter names in the report are named fiscalyr, beg_site and end_site.

The code in the article has been updated, sorry about that.

select d.dept_id, d.dept_name, d.[name] from dept_heads d inner join emp_names e on d.[name] LIKE '%' + e.[name] +'%'

select rtrim(Address1) as Address1 from .....

You might find this article both interesting and helpful.

http://www.sommarskog.se/dyn-search.html#Umachandar

FYI, when you reference a column from the LEFT JOIN'ed table in the WHERE clause it creates an INNER JOIN.

This is another way to handle it ....

SELECT

  empper.first_name