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

All I did was confirm your code is essentially the same on my SQL2005/1Gig ram 2.8 machine.

My first guess was because you were using a @table variable for your Tally...

Extract, transform, load - Wikipedia, the free encyclopedia

basically getting data from one source and bringing it into anohter , realtime would be as it happens or changes.

i think you are after this command, which allows you to see structure of tables(but not hte data), as well as the text of procs and views, right?

GRANT VIEW DEFINITION...

you'll want to simply Add these commands to the top:

SET STATISTICS IO ON

SET STATISTICS TIME ON

--SET SHOWPLAN_TEXT ON

then run your two queries together....actually run them a couple of times...

the query i posted...

ok i'm guessing your query got changed to make it less complex for the web...

but there seems to be a some steps tha seem weird to me.

if you yank out...

there was a similar thread on the issue, and even though the person had updated usage, updated statistics, the issue did not clear until they DROPPED their current statistics, then...