Thanks a lot Eirikur:)

Thanks for giving hint:)

Still I am facing this issues. dear all pls help any one.

Thanks dwain

Hi,

I guess we dont have the Oledb Driver support for 64-bit machine

Hi Jack Corbett,

yes correct ,its working only in 32 bit and its not working in 64 bit...

How to run this in 64 bit machine.Is there any way to solve this...

Thanks dwine flame!!

hi adrian.facio,

This Query shows the good performance and got the exact output..

Thanks!!!

Hi Dwine Flame,

Its really helpfull..Thanks a lot

with...

Hi,

Please Construct the query to get the Requiered output Table using the InputTable(without using the while loops)

Input Table

Row Person

1 101

1 102

1 103

2 101

2 102

2 104...

Hi,

Please Construct the query to get the Requiered output Table using the InputTable(without using the while loops)

Input Table

Row Person

1 101

1 102

1 103

2 101

2 102

2 104...

Hi,

Please Construct the query to get the Requiered output Table using the InputTable(without using the while loops)

Input Table

RowPerson

1101

1 102

1103

2101

2 102

2 104

3101

3103

3105

Requiered OutPut Table

...

Hi Divine Flame,

Sorrry for Inconvenience.Please Construct the query to obtain the requiered output table without using while loops.

Input TableRequiered OutPut Table

Row Person...

Hi

InputOutPut

Row Person Row Person Count

110111011

11021 1021

110311031

210121012

21022 1022

21042 1031

310121041

310331013

310531022

31033

31041

31051