Answer Posted / jk.garg25

you can write this query in table valued function

DECLARE @RangeValue As VARCHAR(MAX)
SET @RangeValue = '1,2,'

DECLARE @Qry As VARCHAR(MAX)

DECLARE @ResData AS VARCHAR(MAX)
DECLARE @InData AS VARCHAR(MAX)

DECLARE @rId AS INT
DECLARE @Pos AS INT

SET @ResData = ''
SET @InData = ''
WHILE(LEN(@RangeValue)>1)
BEGIN
SET @Pos = CHARINDEX(',',@RangeValue,1)
SET @rId = SUBSTRING(@RangeValue,1,@Pos-1)
SET @ResData = @ResData + CASE WHEN @ResData <> '' THEN ','
ELSE '' END + 'ISNULL(['+ CAST(@rId AS VARCHAR(5)) + '],0)
AS Range' + CAST(@rId AS VARCHAR(5))
SET @InData = @InData + CASE WHEN @InData <> '' THEN ','
ELSE '' END + '['+ CAST(@rId AS VARCHAR(5)) + ']'
SET @RangeValue=SUBSTRING(@RangeValue,@Pos+1,LEN(@RangeValue))
END

SET @Qry =
'SELECT '
+ @ResData +
' FROM
(
SELECT Col1 FROM table1(NoLock)
) p
PIVOT
(
MAX (Col1) FOR Col1 IN (' + @InData + ')
) AS pvt'

--PRINT (@Qry)
EXEC (@Qry)

How can sql injection be stopped? : sql server security

954

---

What are the differences between having and where clause.

919

---

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

923

---

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

954

---

Can you explain full-text query in sql server?

969

---

How do I find information about the install locations for the various instances running on a computer?

1030

---

Do you know data definition language, data control language and data manipulation language?

981

---

What is difference between primary key and foreign key?

833

---

What the different components of Replication and what is their use?

1014

---

when would you go for denormalization? : Sql server database administration

809

---

Write a program using SQL queries to find a unique entry in a table.

940

---

If user is owning any SQL Objects, can we drop that user

2007

---

Explain about link server in sql server?

1001

---

What is the difference between varchar and nvarchar?

897

---

What are the authentication modes in sql server? How can it be changed?

1053

---