My apologies for taking so long to get back to you.

I have finally understood the code that you posted and it is far better than anything that I had come...

Try:

SELECT dbo.fnContactFullName(1)

and that will work.

You're confusing two different types of function. There are Scalar Functions, which you would use within the SELECT part of a query and Table...

Gazareth (7/13/2012)

Is that right? My understanding was that the view is only 'solidified' once an index is created on it, and that

WITH SCHEMABINDING is merely a prerequisite for an index...

This is a bit of a simplification - but basically a view that does not have SCHEMABINDING is just stored as a definition. When you reference the view the definition...

Indeed it should - according to BOL - http://msdn.microsoft.com/en-us/library/cc645993(v=sql.105).aspx

There's a whole series of date manipulation examples on Robyn Page's site: http://www.simple-talk.com/sql/learn-sql-server/robyn-pages-sql-server-datetime-workbench/

A little out of date now, but still useful.

Thanks for taking the time with this problem of mine - I can just about get my head around it! I'll have a further look at it over the weekend.

I recently purchased the desktop version of SQL Pretty Printer, which I quite like (http://www.dpriver.com/pp/sqlformat.htm).

The main reason for buying that one was because it can work in batch mode...

That explanation requires expanding slightly, because there is more than one type of temporary table.

Local temporary tables (prefixes with '#') go out of scope when the exec command completes....

That looks remarkably like a homework question.

We're quite willing to spend our time guiding through this, but won't write it for you. Show us what you have tried so far...

Dropping the indexes and constraints will make the loading of the data faster. However, don't just wait for the implementation of the constraints afterwards to highlight any errors - you...

http://msdn.microsoft.com/en-us/library/aa140038(v=office.10).aspx

I would have thought that comes under 'Non-Commercial Research and Private Study', so should be of no interest to them.

There is an Intellectual Property Office website that may be of...

No, because I'm using dynamic SQL it goes out of scope:

declare @sql varchar(max);

set @sql = 'SELECT ''1'' AS [A],''2'' AS ...

Do you know it is the memory being used that is causing the degradation, or is it possibly the files that are being scanned?

http://www.sqlservercentral.com/articles/sqlserversecuritydealingwithantivirusprograms/1351/