Hit BOL (Books On-Line). If, after reading, you still have questions just post your question on SSC and I'm sure some one will help you out.

😎

You'll also have to secure the backup file itself. The file is not encrypted, and if the system admin can move the backup file to a local system (desktop)...

First, the while loop makes this code RBAR (a Modenism for Row By Agonizing Row). Also, it looks like it may have to do a table scan for each...

And here is my version:

set nocount on;

create table dbo.OrderHdr (

OrderID int,

FirstName varchar(25),

LastName varchar(25),

OrderDate datetime,

...

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?

😎