Thanks for the reply.

The table has the row with person Id 204

The PersonId 204 row is updated with bonus to without bonus(Say 10 to 15)..

I want to update the particular...

Thanks!!!!

🙂

After adding left outer join between two table, No proper result found.

I mean the all the data from the left table is not retrieving but only the matching records between...

1) There is a table variable called @benList. I would try converting this to a temp table. The optimizer will only count a table variable as having one row.

Ans: Not...

Hi guys,

This is i have from yrsday to the previous query..Still no improvement on the query..

Need some more inputs to it

DECLARE @benList TABLE(org_Name VARCHAR(150), org_Id VARCHAR(30), parent_Name VARCHAR(150), parent_id VARCHAR(150),level...

Jason & Guys,

I'm bit confused with discussion going on here.

I worked with the jason post CTE method (Replacing Correlated Queries to CTE) but it is taking much more...

SELECT name as Name, SUM(population) as Popualtion

FROM bbc

WHERE population >1000

GROUP BY name

If you aggregate the specific column then other remaining column in the select list should be group by...

It is report Query..$P is an varaible(Filters) to which report runs.

There query has more than 50 tables to it, so cant post such definition..

The above returning exact data but performing...

Thanks for the reply.

No we cannot crest another table but we can do with scalar or table variable, if necessary.

Yup there is lot of correlated queries too..

However, please let me...

It is something like this...

In the Execute SQL task, Should configure this..

Name of the table of the data flow task and row_count of the insertion took place for everytable into...

Dyanmic...

If it was fixed then i wud have hardcore the table name and insert but it is dynamic

This is sample table

EventYear EventMonth Item_name Value Cummulative_Total

2012 ...

Thanks for the reply..

I Have written my own logic which is below...

In this logic... I'm unable to do much for the missing month Between Actual and Forecast series..

The Logic is...

'1800m480000ik8t7pqs0000000','MDW - ABG - Optimum Volume Segmentation','Domestic','Northern Central Area',NULL,18603,NULL,NULL,16350,NULL,-2,33171,0

'1800m480000im880va80000000','STL - ABG - Walk Up Enhancement (Replication)','Domestic','Northern Central Area',NULL,2366,NULL,NULL,4186,NULL,821,1600,51

'1800m480000in300arog000004','IND - ABG - Fuel Accountability (Replication)','Domestic','Northern Central Area',NULL,3596,NULL,NULL,3316,NULL,9930,3503,283

the Next row should be...

Sum should be in rows instead as mentioned in column wise

For every Country & region

I want to show in the Rows as i should in the example