Will you ever have part of an order confirmed but the other part isn't? That seems illogical to me, but that's what this table allows.

If an order will be...

You can split on the slash pretty easily, but the rest is trickier. For example, will you have any names that don't have a middle name? How about...

Run a server-side trace, and query that.

Look up sp_trace_create in Books Online for details on how to do that.

Here's a sample:

declare @ID int, @FS bigint, @FilePath nvarchar(245), @1 bit

select @fs...

Simply put, the first query uses the leading edge of the index you posted. The first column in the index is part of the Where clause. That's optimal...

I have to say I haven't yet run into a situation where I'd want to do this.

Does RedGate's backup product use the SQL backup engine? I don't see how...

homebrew01 (1/12/2010)

---

Thanks. If I'm hard up, I'll try that. The rest of the world has a nice little pop-up...

Have you tried using the site search for your username? Does that give you what you need?

Sounds like a good idea.

Till it's implemented, you can get a list of the topics you've subscribed to (which usually happens when you post), at http://www.sqlservercentral.com/Forums/TopicSubscriptions1.aspx. That can help...

Nope. Not really.

If you want to use a stored procedure in the From clause, I believe that can be done with OpenRecordset, but I have to admit, I never...

Looks like. There's a list of them here: http://html-color-codes.com/

Edit: Occurred to me that you might be looking for how to color code, like this:

select 'red' from sys.columns;

If so, that's...

What tool are you using for the import? The Import/Export Wizard? OpenRowset? SSIS?

The answer will depend on which one.

Pretty much, it will boil down to handling the...

The only way I can think of to do this would be dynamic SQL.

I'm not entirely sure what you're trying to accomplish here. Is this intended to create a list of columns to select from a table?

If so, you can do that...

GilaMonster (1/12/2010)

---

Johannesburg, South Africa. For anyone who's geography a little weak, that's at the southern end of the African continent.

Yes, we have electricity and internet (most of the time), we...

Tampa, Florida

Moved here from Houston, Texas (more precisely, from Katy, Texas, outside Houston).

Moved there from Washington, DC.

Moved there from Missoula, Montana.

Moved there from Los Angeles, California.

Moved there from Seattle, Washington.

And...