Database

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

GO
/****** Object:  UserDefinedFunction [dbo].[SplitGETPosFunc]    Script Date: 10/20/2010 15:22:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER FUNCTION [dbo].[SplitGETPosFunc](@String varchar(8000), 
@Delimiter char(1),
@POSITION INT)
RETURNS varchar(1000)
WITH EXECUTE AS CALLER
AS
begin     
	declare @idx int;     
    DECLARE @CHARIDX INT;
    DECLARE @INPUTSTR VARCHAR(8000);
    declare @OUTPUT varchar(1000);
    SET @INPUTSTR=@String;
    SET @CHARIDX =0;
    SET @idx=0;
    if (substring(@String,1,1)='S')
		begin
			while @idx < @POSITION   
				begin     
				SET @CHARIDX= CHARINDEX(@Delimiter, @INPUTSTR);
				SET @OUTPUT=SUBSTRING(@INPUTSTR, 1, @CHARIDX - 1)
				SET @INPUTSTR = SUBSTRING(@INPUTSTR,@CHARIDX +1,LEN(@INPUTSTR));
				SET @idx=@idx+1;
			end 
		end
	else
	   set @OUTPUT=@String;
return   @OUTPUT;  
end