Hi Professional,

Just please tell me which HINT's i need to use in the mentioned above SQL for retrieving the data fast.

Regards,

Kiran

Hi,

Thanks for the reply....

In this SQL below objects have been used

--Tables

co_individual_x_organization

co_individual

co_individual_ext

--View

vw_client_ri_club_flex_structure

--Function

fn_client_ri_all_rotary_years

For the table there are so many columns.

So can you able just look to where i need to change...

Thanks for your reply its very nice for SSIS.

Thanks Sir,

its working....

I was trying the same in my SSIS package but was not working properly...

I have modified my source sql..

Thanks for your help

Hi,

please see my updated sql below,

drop table [d_org_test]

go

CREATE TABLE [d_org_test](

[org_level_name] [nvarchar](30) NOT NULL,

[org_club_id] [int] NULL,

[clb_period] int,

[org_club_name] [nvarchar](150) NULL,

[org_club_status] [nvarchar](20) NULL,

[org_rec_eff_dt] [date] NOT NULL,

[org_status_change_ind] bit null)

insert into [d_org_test] values ('Club',2146,8,'Chatfield','Active','1905-01-01',null)

go

insert...

Thanks Sriram,

your result is absolutely correct but I have to display this result by using sql and I have to use that sql as a source for populating my destination...

Thanks it work

Thank It worked.

Thanks a lot its working...:-)

Thanks for your valuable help its fine for me:-)

Hi,

Its giving me the result as below,

num_keyname

1Member

2Honorary Member

3Charter Member

1RIBI

2GB

3TRF

5Pol

6Dist

8Rot

10Clb

but I want the output as like below,

I don't want num_key in order by but name should me in order by

num_keyname

3Charter...

WITH CTE_First(Num_key, Name) AS

(

SELECT 1, Name FROM abc_test WHERE num_key = 9

UNION ALL

SELECT 2, Name FROM abc_test WHERE num_key = 7

UNION ALL

SELECT 3, Name FROM abc_test WHERE num_key = 4

)

SELECT...

It should be anything but I have to show num_key values for first three records are

Member has key 1,

Honorary Member has key 2,

Charter Member has key 3,...

yes I want only the result start with,

Member has key 1, Honorary Member has key 2, Charter Member has key 3, and the other officer roles are sorted by name.

Thanks,

Kiran

Hi,

Please provide sample data.