hi..

I have 3 tables

table names :A,B,C

A table have columns :

A1 ,A2,A3

B table have columns like:

B1,B2,B3

C table have columns like:

C1,C2,C3

My procedure like this..

select A.A2,A.A3,B.B2,B.B3,C.C2,C.C3 from A...

thanks...

but what I need suppose I inserted 1 to 10 values in a table

and deleted 5 to 10 ..next i will insert record 11 is the id values..

I want to...

thanks for this..

it send inserted record id .i wont insert any record ..but i need to find id value what we are going to insert the database table

regards

Dastagiri

thanks...

but what I need suppose I inserted 1 to 10 values in a table

and deleted 5 to 10...

Hi thanks

But in my database table all columns are not static.Means ListRowID, ListColumnID and ListColumnValue.

how can I write query?

thanks,

If ListColumnID is not static, what I have to do?

suppose ListCoumnID is increased.

please create table dynamically.

Thanks to send solution to my query.I felt happy.

But I have one problem.

I have data like below

venkat

2136548974

kadapa

AndraPradesh

India

giri

2136548974

kadapa

AndraPradesh

India

ram

2136548974

kadapa

AndraPradesh

India

nag

2136548974

kadapa

AndraPradesh

India

sreenu

2136548974

kadapa

AndraPradesh

India

nanda

2136548974

kadapa

AndraPradesh

India

subbu

2136548974

kadapa

AndraPradesh

India

I want data as shown bellow

column1 ...

Thank you for this ..

but any automatic option in sql server 2005 to take script with data.

thanks..

give me one souce example

regards:

Dastagiri.D

hi,

sorry for what I wrote my lines in uppar case in my forums,Really I dont know it's indicates to shout....

Thanks

Giri.D

I WANT TO KNOW WHAT IS THE LAST 10 RECORDS IN MY DATABASE TABLES .IS ANY COMMAND IS THERE OR NOT ? ...

hi,

I attached one file.on that file one table is there .That table have 100000 records.

When i used profiler and found duration time when execute that query.It takes 1584 mILLIseconds.

any...

hello,

In my query are:

1) select * from orders where ordered BETWEEN 100000 AND...

HI krayknot ,

I saw that link it is very usefull for me..

Thank you

Dastagiri.D..

Hi,

sorry for the sending in backup forums.

Thank you,

Dastagiri.D