No.

No problem... it's the beauty of a forum... world's biggest team. 😉

You CAN have file names with spaces (although, I prefer not to). And, you can easily run commands on those file names by enclosing the filename in double quotes......

What the heck is the matter with using Replication?

And, yes, it's easy to dump that into a temp table...

Yes, this can be done using an alias. Example:

SELECT t1.col1 AS t1_col1,

...

Considering that the drive to work is 112 miles round trip, I'd love to see my company implement that right the heck now! 😉

Just to be sure, I'd add a check to make sure the numbers haven't already been updated...

UPDATE dbo.Table1

...

Being a bit of a skeptic, let's see the test you did that proves that....

What's wrong with just...

--===== Create a test variable (not part of the solution)

DECLARE @test-2 VARCHAR(8000)

SELECT @test-2 = '[8/15/2008 10:44:14 AM] [MESSAGE] Batch Archived:[869] nameOfBatch;Archived Path:\\servername\directory\subdirectory'

--===== Return the path

SELECT...

I think you're missing some data in the other tables. Also, you'll get a much quicker answer if you format the data as outlined in the Link located in...

Not only should you have a clustered index on a table, even if the column is an unused identity column, but you should have a unique index somewhere on the...

Thanks for the awesome compliment, Timothy.

It depends on what the client is comfortable with... some won't allow it as a permanent table so I have to code it in where...

Paul DB (8/15/2008)

---

In an effort to prevent the edges of other people's butts from getting sore, can you (or the editor) please modify the Hidden RBAR article to refer/link to...

Steve Jones - Editor (8/15/2008)

---

I'm not sure which article Jeff meant for the followup, perhaps this one:http://www.sqlservercentral.com/articles/Test+Data/61572/

You can click on the author's name and get a list of all his...

kathyoshea (8/15/2008)

---

I've never really gotten a handle on execution plans and was hoping to use the code in the article to understand them a bit more. However, the code in...