Most folks use ISNUMERIC not to detect a datatype... they erroneously use it to detect if a column has all numeric digits...

You bet, guys... thanks for the feedback.

Please see the following...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=243646&p=2

Don't fight it folks... ISNUMERIC should never be used as ISALLDIGITS or vice versa.

Here, here, Kevin!  Any process other than single record GUI support that uses RBAR (pronounced "ree-bar" and is a "Modenism" for "Row By Agonizing Row") either has an incorrect database...

But, Scott does

Scott had posted the very same question on the WROX forum (totally different URL)... there, they got a little carried away...

Scott,

Just making sure you got the answer for this same problem that you posted on the Wrox forum.

This is more than ten times faster than what they posted there.  I...

I know they asked for blank lines... ask them if this is better...

DECLARE @Table TABLE(pKey int,grp int, val int)

INSERT INTO @Table

SELECT 1,1,11 UNION ALL

SELECT 2,1,12 UNION ALL

SELECT 3,1,13...

Unless there is also a date column, there is no way to "query between 18:00:00 and 06:00:00'.... maybe between 06:00:00 and 18:00:00 but not the other way around.

So, is there...

the time when i had to read books is over

Then, your career as a successful DBA is over.

Sounds like it was a bad match all the way around... it was a good thing that you bailed.  How ya doin' now?

Actually, Philip didn't write the query... I did...

Cool... thank you for the feedback.

The other articles are not the immediate concern.  Plagerism and breaking of copy right laws should be your immediate concern... I think you make too little of the good advice...

You can't and for good reason... saving a database diagram will change the database, as well.  You certainly don't want the users playing around with your diagram and hitting "Save"......

Isn't it amazing that such a simple format is so very complex programatically speaking?  Why they didn't make BCP do this a little easier, I'll never know...

This would be how...