do you mean for all rows? If so, you can do a SELECT and use the + operator to concatenate fields.

SELECT name + CHAR(13) + class + CHAR(13) +...

DATEADD is the way to pick the dates based on today, as ALZDBA has mentioned. You can read more about it here:

http://msdn.microsoft.com/en-us/library/ms186819%28SQL.90%29.aspx

I agree with Jack. Why do you need to loop?

If you are working on position, you would have to have some column that lets you now what order is where. Once data is in SQL Server, it has no...

It's an interesting question to ask of people. I think that we are all givers and takers, but at different points in our careers. I know many people that don't...

I tend to agree with Gail that I'd just index the fields. If there are specific values that you need to pull out, you could add a computed column that...

As Bru mentioned, you haven't joined TableA, so you might end up deleting everything in that table. Only one table is affected, but how it is affected depends on your...

Nice names, and "No RBAR" might be the best one for a boat. Thanks, Jeff.

Thanks, and I appreciate the kind words. I'm enjoying this now, and while I do think about leaving at times, I still enjoy this and the personal answer I keep...

You can use the RESTORE commands from SQL to get this information, like FILELISTONLY (http://msdn.microsoft.com/en-us/library/ms173778%28SQL.90%29.aspx)

exec xp_sqllitespeed_version should give you the version, which you likely will need.

to send the files...

the dateadd is not commented out, just the note.

SQL is only precise to .0, .3, and .7ms, therefore you can't have .1 as the answer. It could only be one...

Good article, Seth, and a nice explanation of the issue. It's not always easy to do things up front, especially when you have business reasons for not putting resources into...

What is your trigger doing? A trigger that inserts data into another table would not affect the application.

You can run traces and collect that data when a particular table is...

Doh! You are correct. Didn't check the forum. Those are 2005 and later solutions.

In 2000, if you didn't start the restore with the STATS parameter, you won't get this

http://msdn.microsoft.com/en-us/library/aa238405%28SQL.80%29.aspx

Apparently not doing much networking with this one.