Below is my try with formulated data

Declare @Id int = 3;

declare @t table (IdRelation int, Parent int,Child int)

insert into @t

select data.IdRelation, data.parent,data.child from (

select 1 as IdRelation, 1...

You are the man!!!!. Thank you so much.

Hi Erik,

I apologize for the delay in my response. I was on vocation and returning to my work today. I almost nearing my requirement completion.

I am trying to add if...

Hi Erik,

as i don't want to open a new post for this, as we have all the information on this post, i would like to extend this conversation.

I am able...

wonderful thanks you so much for the heads up

Hi Erik,

Here is my try

ALTER PROCEDURE [dbo].[GenerateScriptForStoredProcedure] (

@storedprocedure_name sysname

)

AS

DECLARE @sphelptext TABLE(script NVARCHAR(MAX));

INSERT INTO @sphelptext

SELECT N'USE ' + DB_NAME() + NCHAR(59) + NCHAR(13) + NCHAR(10) + ASM.definition

FROM sys.all_sql_modules...

Hi Erik,

Thanks for your reply.

I am little confused how to apply your logic in my sample. Below is my sample procedure

CREATE PROCEDURE [dbo].[GenerateScriptForStoredProcedure] (

@storedprocedure_name sysname

)

AS

DECLARE @sphelptext TABLE(script NVARCHAR(MAX));

INSERT INTO...

Hi Luis,

Thank you so much for your reply. As you said, i would go with DateAdd. Jut for my curiosity, will casting the date affect the performance?

Hi a4apple and Luis,

thanks for your reply. if all of these three is not reliable, which will be best syntax for this requirement. please suggest me

Hi Serg,

Thanks for your reply and as per my required output, i need to get for Mar the value should be 0.00 and SEP should not come into this...

Hi Erik,

thanks for your time on this post and reply. I like the idea but i need to show 0.00 for march as i need to display last 6 months....

Here is the only way of doing it which i know, is there any other way of doing this.

WITH CutomMonths

AS (

SELECT UPPER(convert(VARCHAR(3), datename(month, DATEADD(MM, DATEDIFF(MM, 0, GETDATE()) - N,...

thank you guys

Hi David,

Thanks for your reply.

Hi Luis,

Thanks for your solution and This is new syntax for me. this is the first time i am seeing this. Just curiosity how this...

Hi LutZ,

I agree and thanks for your details explanation with example. I will follow the standard as you suggested.