I think this is what you are looking for...it would dynamically flatten your data :

--Creating Table

CREATE TABLE #Test

(

ProductID int,

MainMasterFeatureID int,

--MasterFeatureValue Varchar(100),

ChilFeatureName varchar(100),

ParentFeatureName varchar(100)

)

--Inserting Sample Data

INSERT INTO #Test

SELECT...

raghuldrag (1/8/2013)

---

Hai friends

i ve 5 tables now i wanna make a join with in that and i m done join

now the problem is how to pass...

If the values in the node column can be dynamic then you can do a Dynamic Cross tab as follows :

--Creating Table

Create table Ex1

(

ID Int,

Name Varchar(30),...

Karthik could you brief us upon the requirement a bit??...It won't be that much of an effort......Plus you might get opinions that might make this requirement easier for you cause...

It depends.

If the insert and updates are not inter-related then I would suggest that you put them into different transactions as this would lead to holding of Transaction Locks...

I'm glad I was of some help.

You should...

I am assuming that Results1 is a data set that you are selecting a table....

Yes it is correct.....if the Destination Table is created by the Import/Export Wizard....

Is it still not working??.....I thought you had got it working.....Please post the detailed Error message.

All the tables.....do you mean including the parent table which is being referenced by the Child Table??.....If that is so then the Foreign Key Constraint can be created as the...

ananda.murugesan (12/31/2012)

---

Source database - data is available for all tables...

Generate Script source database and create newdatabase with another name and all other structure and PK, FK ,Identity every thing same...

dwain.c (1/1/2013)

---

vinu512 (12/31/2012)

---

Satish's Query is partially correct but it doesn't break the records on th basis of Column1. You would nee to do a Correlated Subquery for that as follows:...

Satish's Query is partially correct but it doesn't break the records on th basis of Column1. You would nee to do a Correlated Subquery for that as follows:

--Creating Table...

The table you are trying to insert data into has a Foreign Key Constraint. Which means that it is referencing another table for values in the Foreign Key column. It...

Thanks....Happy New Year to you guys as well and everyone at SSC 🙂

You're Welcome....By the way...