I tend to structure stored procedures like this.

begin try
  -- Do some stuff
  return 0;
end try

begin catch
  -- Do some...

The approaches already suggested are the way to go, but you need to consider the criteria you use when defining the subset (I assume you're intending to use the smaller...

The UPDATE will set the DateOfOccurrence to its existing value (ie. have no effect) because the column is also part of the JOIN criteria.

3 years ago I was mostly a C#, COBOL and VB6 developer with a bit of SQL experience. Then I worked on a data warehouse project for almost 3 years....

You could use Alan's script here or a variant thereof to remove characters you don't want.

So, to combine QOTD from yesterday and today; if you really want to upset your colleagues, you can have.

Declare @ money;
Select @=\


Two dates are being passed in as varchar and cast to datetime. Is it possible that the default language/region setting is different when executing the stored procedure with parameters as...

I think you might find it easiest to write a small application (C#, VB) to pull in the columns of interest based on the headings in each file and write the...

Roy, I would suggest you look at some of the Stairway articles on this site (see link at top left). You can pick out the topics you need and try...

It's even more fun when you consider that some titles are also valid surnames in their own right, eg. Lord, Lady and that Hon is an Asian forename and an abbreviated...

For anyone in Europe doing this as part of a MiFID II requirement, a useful list of titles and multi-part name prefixes is below. Unfortunately, I couldn't find the original...