DavidB (2/3/2009)

---

They are looking to streamline their application architecture in the object layer and with that part of it is using updatable views and instead of triggers. Agreed, they could...

DavidB (2/3/2009)

---

Not a fan of triggers in any way.

With that being said though do you have any experience with instead of triggers and if so, what have you seen?...

[font="Verdana"]How best to put this...

You might consider "database architecture" to be the parent of "database design". The architecture you choose will (to some degree) dictate how you then go...

[font="Verdana"]Heh. Nice to see someone who likes TOAD (I assume for SQL Server?) Personally I hate the product, but I know other people disagree. My issue with...

[font="Verdana"]I agree with the earlier comment about migrating the code. One word of warning: you will likely want to change the table names once they are in Oracle so...

[font="Verdana"]Me, I'd do this by writing a script that writes the script (by querying the SQL Server meta-data.)

If you don't know what you're doing there, perhaps there's a better solution.

Right...

[font="Verdana"]Ah! You see, with some context, it makes sense as to why you need to do it within the report. :D[/font]

[font="Verdana"]From my reading of the question, a job defined in SQL Agent is running a series of queries, and the results from the queries are being logged to a file....

[font="Verdana"]I'm still struggling with reading most of the questions. I think it's...

beetlejuice (2/3/2009)

---

Most modeling tools use proprietary file formats to store diagrams, which works fine for local editing but less in distributed environments, with several people accessing and modifying the same...

[font="Verdana"]I'm guessing we need some idea of why you need to delete records without having the delete logged. If we understand the why, we may be able to give...

[font="Verdana"]Ah, so he's a "common table expression"? In which case, he's also useful...

[font="Verdana"]Here's how I'd do it:

Use a Common Table Expression (CTE) or in-live view to calculate the "house id" and maximum date for each "house id" (i.e. the last status entry)....

[font="Verdana"]Heh, that's kinda ironic. Jeff Moden asking for a URL to one of his own posts.[/font]

[font="Verdana"]I guess I am still trying to understand why you need to do this. From experience, over-generalised designs are a way of compensating for a lack of analysis. ...