I understand the confidential nature of the data. I was hoping you could come up with some generic data and structures that mimic what you are trying to do...

Not really much help for me. As i look at what you are asking, I actually see two missing pieces to helping you. The first, is a general...

The problem I am having in trying to answer your question is not knowing the data you will be loading. Having an idea of the source data would greatly...

Yes, you may want to look at upgrading from SQL Server 2000 to SQL Server 2005 (maybe even SQL Server 2008 as it comes out this year).

Standard suport for SQL...

I pulled this from another thread: http://www.sqlservercentral.com/Forums/Topic342856-19-1.aspx#bm343852

All you need to do is basically store your command in a global variable. You can create a global variable by right-clicking the...

I used SQL Mail at my last employer. We had to install Outlook on the server and setup a mail profile. For the most part, it was reliable....

Congrats! And as the others have said before, there is a whole community here willing to help you out if you find yourself stuff.

You will learn a lot being...

Could you post the DDL for the tables and some sample data? Read this article for more info on how to setup a script with test data: http://www.sqlservercentral.com/articles/Best+Practices/61537/

Thanks

😎

Take some time to read this article: http://www.sqlservercentral.com/articles/Best+Practices/61537/

Following the guidelines in the article will allow people to help you easier.

😎

Your welcome.

That's just one way. I'm sure someone else has another an will share it. There are usually more than one way to skin a cat in SQL.

😎

Try this:

cast(substring(TheDateColumn,5,4) + substring(TheDateColumn,1,2) + substring(TheDateColumn,3,2) as datetime)

😎

Here is a list of books I have (I am amazed at all the books I have, so it took a little longer than I expected to find all my...

Hey, I had the blessing of my immediate supervisor. He agreed that I was entitled to a life outside of work.

As it was I had my SQL Servers setup...

I guess I'd rather get notified a lot earlier about a deadlock, and let SQL Server kill one of the processes so that other work isn't hung up, and then...

Let me get this straight, you'd rather see deadlocked processes sittting around indefinately until you come in and kill one or both of them? The problem with this is...