Here's a major problem with PIVOT: You must know the values in the IN clause when you write the query. It's possible to make this dynamic, but it's complex and non-performant....

Or you could set up a report in SQL Server Reporting Services with a subscription. Easy, managable and requires zero lines of code....

Or they can simply call the stored procedure [SSISDB].[catalog].[start_execution] to fire off the SSIS package. http://msdn.microsoft.com/en-us/library/ff878160.aspx...

This will copy over the data and the data types. It will not copy over any constraints, nullability rules, primary keys, foreign keys, or security. It will fail if there is already an object in the destination database with the same name. The log...

Learning is a never ending thing and just one life is not enough to learn all the things you want to learn. The ocean of knowledge is very, very deep. This blog has been created for the same objective. I write on things which I come across in my daily l...

This is why you do NOT run services under the context of a user account. Create an account dedicated to the service and mark it as "password never expires"....

i-catching solutions...

Why wouldn't you use a Table-Valued Parameter (TVP) as a parameter into your stored procedure? You just create a user defined table type, create a variable of that type, insert values into the variable, and pass it into your stored procedure. No strin...

If you ever want a character-by-character analysis of a string (char, nchar, varchar, nvarchar, etc) column in a table, here's something I slapped together. It will list out each character (printable or otherwise) and the ASCII code of the character. ...

The fun part is some systems will embed CHAR(13) + CHAR(10) (Carriage Return + Line Feed), some will do only one or the other. Rather than replacing CHAR(13) + CHAR(10), it's often safer to replace them with a zero-length string separately....