Viewing 15 posts - 1 through 15 (of 120 total)
The Guru's guide to TSQL programming gas a very good section on this subject (Don Henderson I Think)
February 17, 2004 at 7:27 am
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...
September 17, 2003 at 9:13 am
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...
September 17, 2003 at 8:59 am
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...
August 29, 2003 at 9:45 am
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...
June 27, 2003 at 6:10 am
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...
June 26, 2003 at 7:20 am
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,...
June 25, 2003 at 4:16 am
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...
June 25, 2003 at 1:09 am
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...
June 24, 2003 at 6:55 am
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...
June 24, 2003 at 4:13 am
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...
June 24, 2003 at 2:14 am
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...
June 20, 2003 at 1:00 am
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...
June 19, 2003 at 9:56 am
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...
June 19, 2003 at 5:19 am
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...
June 18, 2003 at 8:37 am
Viewing 15 posts - 1 through 15 (of 120 total)