most connectivity issues I've run into has more to do with server name resolution or DNS than anything else;

for the connection string, are they using the machine name, an IP...

recursion has it's place, of course, but it does not serve string manipulation...

yeah, i think you'll need to use a loop from 1 to datalength(@inputstring), and appending the char in reverse order.

recursively calling a string that fiddles with one or two...

a unique index is just that: a constraint and index that prevents duplicate values.

unique means you can't have 2 nulls in the table., one NULL max.

it is up to you...

Grant's advice is important: bad statistics = bad execution plan.

update your statistics on your SQL2005, and see if your old query performs better.

if your UDF is doing the same code...

valuable info Grant; i did not know that about linked servers vs openquery... Thanks

i'd need the real data to test, anything I say from here out is speculation.

ok we know the server is trying to compare BIBAC to ACCOUNTNUM;

we know that the server...

Rowan try this method instead; I know a left join is my preference, but I think tat because you are doing 4 operations on the column BIBNAC, and 4 operations...

is the query using a linked server in SSMS to go to a MySQL Database used by PHP database?

Is PHP Connecting to a SQL2005 database? I know PHP with MySQL...

sounds like nested case statements might be what you need, but it's help enourmously if we had some sample data and expected results;

are you trying to identify where there are...

the trick here is to join a table against a copy of itself...to do that, you need to alias one or both tables;

something like this is pretty close, use this...

I'm making some minor assumptions, and changed your query accordingly;

if there is an employee id in SGA_Labor, we KNOW he has a name, right? so we can assume that the...

if you were to post CREATE TABLE... information, as well as the INSERT INTO...scripts, we could help you much better; even with your followup answer, it is still not clear...

I'm not sure oif the requirement.

Do you want to be able to see all the statuses in Database7, if one gets added in Database5 for example, or do you want...

can't you just do the following:

build a new table on your secondary file group with the same structure,

insert into it,

rename the old

rename the new?

isn't that effectively what...