Query help?

[karthikmv]

How to write a query that should not accept same number on same day but should accept the same number on next day

or

constraint that can be given to a column so that it should not accept same number on same day but should accept the same number on next day

[debasisdas]

Hi
karthikmv
Welcome to TSDN.

You have reached the right place for knowledge shairing.

Here you will find a vast resource of related topics and code.

Feel free to post more doubts/questions in the forum.

But before that give a try from your side and if possible try to post what/how you have approached to solve the problem.

It will help Experts in the forum in solving/underestanding your problem in a better way.

Please follow the posting guidelines in every new post/reply.

[debasisdas]

since u had put a question in the article section i am movig it to the proper forum.

[siva538]

How to write a query that should not accept same number on same day but should accept the same number on next day

or

constraint that can be given to a column so that it should not accept same number on same day but should accept the same number on next day

you can use triggers to enforce such kind of business rules. or you can check that business logic in your stored proc code before inserting into the table.

HTH...

[Motoma]

Please give us a little more information so we can better help you.