Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Freehansje

  1. Freehansje

    Strange primary key behaviour

    Right, this seems to be working, tnx.
  2. Freehansje

    Strange primary key behaviour

    Consider the following: There is a table with 2 attributes, COPInstantieID as Int and LoketID as Int. Those 2 attributes are also the primary key. At some point an ExecuteSQL task runs this script: INSERT INTO Centraal.InstantieLoket( COPInstantieID, LoketID ) SELECT t1.COPInstantieID, 1 FROM...
  3. Freehansje

    SQL Script problem

    Hi ESquared, I have an (imperfect) script to get all the sequences from a given set and I did some tests. I entered your example in the table, which stores the dependencies of each cluster. I then ran my script and received all sequences. I put these sequences in an Excelsheet and grouped all...
  4. Freehansje

    SQL Script problem

    Sorry for the delay, did not receive any notifications on this thread. "Is this close to what you mean?" Yes it is exactly right. A Flexgrid is comparable with cells in an Excelsheet. On your other remarks, you might be right, I'll have to think on this and discuss it with the designer. Tnx for...
  5. Freehansje

    SQL Script problem

    This set will be shown in a screen, in a Hierarchical Flexgrid to be exact. The cells in this Flexgrid will be stretched or merged where appropriate. If I take example 2: Cl_01=> Cl_02=>Cl_08 Cl_07=>Cl_08 Stretched: Cl_07 will be stretched to the width of Cl_01 and Cl_02. Merged: Cl_08 in...
  6. Freehansje

    SQL Script problem

    OK, here's a test example: PrevJobname Jobname Cluster_01 Cluster_02 Cluster_02 Cluster_04 Cluster_02 Cluster_08 Cluster_03 Cluster_04 Cluster_04 Cluster_05 Cluster_05 Cluster_06 Cluster_07 Cluster_08 There are 2 sequences here: Cl_01=>Cl_02 AND Cl_03=>Cl_04=>Cl_05=>Cl_06 And Cl_01=>Cl_02...
  7. Freehansje

    SQL Script problem

    Imagine this situation: Job3 needs to start AFTER Job2 has finished AND Job4 has finished. Job2 can start AFTER Job7 has finished. Job7 and Job4 have no preceding job and can run independently from each other. It's difficult to explain here without graphic options, but I'll try. The sequence...
  8. Freehansje

    SQL Script problem

    ESquared, and all of you, yes you've helped, up to a point. I still am looking for a solution where 2 jobs(independend from each other) need to finish for a third job to start. I'm working on 2 solutions, 1 of them with a different table, where some sequence information is stored as well. I...
  9. Freehansje

    SQL Script problem

    Jobs maybe used in different sequences. Sequences may change over time, added and deleted. Re-usability is the idea behind this.
  10. Freehansje

    SQL Script problem

    Yes, there are 2 job-sequences there; I need to get both those sequences. But I'm on the right track, I think. I was hoping there would be an easy, simple way of doing this, but I guess not. Thnx, FreeHansje
  11. Freehansje

    SQL Script problem

    Hi LNBruno, In the table you described the column Jobname holds the Job, which can only start after the job in column PrevJobname has ended. In your example 2 sequences would have to crop up: 1 Job1 => Job10 => Job20 2 Job2 => Job30 => Job40 => Job50 Now, these are single-item sequences...
  12. Freehansje

    SQL Script problem

    Sorry, you are right, I should have given an example. Suppose you have this sequence: Job10=>Job30=>Job20 AND JOB25=>Job15 Translation: first Job10 needs to finish, then Job30, after that Job20 AND Job25 need to finish before lastly JOB15 can start. I hope I make myself clear.
  13. Freehansje

    SQL Script problem

    I have this table CREATE TABLE table1( Proc VARCHAR(10), PrevProc VARCHAR(10)) Both fields are mandatory. In this table sequences are stored of jobs to run. PrevProc will hold the name of the job which has to finish before the job in Proc can run. What I need is a resultset per sequence, which...
  14. Freehansje

    Sudden replicationproblem, unsolvable?

    Hi Phil, Tnx for answering. I did re-create the publishing from scratch, after recreating the targetDB scripted from the publishing db. Same problem. And I use Redgate... Still looking, but I really am flabbergasted
  15. Freehansje

    Sudden replicationproblem, unsolvable?

    Hi, We're running a replicationprocess for months now, and 2 days ago it broke down, for no appearant reason I can detect. The setup is this: A SQL2K server has a publication defined on a database, consisting of several dozen tables. It is a transactional publication, running continuously. There...
See more

Part and Inventory Search

Back
Top