1) I was referring to following query which you suggested to resolve the original problem at the top in the first post, this query does not solve the problem

SELECT Emp_no,...

any help will be great??

this query is incorrect, looks like you mixed up org_code with city

also beside that it gives me emp_no : 43232 in the result which is incorrect since combination of that...

scott,

believe me its not that complicated....start out learning basic ...join small firm with whatever position..developer or DBA....either position will make you more expose what both position do...and while experiencing...you will...

any help will be great...i really need to resolve this task...at earliest

Best I can come up with is

Select A.Emp_no from employee A

left outer join Class B on (B.Emp_no<> A.Emp_no or b.[Org_Code]<>a.[Org_Code] or b.[Org_Num]<>a.[Org_Num])

where B.Emp_no IS not NULL

but it is still giving...

This will help to start: https://sqlschool.modeanalytics.com/toc/

http://sqlserver360.blogspot.com/

sorry its not homework, just trying to solve complicated problem:

this was the query i created but i don't think it is giving me correct output:

Select a.[Emp_no],b.[Emp_no] FROM [dbo].[Employee] as a,...

DBA : A database administrator or DBA plays a critical role in managing the databases of an organization. One of the major role of DBA is to keep data safe...

That convert worked, thanks

but i tried to add another case statement:

SELECT [student#]

,[class_position]

,case when [class_position] > 0 then [Assembly_Rank] else [Assembly_Seq] end as [Line_Class]

,case when [class_position] > 0 then CONVERT(VARCHAR(12), [Class_Rank])...

I tried that and now it gives me this error message:

Msg 245, Level 16, State 1, Line 4

Conversion failed when converting the varchar value 'PR001' to data type int.

Just to clarify little bit more:

1) i want to display all the records

2) but I want create new column says School which has data from either district or area. So...

that doesn't seem to be working

name of the table is "test"

i mention case statement in subject line , but it can be if statement or case or anything which is easier to use