For clarity in my code, this is how the query should be coded:

select

*

from

dbo.Provider

inner join dbo.Service

...

Let us know which way you go. I am curious which works better for you.

😎

Matt, could be. Best thing would be for the OP to test both and decide from there. With my very minimal test code, who knows.

😎

Do you currently have periodic transaction log backups running on the principle database? If not, you need to start doing so. The transaction log is not truncated by...

In addition to the DDL and sample data, show us what the result set should look like based on the sample data.

I'm a little confused by the correlated subquery back...

I recognize the code, and it was I.

Here is a link to an article that may help: http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/bewareofsearchargumentsargdatatypes/2485/

😎

Hope this helps:

create table dbo.Provider (

ProviderID int,

ProviderName varchar(25)

)

create table dbo.Service (

ServiceID int,

StructureID int,

...

What does the data in the following fields look like:

😎

John,

Had a great time in North Platte, NE. Only problem I had was figuring out which way was north. No mountains to the west of me to help....

Here is an article that you should read: http://www.sqlservercentral.com/articles/Best+Practices/61537/

I am still confused as to what you are trying to do. If you take the time to follow the suggestions...

Under what user name is the job running under?

😎

Curious, looking at your code, are you running SQL 2005 or SQL 2000?

😎

Okay, I'm confused about what you are really trying to do. Please provide the DDL of the tables, some sample data (in the form of insert statements), and the...

ORDER BY in a cursor works. Copy my code and test it.

😎

You haven't completely answered my question. In both ID 1 and ID 2, you have a field that is blank. If that field is NOT blank the next...