Hi,

nothing,I trying to display my data better.two column data are separated by =

BLOCK_ID = TOTAL

1 =...

Hi,

Sorry my mistake.

Hi,

If you try little hard you can achieve this.

In sql server DTS you can write script like this.

Find all cloumn name of that table.

say you get fname,lname,roll,age.

Then you can query...

Hi,

It would be kind, if you explain set base code with suitable example.

Why we should use set base code instead of loop and cursor.

Tanks

Hi,

No ,Sql Server we do not use cursor and also in sql server we can do without cursor.

But in oracle I see that using cursor is must.

Also,I read here that,we...

Hi,

Finally problem solved.

First create temp table1(create column name accordingly) and insert record of candidate table and qulaification of table where candidate.id=qualification.id and candidate.jobcode=qualification.jobcode and qualification.type='15'

again join candidates table and qulaification...

Hi,

Finally problem solved.

First create temp table1(create column name accordingly) and insert record of candidate table and qulaification of table where candidate.id=qualification.id and candidate.jobcode=qualification.jobcode and qualification.type='15'

again join candidates table and qulaification...

Hi,

Finally problem solved.

First create temp table1(create column name accordingly) and insert record of candidate table and qulaification of table where candidate.id=qualification.id and candidate.jobcode=qualification.jobcode and qualification.type='15'

again join candidates table and qulaification...

Hi,

Finally problem solved.

First create temp table1(create column name accordingly) and insert record of candidate table and qulaification of table where candidate.id=qualification.id and candidate.jobcode=qualification.jobcode and qualification.type='15'

again join candidates table and qulaification...

Hi,

Finally problem solved.

First create temp table1(create column name accordingly) and insert record of candidate table and qulaification of table where candidate.id=qualification.id and candidate.jobcode=qualification.jobcode and qualification.type='15'

again join candidates table and qulaification...

Hi,

Then my problem didn't solve.

I hope this time my problem is clear.

I want records in those particualr format,so that I can use it in my application with ease.

Also ,it'll clear...

Hi,

Thanks a lot.

It will work.

I let you know exactly.

Table are so big,I don't know how to present data.

Minimum Data of Personal Details can be

id Jobcode Name ...

Hi,

Sorry Sir.

Table are so big,I don't know how to present data.

Minimum Data of Personal Details can be

id Jobcode Name ...

Hi,

I think I hv posted my problem ok like providing,structure of tables.

only thing is that i didn't populated my tables.

I agree ,I did'nt post my problem in few words,coz...