You're welcome. It's an interesting scenario.

As Lynn said, the query could...

Here is a link that covers several datetime conversions.

http://www.sqlusa.com/bestpractices2005/sqlserverstringtodate/

I wouldn't do it.

As an alternative, maybe you could do a Full-text index on that column.

It will be an expensive Index (Generally speaking) if you do decide to create...

You will want to check for CPU utilization, memory utilization, disk IO, disk space for starters.

Depending on usage will get you number of servers you can consolidate.

Database size, database use, database load, server hardware (cpu, disk space, and RAM) all play into the decision. Also, playing into the decision, is to what kind of Servers...

Chris Quinn-821458 (1/15/2010)

---

Chris Quinn-821458 (1/14/2010)

---

Chris Quinn-821458 (1/13/2010)

---

Chris Quinn-821458 (1/12/2010)

---

Chris Quinn-821458 (1/11/2010)

---

Chris Quinn-821458 (1/8/2010)

---

Chris Quinn-821458 (1/7/2010)

---

Chris Quinn-821458 (1/6/2010)

---

Chris Quinn-821458 (1/5/2010)

---

Chris Quinn-821458 (1/4/2010)

---

Chris Quinn-821458 (12/31/2009)

---

Chris Quinn-821458 (12/30/2009)

---

Chris Quinn-821458 (12/29/2009)

---

Countdown - 13 work...

If you open a view in SSMS, no you cannot update from there. You would need to use insert and update statements.

What is that third party tool that allows...

The lockout policy is controlled through the AD policy. If AD is not present, then it will use the Local machine policy. Try editing that policy - however...

Bruce-12445 (1/14/2010)

---

I'm using SQLServer 2005 and would like to be able to edit data in a view with 2 tables, is this possible? I've read the restrictions for doing this...

Thanks Paul.

Gail - can't wait to see that Blog post.

This is awesome. This could keep me busy for quite some time. Amazing that you were able to do it so quickly. Nice article.

You're welcome.

When doing your actual conversions, make sure you replace that static date in the ' '

You're welcome.

Here is one alternative, to the best of my understanding (without data structures).

select t.refnbr

,sum(case

when t.doctype in ('IN','DM','SC','NS')

then t.origdocamt * 1 -- these doctypes are positives

when t.doctype in ('SB','CM')...

Please provide table scripts. There are columns in your script (perpost,custid) no represented by your data or columns. Also, provide sample data that would enable this query to...