If you don't explicityly need unicode or double-byte characters then stick with CHAR, VARCHAR, TEXT etc rather than NCHAR, NVARCHAR, NTEXT.

I don't use CHAR very often because it is a...

I saw an article that argued that certain languages attract good programmers. If that is the case then C++ and Java will naturally be skilled.

Try recruiting a good VB...

I think you are getting a bit mixed up with your CONVERT statements

select convert(varchar(20),planarrvtime,108) as plantime,

convert(varchar(20),arrtime,108) as arrvtime,

DATEDIFF(hour, planarrvtime, arrtime) as diff,

case DATEDIFF(hour, planarrvtime, arrtime) when 0 then 'Present'

else CAST(DATEDIFF(hour,...

SELECT LEFT(YourColumn,5) AS Code, Count(*) AS Records

FROM dbo.YourTable

GROUP BY LEFT(YourColumn,5)

I forgot to add, I built an Excel export routine that spat out an HTML table but the page header had a ContentType="application/vnd.ms-excel"

This means that although the file is really...

I could be wrong here but I think the export to Excel uses the old JET libraries and that is the reason the TEXT data gets restricted to 255 characters.

If you want a global temporary table then use CREATE TABLE ## rather than CREATE TABLE #.

Be careful though. When the creating connection logs out the table will vanish...

As posted earlier immigration is a big issue in the UK right now, especially with the general election tomorrow.

We have a problem called the BNP (British National Party). Imagine...

I loved the books but hated the movie.

Gags I liked

* The gun designed by a woman!

* The bottom falling out of the airlock

* Arthur Dent's "I'm British, I know how...

Adam, I'm not sure what you are getting at.

It is possible to be valued as an individual but be irrelevant to the organisation.

Within EM right-click on your database and select properties.

Under the general tab look at the Collation name (at the bottom), the chances are it is different in one database to...

I liked the gag about a gun designed by a woman and the airlock where the bottom falls out of it, but yes, they rushed through the opening (and best)...

I thought the whole point of a cluster is that the nodes were identical and therefore if a node went down the other nodes would take over?

We originally recommended that...

If companies are in a non-competitive but symbiotic relationship it could work.

As pointed out liability for faulty code may be an issue although I suspect the sticking point would come...

Poor dumb b***ds