Sql server select where in list

Sql server where in list | sql server where id in list | sql server where in list of strings | sql server where in list of values | sql server where in list variable

Notes and Slides

SQL Server Interview Questions Course Page

SQL Server Tutorial for beginners course page.

SQL Server Tutorial for beginners playlist

SQL Server Interview Questions and Answers

SQL Server Performance Tuning and Query Optimization

[MindandMatter-ep]

i have 9 years of experience in .net development & trust me when i was working as internee in an US based company back in 2015 this channel's videos i used to watch & learn.

Venkat sir this is your successful student god bless you

[MuqtadaHussainMMH]

In this video you have mentioned that in most of the cases joins work better than IN clause, a video on all such performance tricks in one place will be very helpful

[hannesbotha]

Thanks to all your previous videos on SQL Server I was able to make this string split function in SQL Server 2012/2014, but its good to know that its built in now much appreciated!

[akhilsingh]

Venkat Sir
Dhanyawaad
May God Bless You

[arfasaif]

omg thanks for this, it took me forever to find the reason.

[vijayanandb]

Hi Venkat .... learned sql server from your videos and today I am working as a database developer... I waiting from years to hear on performance tuning from you ... when can expect videos on sql server performance tuning

[sunils]

You are a god! thanks a lot for the free content

[abrammakgalemele]

Thank you kudvenkat. I had same problem at work. I ended up using STUFF in sql server.

[padmat]

Ever be thankfull to you sir....🙏 extremely helpfull and way of explaining content is superb

[d-mon]

God. I was using dynamic sql the whole time. Thanks for the clip

[zoomtomanav]

As always, This is great. Thanks a lot for sharing.

[yogeshjoshi]

Msg 137, Level 15, State 2, Line 2

[biwithmina]

The title of this video should be String_split. Good Job on this tutorial

[priyankamaru]

Venkat sir, please solve this. It would be so helpful to me

Here are two table given as follow:
1. EmpMaster table
Column:
EmpId
EmpName
EmpDeptId
EmpSalary
ManagerEmpId
EmpDateofJoining

2. DeptMater table
Columns:
DeptId
DeptName
DeptHeadName

Q-1
Pull all the department list and name of all employees who is taking highest salary for that department, sorted by employee Salary desc

Output columns are:
DeptId
DeptName
DeptHeadName
EmployeeNameWithHighestSalary
EmployeeSalary

Q-2
Pull all the employees joined in march 2019 with below columns sorted by employee salary

Output columns:

EmpyId
EmpName
EmpSalery
EmpManagerName
EmpDeptName

[GobindaPoudel]

Very good sir, it helped me very well even in sql 2008.
Sir, in reference to sql server 2008, or R2, is it possible to set predefined columns to select in comma separated value list and use it in select query? For instance, I am leaving an example here
declare @column_list varchar(255)
set @column_list='DATE, REF_NO, TRADE_NAME, TRANS_OFFICE'
select @column_list from [LETTER_LIST]

-waiting for your quick response.
Thank you

[sravankumar]

Always came with new topics, excellent venkat..

[maheswark]

What is the use of this clause? we already have in clause

[cartercordingley]

Now show people how to use it if the value are from a table that need to be split.
Outer apply are can help out in this

[AkshayPaunikar]

Please also cover PARTITION BY in this series

[gauravtayal]

Dear Venkat,
Can we sort data column wise... In SQL?