I have now implemented a configuration scheme like this, and thought that I would share my learnings.

I had to add "Instead Of" triggers to my view to manage the inserts,...

I have now implemented a configuration scheme like this, and thought that I would share my learnings.

I had to add "Instead Of" triggers to my view to manage the inserts,...

Hi Scott

A nice approach - although I do this in my application server when querying with LINQ rather than on the database. Of course sometimes that is not practical (Like...

Hi Scott

I just came across this article, and wanted to congratulate you on a very interesting and well thought out approach.

regards,

Joon

Hello

I noticed that you have the column data type as "Text"

This is a special datatype that is used to store huge amounts of text (in excess of thousands of...

This is a very interesting topic of discussion, especially around how server sizing has changed to development practice 😉

Of course the point is very true - what you are running...

I took the "OP requires a PRINT" as a challenge... 😀

How about this?

Set NOCOUNT ON

Declare @result varchar(8000)

set @result = ''

Declare @Numbers Table (val int)

Insert into @Numbers

Select Ones.val + Tens.val

from (Select...

Hello

Here is one that uses a cartesian product:

Select Ones.val + Tens.val

from (Select 0 as val

union Select 1

...

We could not get SSIS configuration files to work when the package is stored in MSDB.

Admittedly this might be due to a lack of knowledge, but I have tried once...