Another Churchill one:

"It is a good thing for an uneducated man to read books of quotations."

>>Well, except for that really excitable bloke whose name escapes me.<<

Chris Kamara possibly?  He's fantastic... he could get excited about a short pass... "Oh wow!  He just kicked the ball...

I like the looks of the RAZR very much but others' comments above would put me off!  That and the fact Motorolla make it!

I'm a PDA phone fan myself, and...

Agree with David and bond007.  There is SQL Server content in all other parts of the newsletter, the articles being the first item and probably the most content.

I see the...

Try this initially (quick and dirty solution). It will work for the data you have (noted typo on chidambaram/chidamabram on your INSERTs), however not if you had another level...

SELECT (((8 - @@DATEFIRST) % 7) + 1)

It's a mouthful but it will give you the weekday Monday falls on based on whatever the @@DATEFIRST setting is.

Just plug that in...

You'd need separate queries, e.g.

SELECT Color, COUNT(*)

FROM tbl_socks

GROUP BY Color

SELECT Type, COUNT(*)

FROM tbl_socks

GROUP BY Type

The percentages are probably best applied by the ASP script.

Just something to add actually: a possible pitfall (when using Method 1 at least).  I have a table with a key that is a CHAR(18) and its data are something like this:

200402280000000884

Could...

I've been using "Data > Text to Columns" for years...

Such a simple little thing, but it will save some time.

Mark Hickin: I like...

Once, whilst performing some fairly straightforward permissions changes on a data warehouse server (SQL7) that also ran IIS (and the permission changes were to do with IIS), when I okayed...

I'm off to the pub shortly.  I'll buy you both a virtual pint.

Best we don't talk...

Hey - sushila - I'm posting on another (UK, completely unrelated) forum at the moment and the same thing goes on there.  It's human nature!

I think I've still missed the point of that post... Chuck: I don't disagree with you.

As you (David) no doubt know... try starting a conversation about religion in Northern Ireland...

A company I worked for that had a few...

Check out this site:

http://www.wsu.edu/~brians/errors/errors.html

One that bothers me a lot is e.g. and i.e..  As others have said, mis-use of apostrophes always bothers me, as does there/their/they're.

Oh, and affect and...