Jeff, you're entire post is predicated on the idea that the problem case can be changed. Mine is predicated on the idea that it cannot. If you are 100% against...

Jeff Moden (7/29/2011)

---

Orlando, can you honestly say that the format of a date stored in a database should actually matter for a user that's apparently set to writing queries against...

Aggravated, not so much, amused is more like it 😀

TFS is the server piece. There used to be special editions of Visual Studio to play into the SDLC Roles TFS offered up. Where I was they were looking at...

This thread may help answer some questions: http://www.sqlservercentral.com/Forums/Topic1140574-291-1.aspx

PS for future reference there is a dedicated SQL Server 2005 Replication Forum: http://www.sqlservercentral.com/Forums/Forum291-1.aspx

Software like Double-Take might be able to help ease the pain of having a slow connection. It replicates data at the host level (below Windows) so it proves to be...

Cool, that must explain the French in the images of dialog boxes in your posts. I wish I was in NY right now...I am going to get a slice for...

What time zone are you in? The lunch whistle just went off here (Denver, CO).

Visual Studio Team System has some built-in tools to offer. The QA team at one stop starting looking into options and chose to use it over other tools...not sure how...

Why would you put yourself through that pain? Do you have access to a calendar-table, or can you create one?

Lowell (7/29/2011)

---

i'd step completely outside of SQL server and write something in a programming language instead.

trying to do everything from within SQL is the old "Everything is a nail"...

My fault on the Execute SQL Task handling multiple resultsets. I thought that I had done that before, but I ended up using UNION ALL. You'll need separate Execute SQL...

Sorry if I missed it, but are we on SSIS 2005 or 2008?

Jeff Moden (7/29/2011)

---

😀 Not...

Jeff Moden (7/29/2011)

---

ericwenger1 (7/28/2011)

---

I have a request to allow the user to search on a converted datetime column(i.e. convert(varchar,column_name,101) mm/dd/yyyy). Is there

any trick to indexing this column. I guess if...