Hi

Check out the below link

This has somany ways to do this.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6027

Hi

Database diagrams are stored in the dtproperties table, you can use DTS to copy this data from one database to another.

Please let us know, if this doens't solve your purpose.

Hi

Could you please paste the code of your stored procedure and how are you calling that.

db2l (4/15/2009)

---

I was actually trying to open the tables through Management Studio....and I know where I was going wrong..

I was trying to "right-click" and "edit" on the table, when I...

lmu92 (4/15/2009)

---

Vijaya Kadiyala (4/14/2009)

---

There are so many ways to write a script.

Couple of points:

1) What if the table names are not same ex: DEPT,EMP,LOCATION etc.

2) What if the table names...

Hi Kavin

It would great if you post Table structure, sample data and your requirement once with examples.

nitinkumar_tss (4/14/2009)

---

Hi,

My data is in the following format:

Table1

Key ...

Bob's solution is perfect.

You can even think about using PIVOT table on Table2 to convert rows into columns.

Hi

In addition to the above, When you store XML in nText datatype do you validate this in any Business Layer with a XSD?

Hi raghu,

did you get the answer?

Hi

This is similar to parent child relationship and finding out all the childerns of a parent using T3 table (where the Parent and Child relationship is mentioned).

Check out the below...

Hi Steve,

Thanks for considering.

Hi FLo

In short you can call me "VJ";-)

Hi

In that case you may want to check out the feature "Computed Columns".

http://www.dotnetvj.com/2009/03/computed-columns-in-sql-server.html

There are somany ways to write a script.

Couple of points:

1) What if the table names are not same ex: DEPT,EMP,LOCATION etc.

2) What if the table names are having gaps ex:...