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...

Just another 2 cents, although SQL Server 2005 Express Edition is free, spending the extra $50.00 for SQL Server 2005 Developers Edition is (in my opinion) well worth while. ...

It would help us help you if you provided the DDL for your tables, some sample data, and what your epected output would look like based on the sample data.

Take...

I'm still working on the list. Between taking kids to church last night and a production issue on one of our servers, I got side tracked. I will...