I think you are getting confused with the byte storage rather than the physical character storage.

NVARCHAR(10) and VARCHAR(10) can both take 10 characters but NVARCHAR will store it in 20...

Massive locking problems.

Every record creation seems to result in an insert and multiple updates while locking everything up.

Its OK when its just publishing but when visitors are surfing the site...

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...