This is just another idea, I don't know if it is of any value for you.

We have one package that includes 30-40 lookups. We had to split the flow into...

Andrew,

I also used your approach - in a project some years ago - to create all possible procedures. If you do this in advance, your users do not need privileges...

Did you try sp_refreshview?

Perhaps the structure of your underlying table(s) has changed...

Ola

I happened to have a UDF in my test box that returns a set of numbers, so it was very easy for me to put this together:

select

case...

This is maybe not the best option. But I needed to do a similar thing yesterday and ended up converting the input string to a 19 char string.  This way the milliseconds...

Yes. We too switched to Microsoft. No problems ever since. (The driver is slower though. At least when previewing data.)

Ola

John,

Obviously, FT search is the proper choice.

When reading Joseph's first post again, I realize he needs to put BOTH leading and trailing wildcards. My suggestion fits, when there is only a...

I have had to implement something like this on a MSDE, where FT search is not included.

I then added a column 'ReverseName' thats stores select reverse(Name). Whenever a search condition...

I may have completely misunderstood your intention. But if what you are looking for is to get only the Respondents who have completed all Surveys (or whatever the StatFlagId represents), then...

This can be a useful link : http://www.sql-server-performance.com/awe_memory.asp

Enable the /3GB switch in boot.ini