Viewing 15 posts - 136 through 150 (of 411 total)
You should be able to do something like:
select a_abpm40.PAT_NR, a_pat.pat_id, a_pat.op_datum, count(a_abpm40.ABPM) as CountsBelow40, count(a_abpm40.ABPM)/6.001 as TimeBelow40, po_perf, po_timer6, ((count(a_abpm40.abpm)/6.001)/po_perf)*100 as PercentTimeBelow40
from a_abpm40 inner join a_pat on a_abpm40.pat_nr=a_pat.pat_nr
where po_timer6...
February 8, 2009 at 12:31 pm
phoenixrising1599, having tried to read over the licensing terms previously, I think you are better consulting a lawyer than a group of DBAs on that questions, but here is my...
February 3, 2009 at 8:36 am
Congratulations! This has been an awesome site.
January 29, 2009 at 2:09 am
Jeff Moden (1/23/2009)
January 24, 2009 at 7:23 pm
Jeff Moden (1/22/2009)
So! Anybody wanna talk about all the companies that use spreadsheets like databases? I'll start... I hate them all. 😛
I cannot possibly agree more. ...
January 23, 2009 at 12:00 pm
Grant Fritchey (1/23/2009)
timothyawiseman (1/22/2009)
January 23, 2009 at 11:57 am
That does make sense, but I would advise the rollback strategy should be to restore the applications from backup.
Even if I am wrong and there is in principle a way...
January 22, 2009 at 5:22 pm
I'm not aware of a way of removing it without uninstalling and reinstalling SQL Server. May I ask why you would want to?
January 22, 2009 at 5:00 pm
SQL Server Magazine just did a review of Sql Scripter 2.0 this month. The review is at http://www.sqlmag.com/Article/ArticleID/100565/sql_server_100565.html
January 22, 2009 at 4:59 pm
drodriguez (1/22/2009)
Is there a way to query or capture a record that is being deleted from a table in a trigger? I want to shoot off an email when...
January 22, 2009 at 3:59 pm
I'll agree with Grant, though there are some cases where it makes sense to have a column named Id in the base table and then the foreign keys referencing it...
January 22, 2009 at 3:15 pm
Jason Shadonix (1/16/2009)
Hey! How come nobody is mentioning how good Access is!? :hehe:
Heh. Access really does have a place in its niche, but it doesn't stand with...
January 16, 2009 at 4:26 pm
gints.plivna (1/16/2009)
If we are extending the subject so much I'd say that most probably everyone of these (List of database management systems) has some strengths 😉
Heh, you definitely have a...
January 16, 2009 at 1:06 pm
Just to toss this out there, but don't forget MySql as an option if you are making a RDBMS decision. In comparing MySql to SQL Server I would again...
January 16, 2009 at 9:04 am
My opinion is definitely slanted since I earn my living with SQL Server and have only used Oracle in an academic environment, so I have vastly more experience with SQL...
January 16, 2009 at 8:58 am
Viewing 15 posts - 136 through 150 (of 411 total)