Actually, just select MONTH() from each date and subtract it from 13.

... but this will...

SELECT o.CompanyID,o.TransactionID,o.RestrictedID,

CASE

WHEN d.HasRestriction = 0 THEN 'Grey'

...

The problem is that you are grouping by the UID which appears to be unique... it won't give you the sum of 150 that way... it will always list the...

Nope...

There are a lot of things in SQL Server that have no replacement in ANSI SQL. And, I've never heard of such a converter... basically, portability is a myth.

So...

jalphor (5/13/2008)

---

Hi,

I am working on a project in which someone will drop up to 5 (.txt) files into a directory on a shared drive. I have to go...

I agree with Mahesh... this type of duplicate data may be a real problem.

However, if that's what you need, just have the final table do a "self update" using 2...

jim.powers (5/14/2008)

---

Another thought would be doing a cost-benefit analysis of taking the "risk" to be encrypted or not. Of course, the risk if you are not encrypted is that the...

Chris (5/15/2008)

---

Hi All,

Great forum!!!

Here's my problem. I'm trying to build a course schedule of classes for my job and I want to stop the course descriptions (varchar(max)) from repeating...

Edward (5/16/2008)

---

I am just doing a standard duration trace. I am unable to reboot as it is a live system. I will try flushing the procedure cache its mainly...

If you want that kind of help, then you have to "follow the rules" for posting data. Please click on the URL in my signature line and provide the...

Which record ID are you going to keep when dupes are present?

Heh... what yellow dots?

Ok... I'm going to assume that the Scholar_ID column is the Primary Key and that the start and end dates you want updated are the CheckIn_Date and Vacate_Date columns, respectively....

I use the same method Michael, posted, as well. Works in 2k and 2k5 equally as well and avoids dipping system tables.