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

I usually find the conversation stops when I say that I work with computers 🙂

You could add the view, stored procedures, etc. to a schema and grant the appropriate rights on that schema. As long as they always create/amend objects in that schema (easy...

The OP's project is teaching students how to query a database's metadata, interpret it and use that information to do something potentially useful. As a learning exercise that's fine. Would...