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)

What happens when transaction log is full?

927

---

How to modify the underlying query of an existing view?

990

---

Which autogrowth database setting is good?

1059

---

What command would you use to create an index?

1056

---

What is the main purpose of having conversation group?

899

---

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

990

---

What is a join in sql? What are the types of joins?

1107

---

What is the difference between substr and charindex in the sql server?

1101

---

What stored by the model?

1059

---

What stored by the master? : sql server database administration

1110

---

you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

984

---

What does man by sql wildcard characters in sql server?

1060

---

Why are you getting errors when creating a new odbc dsn?

1223

---

What action plan is preferred if sql server is not responding?

1104

---

What is read uncmmited?

1059

---