It's Tuesday, that means another snowstorm here in upstate NY.

Learned a little something today, thanks.

Lemon Zinger

I would probably create a cte or temp table or table variable that summed the work order total hours in a column next to each employee's hours for that work...

On ServerAB, configure a linked server to ServerCD. Then once your linked server is configured properly you just write your query on ServerAB, when you reference the data on...

Set your parameter to get available values from a query.

You say that

but it should be

What happens when the number is 2.35500000 does it return

2.35 or 2.36?

If it returns 2.36 you are encountering something...

Hey Steve,

I didn't know about this issue either. Thanks for posting the script. This will definitely be a useful addition to my code library.

Thanks,

Peter Trast (1/27/2011)

---

Inconceivable!

(yes, I know what it means 😉 )

(never get tired of that one, how many times has it hit this thread? Never??? I cannot be the first......

telecommute

If paramater b is a multi select it should show an All choice. Selecting the all choice will return all the items in the multi select list, not just...

Government

As far as I know you have to write an expression for each column's visibility

I assume that since the stored procedure runs overnight that it is tied to an Agent Job. Add a step to the agent job using "sp_start_job" that executes another...

I have a similar requirement that I haven't finished building yet, but here is what I think will work

=IIF(InStr(JOIN(Parameters!ParameterName.Value,", "),"ValueToTestForColumnVisibility"),True,False)