That was helpful..Thanks...

Could you help me understand how C1 version of table CTE has only 2 rows even if I inserted 3 rows and did select(*) in CTE definition

and C2 version of...

@SSCrazy

Thanks for the code...It is working for my dataset...

I actually have a defined crieteria upon which I want to perform rate calculation..

I have the datetime_record ordered by datetime desc...

and I want to pick next immediate datetime column for...

Sorry for error...I missed something

Let us say when I exec stored proc

EXEC myproc (32,442,5000)

I want the code to insert into table 3 times one having period value 32.

2nd insert having period value 442...

@jerry, @sql frndz...

Thanks..I shall use SSRS...

The if exists statement that I included performed the check but it also updated the column group values that were not equal to 2 (<>2) made 2.

It updated the legitimate...

@Lowell

Thanks lowell

I created another stored procedure to check the condition and to call this stored proc..and I am able to check the condition....

I want to include this check within the stored procedure. I want sql to automatically check when stored proc is called by JOB...Can I do that?? or should I check...

I have a weired issue with my Record stamp filter in Index seek operation. The argument shows the following

...

Chris,

I shall do it that way. I actually found that one of the join was redundant and removed it and found performance improvement.

Grant,

Thanks for your reply. Shall not worry abt...

..

..

..