Another way of formatting variable-length strings:

(there must be at least a half-dozen more...)

[font="Courier New"]

DECLARE @ls_10_Blanks = ' '

DECLARE @ls_20_Blanks =...

Generally, I like to return a specific error message back to the application to identify where the failure occured.

I have two choices:

# 1

DECLARE @li_RetCode int

SET @li_RetCode = -666

BEGIN TRAN

UPDATE SomeTable...

Regarding decimal and float types:

Decimal works well except there is no support for this in Delphi v. 6.0. (Something to do with support for ADO.) You may encounter similar problems...

And I also liked the bit on the CSV generator.

Jusst the slider:

This is what you get when you post NO code. An illustration of the point made by Jeff.

Regards

"...Create Some Table Code

Yeah, this first part is all manual... but, it's worth it and it doesn't take any real time, at all. It does, however, do several very important...

If you are doing it from the console manager -> "all tasks" -> "backlup database" the "Overwrite" section has the following exclusive choices:

- Append to...

Your new version is now running just fine.

I ** LOVE ** it!

Thanks a million.

LINE

SELECT @CMD = 'SELECT * INTO ##TEMP_TABLE FROM

FAILS when column type is money - --@FLD)

"IMPLICIT CONVERSION FROM DATA TYPE MONEY TO VARCHAR IS NOT ALLOWED....

Nothing worth "bragging" about. All I had to do was run that query in the Query Analyzer.

And got the answer instantanewously, no delay at all.

So, such trick questions buying "braging"...

One of the most abused examples of recursion: Factorials.

The is the first example given to explain recursion because

it is easy to describe the problem to be solved.

Most unfortunately, this...