Jeff, I would never have thought to use parsename on an IP address, but it makes perfect sense because it has four elements separated by periods. Tell me...

No heretical rebuttals from me. I just want to know if they are using that column to enforce a sequence.

Barkingdog... can you please explain WHY you want to reuse those numbers? What you want to do isn't impossible, although you couldn't designate the column to be...

Create a concatenation user function and use it in a summary query.

Here's a great write up by Jeff Moden. Let me know if you have...

Just brainstorming...

Using views to simply alter fieldnames costs very little. Ever think about having a separate view for each project? I've never done this in...

For an exhaustive discussion on a similar topic (Finding the next Sunday, regardless of datefirst setting) take a look here:

http://www.sqlservercentral.com/Forums/Topic606669-338-1.aspx

The UNC is a good idea. I have often seen people trying to BCP files from drives on their personal PC rather than the server. (I've...

Think about doing a query to list names contain more than two strings (more than one space '% % %'). You will want to change those individually. ...

This is yet another reason why it is a good practice to always qualify your column names to be specific...

Dear Joe,

Two different views or tables make this a totally different problem with a totally different solution. Are you doing this project as a class assignment by...

What if I have a table which has multiple columns and those columns contain the dates and I wish to merge those dates columns into one new column? Do I...

It's a small lake....

Besides, there's just something so aesthetically satisfying about watching a trebuchet fling (pork chops, tennis balls, cans of vienna sausage, cats, volkswagens, whatever) 😀

Joe,

My error and my apologies. I thought there was a link. I must have been hallucinating.

Here is the link in MS-Help.

ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_1devconc/html/24ba54fc-98f7-4d35-8881-b5158aac1d66.htm

Seth,

Thanks for...

Aw rats.....

(putting down borrowed pile of pork chops)

Why not just declare a second table variable? It's a trivial cut-and-paste and will start all over again with the identity values. If you...