G'day. Why you did not even consider an option to move from SQL Azure to WinServer/SQL VM in cloud as part of Microsoft Azure IaaS recent offer (announced in beginning...

Please note that matrix is symmetrical - therefore it could be calculated at least twice quicker. 😛

Thank you for article.

IMHO if I need to import data to Excel from SQL I would use either

SSIS package

or DYI Stored Procedure ...

Todd, thank you for article.

Did you try UDF that return a table?

Cheers

Ironically a new version of SQL Server would have an Oracle-style SEQUENCE identity capability, so hopefully there will not be need to "re-invent the wheel"

I agree, why Dynamic SQL AND Output?

What about SCOPE_IDENTITY function?

Cheers

We have a CTE - I wish that we would have a calculated field expressions (defined once, used multiple times).

Regards from DownUnder

I would like to add my $0.02 - XML data type parameter looks even better considering the fact that it could be STRONGLY TYPED (bound to a particular XML schema)....

Just a small suggestion - please consider EXTENDED properties for DB objects (including Stored Procedures), by using them in a key-value fashion you could avoid a lot of text processing....

Well done!

I would recommend to use built-in information views instead of system table sys.sysobjects

Cheers

Thanks for article, Yakov.

Would not usually bother with sample data in a sandbox environment - usually would copy entire tables and create views with 1000 rows,

this would prevent NASTY...

GSquared (3/15/2010)

---

Steve Jones - Editor (3/15/2010)

---

GSquared, I like the idea of the parameter. That would be very handy to know during the creation of modification of some DDL statement. That...

Duplicate

In a real world, Carolyne you always challenged with a task to clean somebody else mess, and I was VERY VERY lucky

when I got couple of weeks to understand what...

You could use DDL Trigger - every time when SP/UDF had been modified, it will retrieves list of input/output parameters, build an XML document and store it with designated ...