I'm not entirely sure I understand what your are suggesting, or why.

Does anybody have any experience of the Hummingbird BI suite, and if so, what are your thoughts?

I've found that the better application developers tend not to think in terms of single objects but rather in terms of collections. Obviously a collection can have zero or...

I think in order to provide any meaningful feedback to this post we need to know the definition of "business logic" provided by the Development Team of Knight (original poster)....

I've seen many discussions of this nature before, including here at SQLServerCentral, and they typically tend to suffer from the lack of a definition for "business logic" (although in reality...

Obviously we do have intellectual property protection laws, however, enforcing these is a lot easier said than done.

I find that taking the database offline and then bringing it back online typically works. Or is that not the preferred way of doing it?

Is it possible that your stored procedures were created WITH ENCRYPTION (see BOL)?

Thanks Jeff - it's always good to know what others are doing.

Jeff:

Obviously everything always depends... I've previously used UDFs where I've had some complex query and the result needs to be reused in multiple places, which has not exactly improved...

Can I assume that it is acceptable to put parameterized sql into a stored procedure? Nobody is saying don't do that, right?

What solution would people suggest if the table...

There is a T-SQL function called DATEPART (see BOL) that can return you the year, quarter, month, day, etc.

Alternatively the user-defined function (UDF) below, which provides date & time formatting...

Good idea.

I can see that you've got the problem solved but another suggestion would be the text editor TextPad (http://www.textpad.com/).  It has a very good "Find In...

Jeff:

I had not defined how it would work, I was simply asserting that it is a useful format to be aware of when converting strings to dates.  You may or...