On 32-bit processors, working with 32-bit integers is typically *faster* than working with bytes.

To the original poster: "today we don't need to store any characters that can't be represented within...

>> In a stored procedure, I need to be able to run various sets of code based on whether variable1 is passed or variable2 is passed or variable3 is passed...

I suspect Word is automatically formatting your quotation marks as 'smart quotes' (ie the curly ones). This is from the Word 2002 help file, I'm sure a similar process applies...

This might be a big enough application of SQL Server that Microsoft would be interested in supplying you with consultancy, in exchange for being able to use you for marketing...

You're right that recruitment is largely done via agencies, however they generally aren'y looking for CVs sent in 'on spec', but rather for CVs sent in for specific vacancies.

The way...

That's devastatingly more compact than what I was about to post One little thing, I think it makes sense for the main SELECT...

Also, haven't you got your

SET IDENTITY_INSERT Catalog OFF

and

SET IDENTITY_INSERT Catalog ON

the wrong way round?

You want to set it ON before doing the...

Sometimes it is best to do what the boss says even if we think it's wrong

But seriously, from the way yuo describe it,...

To be honest, given how simple a task this is for DTS (source: sql server, destination: sql server, transformation required: none), the wizards launched from Enterprise Manager should provide all...

One tricky issue is going to be this: employee 1 changed from T to R in the middle of a pay period, so I suppose you are going to want...

Well, Firefox is a user application, User applications belong on user machines, not servers. Simple as that

Although I am intrigued that this consultant...

Steve - EM 'cheats'. A lot of the time you will see in these forums "but EM changes <X> why can't I!?", and the reason is this: EM is actually creating a new...

While there is no questioning your function's speed or elegance, for me your first 'Note' considerably reduces the usefulness. I refer to:

 Notes:
 1.  Holidays are NOT considered.

Here in England we have...

This answer will mean a significant amount of work, but will produce the best results in the long term:

Clean your data before you let it into your database

At the risk of being accused of being facetious, here are the differences between C# and VB.NET:

- C# uses { and } to delimit blocks, whereas VB.NET generally uses new...