Click here to Skip to main content
11,920,211 members (47,486 online)
Rate this:
Please Sign up or sign in to vote.
See more: SQL SQL-Server database , +
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 18:41pm
Edited 5-Feb-13 18:48pm
naveensenagasetti 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/ 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 6-Feb-13 1:59am
Pls provide me statement for the same if done by sql or
Ankur\m/ 6-Feb-13 2:04am
Show me what you have tried.

1 solution

Rate this: bad
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 .

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

  Print Answers RSS
0 OriginalGriff 455
1 phil.o 170
2 CPallini 150
4 F-ES Sitecore 130
0 OriginalGriff 6,778
1 KrunalRohit 4,495
2 Sergey Alexandrovich Kryukov 3,153
3 George Jonsson 2,810
4 Suvendu Shekhar Giri 2,181

Advertise | Privacy | Mobile
Web03 | 2.8.151120.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