Database

SELECT FID,Code,Max(Value1),Max(Value2)
FROM TableName
Group By FID,Code

DECLARE
	@Day INT
	
SET @Day = 1

WHILE @Day < 101
BEGIN
	SELECT DATEADD(d,@Day,GETDATE())
	SET @Day = @Day+1

END

scottichrosaviakosmos wrote:

achieve this by query

Select * from Gendates(StartDate, Days)

case when 
     cast(right(@dates,2) as int) > 1
then 
     convert(char(8),dateadd(month,1,cast(left(@dates,6) + '01' as datetime(8))),112) 
else 
     @dates 
end

SELECT ...,...,...,MAX(open_value_1),MAX(close_value_1) FROM 
(
--YOUR SELECT QUERY
)A
GROUP BY ...,...,...

;WITH SukTable ([Suk]) AS
(
	SELECT 'abc 111 bbb 1212'
	UNION SELECT 'pqr 222 ccc 2323'
)
SELECT
	SUBSTRING(SUK,1,3) AS Field1,
	SUBSTRING(SUK,5,3) AS Field2,
	SUBSTRING(SUK,9,3) AS Field3,
	SUBSTRING(SUK,12,5) AS Field4
FROM SukTable

;WITH SukTable ([Suk]) AS
(
	SELECT 'abc 111 bbb 1212'
	UNION SELECT 'pqr 222 ccc 2323'
)
SELECT
	LEFT(SUK,CHARINDEX(' ',Suk,0)-1) AS Field1,
	SUBSTRING(SUK,CHARINDEX(' ',Suk,0),CHARINDEX(' ',Suk,CHARINDEX(' ',Suk,0))-CHARINDEX(' ',Suk,0)) AS Field2
FROM SukTable