Jeff,

Dunno if I explained that all clearly... lemme know if you have any more questions

Let me get a cup of coffee first. I'll get back to you afterwards. Now, where...

Jeff,

I was myself one-upping the while loop joke, this time with actual real life examples, not even a joke. (Hah ! Amateurs!).

Regards all.

Using "INDEX(0)" is a later manifestation of the code... don't need to know the name of the clustered index that way and that allows you to easily use this on...

Heh... Pork chops away!!!

And don't even bother to use a latex-free launcher.

How about posting YOUR solution ?

Gary Noter

[snip]

I'll call this the "WHILE Loop-hole" in my Billing Secrets blackbook !!!

OK, two things on this,

1. I remember reading about a BIG computer company where...

My application has a relatively small number of records (about 15,000). Of these, about 3,000 have a picture. These are jpeg files, about 50 kBytes each.

Access speed is no problem.

I...

Except he's not trying to make them uppercase, he's trying to make keywords(and only keywords) all lower

OOPS ! Missed the "lower case" part. That ARBITRARY one indeed runs contrary to...

"You should not, but if you must" ...

From Enterprise Manager

Select your database. Click on right-hand mouse button. Click on Generate SQL script.

In the first tab, "General" click on the...

"Thorn"

wut?

To get the name of files in a directory, I suggest you review this article:

Accessing the Windows File System from SQL Server

Written By: Edgewood Solutions Engineers -- 6/12/2007

Would you pleae humor my curiosity and give a short description of what kind of an application generates a terabyte of data ?

"if we exclude the performance point ...is it possible to have these many indexes..."

Why bother with indexes in the first place when the performance is not even a consideration ?

What's...

Dave,

Thanks for the comments. I knew about the snail mail purpose for the extra 4 digits on a zip code but that they are subject to change was new info...

As suggestged by Jeff

[font="Courier New"]CREATE PROCEDURE stp_CONVERSION_INIT_UPC_Table AS

-- --------------------------------------------------------------------------------------------

-- THE CCCCCC-NNNNN-P UNIVERSAL PRODUCT CODE IS AS FOLLOWS:

-- ...