How about this: When things are really screwed up, are you more likely to be the one that screwed it up or the one that fixes it?

This would also return the max value, but only testing can tell which is faster for your situation.

Select top 1 IDValue from MyTable order by IDValue desc

As others have pointed...

select

DT,

WeekOfQuarter=(datediff(dd,dateadd(QQ,datediff(QQ,0,DT),0),DT)/7)+1

from

( -- Test Data

...

Since they don't know the answer to the question (or they wouldn't have asked), the original poster is often the least qualified to judge the best answer when there are...

SQL CALs are not really installed, so there is no technical way to get that info.

You probably need to look back through software purchase orders to find that info.

If that is one of the big name ERP systems, there is a good chance there are no FK relationships defined between the tables. Since they have to support...

Elliott W (7/29/2009)

---

I don't believe you have any options on this, I think you will need your constraint. Also, I think you really only need the FieldName != ''...

Comparing as a string will only work if the varchar date is in the same format in all rows.

The code below should work OK even with invalid dates in the...

You need to have a backup for any database you might want to restore, "critical db" or not.

jcrawf02 (8/19/2009)

---

Gav B (8/18/2009)

---

I found a script on the net and altered it for my needs.

I'd like to know what others think of this and if you can envisage any...

Oracle bought Digital’s Rdb database that runs on the VMS platform to eliminate the competition. They couldn’t compete in the VMS world, because Digital included an Rdb run-time license...

Loner (8/18/2009)

---

I have a software company installing their software and database. The way they partitioned the database, they put the data in D drive and transaction log in H...

shuzi (8/18/2009)

---

sorry for the confusion.

Management Studio provided the overall server info, we don't want anyone be able to access it. Some persons just need to know the database structure,...

This is a little simpler and will work with any date range.

select

*,

Days ...

Try this:

start c:\test.bat