USE [AdventureWorks]

GO

CREATE TABLE [dbo].[tblA](

[ID] [smallint] NULL,

[Code] [varchar](50) NULL,

[Date] [date] NULL

)

CREATE TABLE [dbo].[tblB](

[ID] [smallint] NULL,

[Percentage] [varchar](50) NULL,

[EffectiveDate] [date] NULL

)

GO

INSERT INTO [AdventureWorks].[dbo].[tblA]

...

My bad!

Structure is not showed properly.

TableA: Col1-> 1..2

Col2 -> 121...341

Col3-> Date's

Col4 -> empty

TableB:

Col1 -> 1..2

Col2-> Percentages

Col3-> Date's

Can I know why you used rank() for max_b and row_number() for max_c?

Your solution is real sensible as I am using a table of millions of records, where I need to take care of Performance

Yes, this is working. This is what I want.

Truly....Thanks a lot.

Actually the data will be like

10 1 1

10 1 2

10 2 1

10 2 2

10 3 1

10 3 2

11 1 1

11 1 2

11 2 1

11 2...

You are right on B and C

but I need all A's where, for every A I need max(B) in that result again I need Max(C)

I mean to say that..

I need a query to get data of Max value in B and again in B, I need Max value in C

Yes, you are right.

I need (10,3,2)

answer here

http://www.sqlservercentral.com/Forums/Topic1182700-392-1.aspx

My bad!

last 2 records are

12 3 1

12 3 2

I need a query to get (12,3,2)

Got Clarified

It is Integer column, so I cannot pass empty string to it.

I used Fuzzy Lookup for this work. It gave me expected result.

thanks for reply

Both transformations can add new columns,

Copy column tX can add new columns only through existing columns but coming to Dervived column tX it can add new columns without any...

Thanks Kraig