Exact space in varchar ?

OK, let's say you saw the obvious patterrn for telephone numbers in North America:

NPA.CON.NNNN 10 digits, right ?

NPA numbering plan agreement (ASA area code)

CON Central Office...

Another use.

Generating Universal Product Code numbers.

UPC-12 is PPPPPP-NNNNN-C (hyphens added for clarity)

P: 6 digit company prefix assigned by EAN Council

N: 5 digit sequential number

C: check digit, based on modulo-10 calculation.

The...

Running total scenario will very quickly solve that, as well.

It is just that until I have added enough purchase qties equal to the inventory quantity, I do not know when...

Rats !

Another application where I was dead sure the only way to do it was a double set of cursors: calculating the FIFO value of an inventory.

Outer loop: items in...

Hilarious !

Especially at 08:35 in the morning.

Keep 'em comin' too !

Thanks for the help.

Still, the thought process of whoever came up with this one remain baffling. Same as for the guy who figured out that nitroglycerin, an unstable explosive, could...

OK,

Back from the dentist ...

Got it to work.

I am not only mystified by the blinding speed, but more so by how it is achieved. In short, despite the explanation given...

That was fast !

I am going to that link and check out how I can take advanage of it.

Thanks

Jeff, when you get that place straightened out, write it all down and publish it as "Tales from the deep Kimchie"; sounds like it would be best seller!

YES !!!...

Jackall,

If "your" developers ignore your advice, you can bet there will always be one if not two who will decide that "selectthisandthat" is not legible enough and improve the casing....

"This way I can just tell the developer to run stored procedure 'dbo.selectthisandthat' and not have to worry about them calling 'dbo.SelectThisAndThat' and getting potential cache misses."

Would it be so...

"For the latter, lookup the old IBM card sorter... such an algorithym beats even the shell sort."

Can you provide a URL reference if there is one you find the best...

"'dbo.selectthisandthat"

For my taste, I find this harder to read (mid-50 eyesight and all), it requires more attention to figure out the meaning of the name. I feel something is lost...

Naming stored procedures:

[font="Courier New"]

stp_ prefix, arbitary, to avoid using "sp".

the name of the application module...

Try...Catch instead of @li_RetCode for error handling...

I forgot this is part of the SS2K5 forum. Mentioning the new way of doing things is a valid point as I thought I...