This information is not recorded by default. The only way would be if you have backups, and you can work it out by trawling through them.

Hey, no worries Ken...

Is this a joke?

An alternative definition for the 'SillyDate2SQLDate' function is:

create function dbo.SillyDate2SQLDate(@SillyDate varchar(15)) returns datetime

as begin return '1 '...

Yes, I believe De Morgan felt the same.

Well, if we're simplifying...

ALTER TABLE Claims

ADD CONSTRAINT CKTbl_Claims_DateClosed

CHECK (NOT (ClaimStatusID = 2 AND DateClosed IS NULL))

(okay, it's probably not much simpler - if at...

That was just an example. Use your imagination!

ALTER TABLE Claims

ADD CONSTRAINT CKTbl_Claims_DateClosed

CHECK (ClaimStatusID <> 2 OR (ClaimStatusID = 2 AND DateClosed IS NOT NULL))

It's not clear to me, but maybe you want to create a dynamic order by?...

http://www.sqlteam.com/item.asp?ItemID=2209

If not, post some sample data and the result(s) you would like for it.

Just use the COLLATE keyword. Here's a simulated example...

--data

declare @t table (v varchar(10) collate Latin1_General_BIN)

insert @t

          select 'ABC'

--calculation

select * from @t where...

Clearly you need to sort out your underlying data, but something like this should do in the meantime...

declare @t table (id int identity(1, 1), v varchar(20))

insert @t

         ...

You can just use some ANDs and ORs. E.g.

ALTER TABLE Claims

ADD CONSTRAINT CKTbl_Claims_DateClosed

CHECK (ClaimStatusID IN (0, 1) OR (ClaimStatusID = 2 AND DateClosed IS NOT NULL))

July 10, 2006 at 11:18 am