Happy to hear that .

Checking for missing foreign keys??

I think you'll have to code something in word vba that'll read the text and insert the data in the db. It's gonna be much simpler than trying to...

The problem is not the in clause, it's the result it produces.

What's the data source of the report?

Do you want the period of the next date, or just the next period?

PS that's why you should also supply the expected result of the query when asking a question...

What do you want the trigger to put in the next period column (date, id)??

NP... that concept is hard to grasp.

So you basically have fields like email1, email2, email3 and you're trying to normalize the data?

Why would you want to use a denormalized design like this?

Why not keep the whole thing on the server's hd?

Null > 0 = UNKNOWN (not true), but it doesn't = false.

Ya that actually makes sens somehow .

if he's using my code, then yes.

That's what I said earlier, we can't provide the right anwser as long as we don't know the circumstances of use of the code.

Yes :

Create table A

(

DateS datetime,

Name varchar(10),

number int

)

Insert into dbo.A (DateS, name, number) values (GetDate(), 'a', 1)

Insert into dbo.A (DateS, name, number) values (GetDate() + 1, 'b', 3)

Insert into dbo.A...

He'll have to try... don't have time for this here.

You'd have to run the profiler.

The fact is that something somewhere in the application or server changed (or was flawed from design and just now is breaking). You have...