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

Using SQL, this demonstrates what GSquared was giving you:

create table dbo.MyData (

IntVal int

)

insert into dbo.MyData (IntVal)

select 123

union all

select 4567

union all

select 987654321

select

IntVal,

...

Much cleaner and avoids loops and unnecessary temporary tables.

The best way, create a new column as a datetime column. Run a query to insert data into the new column, converting the data from the existing column into...