The Guru's guide to TSQL programming gas a very good section on this subject (Don Henderson I Think)

I would add that you should give some consideration to the permanence volume and security of the data you're going to be manipulating. Basicaly the XML route is fine for...

Looking at your example I can't see where you are populating your temporary table.

More importantly I'm wondering whether you really need to use a cursor to do what you...

I'm not sure that Identities are what you want. Basically an Identity column shoul only contain unique values (the number is invremented for each succesive record inserted) It's ideal for...

We do this sort of thing on a regular basis and we use # temp tables as Antares suggests. If you need more than one set of results you can...

The solution so far is great and you can represent multi-levels by recursively reading the BOMs so you could have

Car

---FRONT WHEEL

--------------Hub

--------------Tyre

--------------Bolts

---Rear Wheel

--------------Hub

--------------Tyre

--------------Bolts

A couple of things to consider, which though stating...

I'm not sure quite what you're trying to do but the following code should create the the records you want

INSERT INTO Table1(

RELATEDRECORDID,

FIELDID,

SOURCERECORDID)

SELECT

1,

614,

ID

FROM TABLE2 WHERE PROJECTID IN (18, 26, 20, 22,...

Yup BOM's are complex to maintain, that's why Manufacturing Control packages want big bucks. However, I've worked (and designed) several MRP systems in my time including for the Apparel trade.

You...

OK this is the nub of Manufacturing control systems. You have to make a seperation in your mind between products and Bills Of Material (BOM's) You're most of the way...

Interesting question. I guess the answer is six of one and half a dozen of the other.

With regard to parameter tables in particular I always tend to give these an...

Thinking outside the box, why do you have to use a cursor in this case. From what I can see you are collating data for each of the brands in...

With that number of ID's I think I'd be inclined to drop the values into a table and use a join rather than an IN clause. I'd also be inclined...

Extract from MSDN on RDO Queries

If the SQL query you need to execute includes one or more parameters in the WHERE clause, you can use the rdoQuery object to run...

I'm always wary of things that "start small" It's been my, sometimes painful, experience that a succesful "small" application grows exponentially. As users discover it works and produces results they...

Depends what you're storing in the column.

Personally I subscribe to the Keep It Simple philosophy. If you data can be represented in the simpler (and cross platform-compatible) VARCHAR type I...