Daryl, as posted earlier there are Sudoko puzzles where there is no automated solution and you have to make a choice at some point. You can make the wrong...

Assuming you don't have SQL2005 and therefore the PIVOT function you could always resort to

DECLARE @display TABLE(ID INT IDENTITY(1,1),Display VARCHAR(50))
DECLARE @lRow TINYINT
SET @lRow = 0

DECLARE @NewRow VARCHAR(50)

INSERT INTO @display (Display)...

My apologies for the missing stored procedure.

When I started building my solution I prototyped it by bouncing values through tables and the procedure was used to remove solved cells from...

Tad William's Otherland series.

Arthur C Clarke was pretty good.

Jules Verne was probably the most prophetic.

SQL2005 is noticeably faster.

SQL Management Studio is a dog.

Security is a whole new ball game.

I suspect a lot of features will only reveal their value as and when people really...

If you want to be shackled to your old achievements then don't bother commenting your code.

As long as you work for the organisation it will always be quicker/cheaper to ask...

Diesel in the UK is around 95p per litre and petrol is around 92p.

I've just filled a 50 litre tank of diesel and expect to do around 600 miles on...

I think it is worth mentioning that both Apex SQLDoc and Innovasys DocumentX use special (and virtually identical) comment tags so that they can suck out the comments and build...

In the UK there have been a number of complaints from consumers who have been disappointed with the fuel consumption of the hybrid cars.

I think it is more a case...

Here's an embarrassing confession.

Knowing that Metadata is data about data I thought that Wayne Rooney's broken metatarsal was the cancellation of his book deal.

It depends on what you are intending to track for a sport.

• Results
• Telemetry
• Transactions at the betting shop

I worked (very briefly) at one of the smaller betting companies and their need to...

I'm not sure about the criminal bit but other than that it is a good description.

The other thing that makes Brit's good hackers is having to deliver miracles using hardware/software...

Any fool can build something complicated and the telecoms industry has some of the smartest fools in existence.

In the UK we have "Vodaphone Simple" which is just a phone and...

Thanks but in the proc I my paramter is an XML type writing to a field of an XML type.

When I am declaring the SqlParameter in .NET what type should...

You have to be very careful with these surveys and look at who is sponsoring them.

For example, directors of UK companies hire an independent wage consultant to set their salaries....