Oh yeah... almost forgot... the method I described that uses multiple tables, a constraint, and a view to make a "partitioned" view, is being deprecated. If you have no...

As already stated, this is a very bad idea because of several reasons and I might be missing a couple...

1. First of all, by definition, a "column" in a...

As Seth's good question implies, the idea of reusing numbers or recovering missing numbers in an IDENTITY sequence is something you should consider not worrying about at all. Contiguous...

Nicely...

We assign all such ownership as "dbo"... prevents such hassles in the future.

SSIS, CmdShell/BCP, OPENROWSET, or Text based linked servers... each of which are in Books Online.

You could also make a view from the two tables without much, if any, impact on performance because it'll just be doing the same joins that you're already frequently doing...

SELECT * FROM #MARKTABLE

WHERE MARK NOT LIKE '%[^0-9.]%'

DOS batch job with a VB Script to popup an input window. Either that, or a "control" table that will remember the last run date.

Why on Earth do you need to create what is essentially a...

Chad Crawford (12/17/2008)

---

Alright, if there are no opinions on the issue, how about suggestions on the question? Too long? Not enough detail? Boring title? Too complex?...

Dejanette,

It would be a huge help to us if you'd post the actual data you're trying to sort in a readily consumable format along with a table creation statement. ...

I've gotta agree with the others... if you want to split out dates and times, particularly formatted dates and times, AND you think you shouldn't follow best practices by doing...

dphillips (12/17/2008)

---

Jeff Moden (12/12/2008)

---

Heh... I've found that helical fletching makes a high velocity pork chop sound really cool as well as enhancing the flight path... haven't gotten into the bowyer...

gcopeland (12/17/2008)

---

I always have to explain to tech gurus that, in business, the only poorly written system is one that doesn't meet customer requirements. I agree that it should...