Database

Cheers, brother! I will. You will be the first to know.

Almost certainly, any shortcuts taken now will mean you or I will be fixing his garbage in the future. Never underestimate the power of human stupidity - RAH I'm old. I know stuff - JSOP

Quote: If there is absolutely nothing in common between the databases then I would probably have two separate databases and manage them separately. They will have some stuff in common, like the user data (username, email, password ...) and other stuff too, but they will also have some data that will be needed only for them separatly. So I'm goin to use something like you said. Quote: We are currently using schemas in a corporate database to indicate which "area" (application if you like) "owns" the data in the table(s) and using the dbo schema for common data (i.e. no tables with the same name in different schema). I'm new to this whole area of DB, so comments/suggestions like this one are really useful (practical not theoretical). Thanks!

The CTE king strikes again ;P Never underestimate the power of human stupidity - RAH I'm old. I know stuff - JSOP

You have already posted your question in QA. Reposting the question in other CodeProject forums - even if it's just a link to your question - will only serve to annoy the people you're relying on for help. Remember, the people who answer questions here are unpaid volunteers, who are spread out across the globe. Be patient - nobody is under any obligation to answer your question within a set time. "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

You're welcome. Should be faster for a search than filtering each table, at the cost of some diskspace. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

This question is not specific enough to answer well, because the answer is "write the code." Do you have a more specific question? Social Media - A platform that makes it easier for the crazies to find each other. Everyone is born right handed. Only the strongest overcome it. Fight for left-handed rights and hand equality.

Thank you very much k5054 for your explanation! :thumbsup:

That other reply is precise but not very useful. If you have a Mongodb where collections do not have some specific form then you are using it wrong. Besides the CLI I have also used two different UI clients for Mongo and both show the data that are in the collections in a reasonable way. Now if you are starting with a empty collection you won't know what will go in there and with a SQL table you would but that that is somewhat a matter of degree and not usability. In that case you should go look to your design, which you should have regardless, or the code.

To solve this problem you have to change: SEQUENCE\_NAME into SEQUENCE\_NAME The value for param was changed from just "sequence" to "sequence_name".

For some reason, last time I searched on google it didn't showed me anything useful (on any of the first 4 pages), but this time, I got the answer I needed. Solutions: 1. Use a different user then SYSTEM. I didn't though at this, after all I didn't wanted to complicate things on a learning project. 2. Filter each group using %. When I tried it before it didn't worked, but now after I started the DB again, the filter worked as it should have. Maybe there was an error connecting to the DB, don't know, it's good that now it is working.

Maybe try asking in the mongodb-users forum : [mongodb-users](https://groups.google.com/group/mongodb-user)

You already posted this question in QA at Can't get required output while executing procedure[^]. Please do not crosspost.

i finally figured it out, here's the result: DECLARE @PERIOD TABLE (start_time DATETIME, end_time DATETIME) INSERT INTO @PERIOD(start_time) SELECT t.start_time FROM ( SELECT act_start_time_utc AS start_time, state_cd AS new_state, LAG(state_cd, 1) OVER (ORDER BY act_start_time_utc ASC) AS last_state FROM SRPMES901007.WWMESDB.dbo.job WHERE act_start_time_utc IS NOT NULL) AS t WHERE t.new_state = 4 AND t.last_state <> 4 UPDATE period SET end_time = (SELECT TOP(1) act_start_time_utc FROM SRPMES901007.WWMESDB.dbo.job WHERE state_cd <> 4 AND act_start_time_utc > period.start_time ORDER BY act_start_time_utc ASC) FROM @PERIOD period SELECT * FROM @PERIOD ORDER BY start_time ASC But the query takes 19 seconds, can it be speeded up?

this works! Thanks.