Thanks, guys.

Your comments did me more good this morning than my first cup of coffee (which I have yet to pour).

Flo: ...

I see your difficulty. Maybe a simple SSIS package?

Jeff you were posting while I was funckifying.... 😛

Congrats on the 20k. They should create a Golden Pork Chop award and pass it on to future recipients...

If you're going to run this against sets of rows, consider writing it as an inline table-valued funcation.

CREATE FUNCTION dbo.tfn_DotSplitFuncation

(

@OutlineNumber VARCHAR(1000)

)

RETURNS TABLE

AS

RETURN

(

with cte (outlineNumber) as (select...

When I select "Results to File" in 2008, I receive the following message, just as if I had selected "Results to Text" or "Results to Grid". I...

When the company I work for was still in the start up phase, several of us used to take LONG walks while discussing issues at work. ...

Hope all goes well, Barry. You'll be in our thoughts and prayers.

Congratulations Jeff, and Paul... and Jason.... and everyone else deserving of congratulations.

I am 600...

I hadn't realized you were going to tables with a different structure. I don't think you are going to get away from having cross reference tables, but...

Please post the schema you have created so far. It is far easier for the volunteers trying to help you to deal with specific code than with...

This sounds like yet another attempt to make a relational database into some sort of object-oriented framework. (Good luck with that, but be advised that you're not...

You beat me to it, Lutz.

According to BOL, both REAL and FLOAT are:

Approximate-number data types for use with floating point numeric data. Floating point data is approximate; therefore, not all values in the data type...

Thanks to you both for posting your sources. It's always much better to see a cite something than to rely on "I heard that... " statements....

Keith,

To handle concatenation of nulls, you need use either the ISNULL() or COALESCE() function. One hint, it is sometimes best to test whether or not...

David, do you have any source authority that UPDATE is going to be deprecated or is that just a personal opinion? Despite your characterization of it...