SQL Query Help!

[isurutmv]

Mcn Database eke Table ekak thiyenawa me widihata 456,675 kiyanne employee numbers mata danaganna one 656 kiyana employee mona team ekeda kiyala meka karanne kohomada samanya where clause ekak liyannath bane mekata

 

[ArunaTelshan]

column name eka ne ganna one.. Select column_name From tablename whare TEAM1="656" OR TEAM2="656" OR TEAM3="656" OR TEAM4="656" kiyala dammoth enne nadda

 

[Reo_BitPA]

Mcn Database eke Table ekak thiyenawa me widihata 456,675 kiyanne employee numbers mata danaganna one 656 kiyana employee mona team ekeda kiyala meka karanne kohomada samanya where clause ekak liyannath bane mekata

Employee mona team eketa aithida kiyala mona table ekadat thiyenne ? or one employeee can have many teams ? wenewama mapping thiyaganna table ekak thiyanwada

 

[ArunaTelshan]

column name eka me wage ekakin gaththahaki

sys.columns.name AS ColumnName,

nathnam oken pivot table ekak hadagaththanam lesi

 

[biskubiskulahila]

https://stackoverflow.com/questions/28717868/sql-server-select-where-any-column-contains-x

 

[isurutmv]

Employee mona team eketa aithida kiyala mona table ekadat thiyenne ? or one employeee can have many teams ? wenewama mapping thiyaganna table ekak thiyanwada

Employeege team eka wenas wenawa bn dawasin dawasa employeege team eka thiyenne me table eke

 

[rangakw]

sql IF ELSE walin goda danna puluwan nehda?

 

[lankanatha]

select 'Team1' as Team from Table where
Team1= pemp_id
union all
select 'Team2' as Team from Table where
Team2= pemp_id
union all
select 'Team3' as Team from Table where
Team3= pemp_id
union all
select 'Team4' as Team from Table where
Team4= pemp_id

 

[saja]

team1..... team4 ochara da teams gana?

 

[isurutmv]

select 'Team1' as Team from Table where
Team1= pemp_id
union all
select 'Team2' as Team from Table where
Team2= pemp_id
union all
select 'Team3' as Team from Table where
Team3= pemp_id
union all
select 'Team4' as Team from Table where
Team4= pemp_id

meken team eka balaganna bane bn

 

[lankanatha]

meken team eka balaganna bane bn

ai bari, gahala baluwada ? pemp_id thenata umbata awshya id eka daala run karala balapan

 

[isurutmv]

team1..... team4 ochara da teams gana?

ow bn

 

[DimuthTharindu]

SELECT tbl.Operation, tbl.Employee, tbl.Teams
FROM TableName 
UNPIVOT
(
  Employee
  FOR Teams in (Team1, Team2, Team3, Team4, ...)
) tbl
WHERE tbl.Employee = '656';

OR

SELECT tbl.Teams
FROM TableName 
UNPIVOT
(
  Employee
  FOR Teams in (Team1, Team2, Team3, Team4, ...)
) tbl
WHERE tbl.Employee = '656';

Team gana sure nathnam dynamic unpivot tama use karanna wenne.

 

[saja]

select 'Team1' as Team from Table where
Team1= pemp_id
union all
select 'Team2' as Team from Table where
Team2= pemp_id
union all
select 'Team3' as Team from Table where
Team3= pemp_id
union all
select 'Team4' as Team from Table where
Team4= pemp_id

meke pemp_id ta one employee wa pass kala nam hari ne ban

 

[sithija.h]

මම හිතනව ලැබුණ උත්තර වලින් උඹට වැඩේ ගොඩ දාගන්න පුලුවන් කියල,


මම කියන්නෙ වෙනම දෙයක් බං, උඹ මේ ටේබල් එක Implement කරපු විදියෙ ලොකු අවුලක් තියෙනව, Bad Structure එකක්, මේක මෙයිට් වැඩිය සුපිරියට කරන්න පුලුවන් ටේබල් දෙකක් අරගෙන. Bad Structure එකක් Continue කරන එක එච්චර හොඳ දෙයක් නෙමෙයි

 

[shiran987]

Columns godak aran, eka team eka hard karanne nathuwa, team ID ekak daala, (1,2,3,4) wage eka column ekakta data eka feed karala, ekata sql eka call karala, if use kara nam, oita lesi kiyala mata hithenne.



Menna me columns tika thibba nam athi,m


ID -> int auto increment not null

Operation Id -

EMP No -

Team ID -

 

[isurutmv]

මම හිතනව ලැබුණ උත්තර වලින් උඹට වැඩේ ගොඩ දාගන්න පුලුවන් කියල,


මම කියන්නෙ වෙනම දෙයක් බං, උඹ මේ ටේබල් එක Implement කරපු විදියෙ ලොකු අවුලක් තියෙනව, Bad Structure එකක්, මේක මෙයිට් වැඩිය සුපිරියට කරන්න පුලුවන් ටේබල් දෙකක් අරගෙන. Bad Structure එකක් Continue කරන එක එච්චර හොඳ දෙයක් නෙමෙයි

Columns godak aran, eka team eka hard karanne nathuwa, team ID ekak daala, (1,2,3,4) wage eka column ekakta data eka feed karala, ekata sql eka call karala, if use kara nam, oita lesi kiyala mata hithenne.



Menna me columns tika thibba nam athi,m


ID -> int auto increment not null

Operation Id -

EMP No -

Team ID -

Mekata data add karanne excel sheet ekakin bn anika me operations wenas wenawa ada thiyena operation eka heta naha heta wenama ekak thiyenne

 

[sithija.h]

Mekata data add karanne excel sheet ekakin bn anika me operations wenas wenawa ada thiyena operation eka heta naha heta wenama ekak thiyenne

Okata data insert wenna program ekak unba liyalada thiyenne(c# hari monawahari language ekakin)? nathnam excel sheet eka direct import karanawada?

 

[HKavinda]

බම්පි​

 

[isurutmv]

Okata data insert wenna program ekak unba liyalada thiyenne(c# hari monawahari language ekakin)? nathnam excel sheet eka direct import karanawada?

C# walin Sheet eke data tika DatagridView ekata Load karala data tika check karala DatagridView eke data tika database ekata insert karanawa