TS.Skill IN (@TS) works perfectly. I don't know if the drop down list of the SSRS parameter creates a a comma delimited string. I didn't think that was what was...

P.S. If I use
Where
  HRMst.ActiveYN = 'Y'
  And HRMst.Co = @Company
  And TS.Skill In (@TS)


It works with multiple selections, but that doesn't...

I don't believe it is a comma delimited string; I'm still relatively new with SSRS. The program, if...

Wow great ideas. I've never thought of that.

Thank you,

I found it....

The values are not real they are numeric(9,2). I'm still not sure why they were rounding but at least this fixes it.

I'm not sure what you mean? ...

Got it....

dumb

hehe, and it's not like I haven't already had those issues.

Well, here I am thanking you again for your tremendous help.

I do appreciate all you've done for me.

Is there any way to have temp tables in an ITVF?

What would accomplish the same thing, which is cutting down on the data coming from the linked server?

My example didn't...

That's what I thought, I was just trying to jump ahead.

Thanks for the ITVF that, hopefully, will solve my problems

Is there anyway to declare a variable inside a ITVF or MTVF?

i.e. If the input Parameter is @Co_No nvarchar(3)

Then inside the ITVF you would find:

Declare @MySql_01 nvarchar(4000)

Declare @MySql_02 nvarchar(4000)

Set MySql_01...