ssn

I would be weary about using the social security number, especially if you have an employee code or number. ssn should in my humble view used only for matters dealing...

Be careful about using DOS commands.

This defeats the concept of access security.

There are cases where I had to retrieve a record without knowing the uniqueidentifier that was generated by the default NEWID() setting.

So I added an extra column Temp_OwnerID varchar(38) in...

Matt,

If I read you correctly, I should compute a weighted combination of the various discount rates beforehand and just apply a wholesale update to each sale.

There are some discounts that...

Sergiy,

Thank you for your post. This kind of exchange of ideas is in good part what makes this forum great.

I really enjoy being offered constructive criticism on my posts, this...

In general, I would say DO NOT use a cursor WHEN a set operation can do the job.

The controversy about cursors stems, in part, from the bad habits some programmers...

Haaa... I like that new SQL 2008 declare and set function.

One more thing to answer your question. Let's say you need both the number of rows affected and the error...

Go easy with varchar(8000).

Especially when you are selecting other columns in addition to the varchar.

SQL Server 2000 refuses to retrieve a row when its size is greater than 8,000 (the...

I always ident by 4 spaces the code between a ...BEGIN and the END statement.

For instance:

[font="Courier New"]IF 'COSMO' = 'KRAMER' BEGIN

....PRINT 'This will never show up'

END

ELSE B$EGIN

....PRINT 'No other outcome...

And about a code generator to list the columns, to belabour the point,

check

http://www.sqlservercentral.com/scripts/T-SQL/61812/

Don't forget the Title

By Absinthe, 2008/02/18

Mr. Snidow,

Thanks for another idea. I guess like most people I only use a fraction of all features of any software. Never really thunk of that one. Typically, I work...

Mr. Moden,

I just set the options of the query analyzer as you suggested. Thanks a million for both:

1. a very useful suggestion

2. not laughing at my dumb error.

Regards

About Crystal Reports.

I do not mind using CR's File -> Options ONCE formatting money-type fields to NOT display the currency symbol and specify that the negative values are display format...

The UNION SELECT column_titles is the first thing I should have thought of to solve my debugging problem in Query Analyzer.

Either you set the query mode to gridm and it...

Mr. Moden,

Thank you for expanding on the inaccuracies of the float type. Posting an actual result set with the decimals was a very good idea. I got me doing more...