SQL Complex Queries , Query Optimization and Interview Questions SQLServer 2019 |SQL Complex Queries

#sqlserverinterviewquestionsandanswers #SQLComplexQueries
#sqlserver #ssunitech #sql
sql server interview question and answer
sql server query related interview questions and answers

For SQL Quiz-

Find Us On FaceBook-

[ssunitech]

CREATE TABLE STRING_IQ_TBL
(
ID INT IDENTITY(1, 1), NAME VARCHAR(100)
)
INSERT STRING_IQ_TBL(NAME) VALUES('JOANNE'), ('HOWARD'), ('ROSIE'), ('JOHN')

SELECT * FROM STRING_IQ_TBL

CREATE TABLE STRING_IQ_OUTPUT_TBL
(
ID INT IDENTITY(1, 1),
CHARACTER VARCHAR(1),
TOTAL INT
)

SELECT @I=COUNT(1) FROM STRING_IQ_TBL
DECLARE @J TABLE (NAME VARCHAR(1))

WHILE @I>0
BEGIN
BEGIN
MERGE STRING_IQ_OUTPUT_TBL AS T
USING @J AS S
ON T.CHARACTER=S.NAME
WHEN MATCHED
THEN UPDATE SET TOTAL=TOTAL+1
WHEN NOT MATCHED BY TARGET
THEN INSERT (CHARACTER, TOTAL) VALUES (S.NAME, 1);
DELETE FROM @J
END
END

SELECT * FROM STRING_IQ_OUTPUT_TBL

[nishantade]

Hello sir your video is always helpful and knowledgeable. I request you to make video on Stored procedure or script including most of sql server concept as well as using multiple temporary tables.so that will get the idea how to create complex stored procedure. Thank you in advance!