They'll be as careful or otherwise as profit dictates.

I'm still in shock from the fact that I've only just found out you can do this!

Nice one - you've made my day

The fact that you say that shows you have no idea about the NHS.  The words 'fixed' and 'quickly' are not often put together in a sentence concerning the NHS!

I work for the NHS in England.  There are a few smart people at my hospital - obviously I am one of them! - but the 'company' is not smart at all. ...

You can work out what the current quarter is by using the current date.  You can then use that information to determine whether the data is read-only or not.

Nice one, mate

I strongly suggest you look into making a function that strips out the account number, using similar T-SQL code to the...

I would create a SQL function that strips the account number out of the Report Folder string.  This function should return just the account number.  So, if you pass in...

The following shows code that uses a Reporting Services report parameter in a SQL function.

Select dbo.fn_MyFunction(@TestValue) As MyValue

If you wanted to use a stored procedure, then it would be similar:

Exec...

Well, it now gets more or less bizarre, depending on your view, because this morning SQL Prompt has remembered all my settings from yesterday.

I'll keep monitoring it each day and...

Thanks for the excellent response, Bart.

I've checked the UIOptions.xml and EngineOptions.xml files and they do update when I make changes to SQL Prompt options.  I'm going to check with the...

I think certain parts of IT are very boring.  Development can be a mind-numbing hole of depression, where you are forced to implement bad specifications without any hint of creativity. ...

Colin talks sense; heed his words!

As I said previously, I use Reporting Services.  However, in order to get an acceptable level of performance, we've had to build a reporting version...

We use Reporting Services at the hospital where I work.  Security is handled via Windows Groups, with one group relevant to patient-identifiable information, and one not.  It works well for...

Select src.*

From dbo.Student src

 Inner Join dbo.StudentCourse sc

  On src.StudentID = sc.StudentID

 Left Join dbo.StudentCourse sc2

  On  src.StudentID = sc2.StudentID

  And sc2.CourseID in (2, 3)

I'm struggling with the bit where Scott Mills is in the Favourite_Show table, but anyway...

Try copying D2.T2 into D1, then doing a...