Click here to Skip to main content
11,709,581 members (48,548 online)
Rate this: bad
good
Please Sign up or sign in to vote.
I want to Create a procedure for insert as in table have 7 weekdays such that suppose i have following fields mentioned below for the table as

Id  employeename   field1    field2   field3   field4

all fields are varchar data type

now condition should be that when i insert the record field1 value not equal to field2 so as for field1 not equal to field3 and field1 not equal to field4 and field2 not equal to field3 and field2 not equal to field4 and same for the field3 not equal to the field4
Posted 5-Feb-13 17:41pm
lalitkr1.7K
Edited 5-Feb-13 17:48pm
v2
Comments
naveensenagasetti at 5-Feb-13 23:50pm
   
Are You passing the values via page wise only....?
If you pass the values in page wise then check the condition using "if".
Ankur\m/ at 6-Feb-13 0:44am
   
There are many ways you can do that. 1) Check the condition in the stored proc/query you are using to insert the records to. Use RaiseError to throw error if a criteria is not met.
2) Another option is to use Instead Of trigger.
lalitkr at 6-Feb-13 1:59am
   
Pls provide me statement for the same if done by sql or asp.net
Ankur\m/ at 6-Feb-13 2:04am
   
Show me what you have tried.

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Are You Passed the values via Page...?

If you pass the values via page then check the condition using "if".

if(field1!=field2 && field1!= field3 && field1 != field4 && field2 != field3 && field2 != field4 && field3!= field4)
{
// insert query
}

i'm not sure this is your expecting but as per my understanding i given this solution .
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 524
1 OriginalGriff 250
2 Peter Leow 229
3 Maciej Los 185
4 Mika Wendelius 160
0 OriginalGriff 9,428
1 Sergey Alexandrovich Kryukov 9,037
2 CPallini 5,189
3 Maciej Los 4,991
4 Mika Wendelius 3,856


Advertise | Privacy | Mobile
Web01 | 2.8.150819.1 | Last Updated 6 Feb 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100