Thnx David.

It is working.

The TOP 1 clause gives me the first series only. I need to know the exact number of series in the data if it has to...

Yes. the same output u have shown is perfect.

107 and 112 values are not sure.

And also the series of values will vary depending on the values in the columns. This series can be more than one in...

Hi Vinod!!!

I hope u r feeling well!!!

May i know why this discussion is "stupid" for u!!!

Tell me if u know the answer for the question!!!

thnx!!!

I have checked INFORMATION_SCHEMA.TABLE_CONSTRAINTS and INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE. I m able to get the primary key column. But how to determine the Foreign Key column i.e., to which table it belongs!!

It will...

Thnx..

But not with Query Analyser also.

Is there any SYSTEM VIEW which provides the script???

or

Can i get the columns details with PRIMARY key, it's FOREIGN key, IDENTITY columns.

yea.. its true..

i asked for STUFF coz i tried it and was not able to get the desired result.

I want to do post-processing on the data so that "somepartofvalue" is...

thnx. it worked.

Can it be done with the STUFF function

The job sites actually record the number of times it was found in a SEARCH... Selection or Viewing can be done by maintaining the COUNT for the no. of times...

Consider the example of a job site. You have uploaded ur resume. They keep a track of no. of times your RESUME has been found in various searches (not selected)...

i m also doing the same thing...

thnx...

OK

Any other method which i can use for the multiple arguments...

Thru XML ????

i need to create a STORED PROC which will convert its arguments into INSERT's, UPDATES, DELETES...

The arguments are...

INSERT/SELECT/UPDATE is possible...

How would is create a new procedure or say a table on different server...????

I m able to do it by maintaining different connections in the application.(ie., source &...

thnx,

i tried that sp_linkedserver

it is registering the server on my computer and that's all it is doing..

How do i access that server? Is there any method?

My problem is to connect to...

You can have multiple authors of a book by using the following structure.

<book>

       <author>

            <firstname>john1</firstname>

            <lastname>smith1</lastname>

       </author>

       <author>

            <firstname>john2</firstname>

            <lastname>smith2</lastname>

       </author>

</book>