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...

I think I'm going to have to do some reading.

The preference is to use the first rather than the longest, or first/last in the alphabet.

But honestly, I'm new at this...

I have never used Rollup,

I need to check that out.

That is what I was thinking. I was trying to figure a Case method but couldn't come up with one.

Actually the DB isn't mine (DB9 using a Linked Server)...

Yep, oddly enough that was the first thing I asked them when we got to this part.

And the answer is....

'Oh yeah, we had this problem before with a new hire....

Hi Gail, hope everything is well. How are things abroad?

Ah well, since you asked. I personally would not use this as an index for the very reason you...

Hmm, that was so easy I'm embarrassed.

But then you had to go and bring reality into it.

How about KP1 and KP2? hehe

What would you suggest?

Thanks,

I may have to try that.

The on-going saga of upgrading to SQL2005, sigh...

Now the DBA is updating statistics nights. On the table (tbl_PR) that has a bulk import the Stored Procedure executes and update...

Grant,

There are quite a few pay types. However I've already started looking to reduce the Where clause.

I was also looking at a temp table for the OpenQuery...

Thank...

Oh I read your blog before replying. Nice job by the way.

Since we just upgraded I'm not sure now often (or if) the admin is running Update Statistics. ...