I left an incredibly "secure" job and I have never been happier. I like yourself talked myself out of applying for a new job for almost 14 months before...

I think from my perspective the move from programmer to developer changed as we moved away from mainframes to server based operations. A program just wrote code sure they...

I don't think any estimate anyone could give would be remotely accurrate. It would entirely depend on the complexity of the data. Lets take two hypothetical situations for example.

there are...

I am rather confused using you scripts I basically get what you are looking for unless I am missing something. I ran your steps and got the below result...

are you doing a linked server? if not how are your trying to connect?

This may not be the ideal way but my gut reaction would be to go into permissions for the database and grant the user create table permission on the database....

I have a process in place now to copy a production database to a development database.

I do this in an SSIS that consists of a SQL task that runs the...

It was bothering me so I went and looked around and found where there seems to be an updated Jet driver available that will allow you to use the new...

in Excel 2007 the climit is 16384 columns by 1048576 rows so it will fit technically.

However I believe I had read somewhere that the connection to Excel from SQL 2008...

Again it is a design problem. When you say they have a recordset open and they can change the record, what screen are they on? does the application...

I am not sure I follow what you are trying to accomplish.

what do you want to do with ColA and ColB?

what would the ultimate value of COLC be?

If...

It really depends on how your user interface is designed but this is wholely a program issue. Nothing in SQL would allow you to update the interface with changes...

How does the current record get entered? Why can't the ending balance get populated when the record is built?

Wayne,

Thanks for your help and the information.

So for anyone reading this here is the procedure I settled on which I was able to successfully use on my test server. Some...

Wayne,

That would be fantastic!