exemption - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

exemption

Author

Topic

iffi
Starting Member

3 Posts

Posted - 2005-12-06 : 10:21:01

i want to get exemption on the basis of old selected subjects.

Table Structure:
CREATE TABLE [dbo].[exemptions] (
[stagesno] [int] IDENTITY (1, 1) NOT NULL ,
[stage] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[subjectold] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[subj_code] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[stage_new] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[subjectnew] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[resorder] [int] NULL ,
[newsub] [bit] NULL
) ON [PRIMARY]

TAble Data :

1 F-I Principles of Accounting S-101 Stage-1 Fundamental of Financial Accounting & Taxation 1 0

2 F-I Computer System S-204 Stage-2 Introduction to Information Technology 2 0

3 F-I Business English S-104 Stage-1 Business English 3 0

4 F-I Economics & Business Environment S-102 Stage-1 Business Economics 4 0

5 F-II Financial Accounting S-301 Stage-3 Financial Accounting 5 0

6 F-II Management Information Systems-II S-204 Stage-2 Introduction to Information Technology 6 0

7 F-II Industrial & Commercial Laws S-103 Stage-1 Business Laws 7 0

8 P-I Cost Accounting S-201 Stage-2 Fundamentals of Cost and Management Accounting 8 0

9 P-I Business Communication & Report Writing S-304 Stage-3 Presentation & Communication Skills 9 0

10 P-I Quantitative Methods S-203 Stage-2 Business Mathematics & Statistics 10 0

11 P-I Management Science Applications - - - 0 0

12 P-II Advance Financial Accounting S-401 Stage-4 Advanced Financial Accounting & Analysis 11 0

old subject like Principles of Accounting filed is display to user user select some subject on the basis of selected subjects the exemption is given. just to show new subject on the basis of selected rec plus do not show duplicate subject.

help is required thanks

druer
Constraint Violating Yak Guru

314 Posts

Posted - 2005-12-06 : 14:55:55

I have no idea what you are looking for. Can you please give an example of what you want to send to the system and what you want the system to yield back. This is a SQL Server forum, so please exclude what the user will do as this isn't a programming forum.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-12-07 : 02:03:46

Post the result you want

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources