https://github.com/ewahner/SQL

That is why I posted the project to github: https://github.com/ewahner/SQL

I have pushed my project to git. Please try the link below.

https://github.com/ewahner/SQL

@jcrawf02

I think you confused my point with using a PIVOT vs dynamic PIVOT. When I said you have no choice, I was referring to doing a dynamic...

vopipari (12/6/2012)

---

I've done this loads of time using TSQL sps and dynamic sql within, much in the same way as the CLR routine. Is there an advantage to using CLR...

@rmcomics

I don't see why not as long as your list is either based upon static information or populated from the same connection. Though I imagine if the...

I would agree when you are using known and predictable values like a set of dates or even dates that haven't occurred, creating a PIVOT in SQL is quite simple....

FYI SSC-Enthusiast is just a Forum Tag...not his/her handle.

Not only does this methodology almost always lead to poor performance in whatever query you are writing be it an Index Scan or Table Scan, this methodology breaks some of...

There are still other ways that can both secure the environment as well as allow for existing applications to run as originally designed.

The real problem here is that...

I don't think that you need to track this kind of behavior. There are many ways to prevent developers from having access to production. As was stated earlier...

As I start to remember more and more about this "General Network Error", I now remember that this is just the last error in the error chain.  We too went...

I cannot remember exactly all of the details, but we did used to get this error quite frequently, though it was not in a DTS, but just in some applications...

Well the best way would be to first create some stored procedures like:

Add a customer

create procedure dbo.spAddCustomer

   @fName varchar(30),

   @lName varchar(30),

   @address varchar(60),

   @city varchar(60),

   @state varchar(2),

   @zip varchar(14),

   @path varchar(255)

as

begin

  ...