Is the date sent to you as text?

If so, and it always has the format MM/DD/YYYY you could do something like this:

select right(datefield,4)+left(datefield,2)+substring(datefield,4,2)

I looked at a Hybrid a couple of years ago. They were completely sold out except for the showroom model, but I wondered about when the battery would need...

Do your agent jobs alert operators via email? Verify whether they use Outlook mail or smtp. Make sure you have the accounts set up.

The MSDN link has changed.

http://msdn2.microsoft.com/en-us/library/aa175396(SQL.80).aspx

quote: "What's the hardest glass product to recycle?

Shot glasses"

So that is why I never cut my hand doing Tequila Slammers in college...the glass was too hard to break.

My older self...

Not knowing the exact SOX requirements, wouldn't a powerful magnet work on the DLT tapes?

http://www.harborfreight.com/cpi/ctaf/displayitem.taf?Itemnumber=36904

I have spent days with scissors scratching up old CD-ROM disks in order to send them to the dumpster. It was fun at first.

Personally, I've always wanted to drop...

My personal experience is the job is skipped and will run at its next scheduled time.

Mike - If you click on the author's name at the top of the page, you can see all the articles he has written. It appears that the previous...

Most memorable from the media: That SQL 2005 is "safer" than Oracle.

Most memorable personally: Passing 70-431, finding a great new job in a different state(Arkansas to Idaho) and...

Could you incorporate and identity column in your table and pass that to the client?

I'm excited. I have very much enjoyed learning SQL Server through this site that Andy, Steve and Brian built and I look forward to continuing. I have also...

Were these servers imaged? Perhaps something like Ghost? I had this problem before because the distributed transaction coordinator saw all the boxes as the 'same' one, even though...

The 24 hour system is so much better. I wish the US would use it instead. Of course, we also can't seem to accept metric. And we...

I go to http://groups.google.com so I can search the Microsoft Newsgroups. If you sign up, you can also post questions to the various newsgroups also.