good; just create a superview then, that contains everything you need, and select from that;

CREATE VIEW vw_SuperView AS

SELECT

[Fault],

COUNT([Occurred]) AS [Occurances],

sum(datediff(ss,0,[Duration])) AS [DTDuration]

FROM Table1

GROUP BY [Fault]

UNION ALL

SELECT

[Fault],

COUNT([Occurred]) AS [Occurances],

sum(datediff(ss,0,[Duration]))...

can you change the "duration' column to be an integer with the number of minutes or seconds or something?

or do it inline int he view?:

CREATE VIEW vw_Table1 AS

SELECT

[Fault],

COUNT([Occurred]) AS...

sunshine-587009 (4/28/2010)

---

xp_cmdshell is enabled I run the following and it says executing but nothing actually happens it just continues to say executing when via cmd prompt it works and only...

Alan, don't put the summary results into a table. Always create a VIEW, which gets the data you want on demand instead...the view would be correct at all times, and...

nearly the same as ms65g's reply:

SELECT

col0,

min(col1),

sum(col2),

max(col3)

from #Example

Group By col0

the 64 bit drivers are not named odbcad32; I'm very sure they have a different name,and contain "64" in their name.

that's the issue i think; trying to use 32...

does your server have a lot of free space? if it does not, it might be taking a long time trying to find 3.8 gig of space to restore the...

there is a seperate download for 64 bit Oracle drivers from Oracle; so it might be true the oracle 32 bit client tools are installed on the server, and they...

ColdCoffee is so right; giving us the tools to help you is critical. with 180 posts, I'm sure you've seen the request more than once.

as a freebie, here's the CREATE...

times are now in the millisecond range:

2 rows selected it took 0.002 seconds. ...

not sure how you handle checking in on hte same day someone else checks out; if i leave on 05/07/2009, someone else presumably could check in on the same date,...

awesome that you posted the table structure and sample data; it made my creation of a possible solution and testing so easy. thank you!!!

The only way i see is you...

anthony when i tested, i was getting sub-second query times around 0.700 secs or so according to your page;

i guess we could help more if we saw the actual query...

ally this might get you started:

i made this script a long time ago for SQL 2000, so it does not take schemas into consideration;

it makes the following assumptions:

the PK of...

just syntax...there is no IF<condition>THEN<statement>, only IF <condition><statement>

IF EXISTS (SELECT DATEPART(hh, scheduledtime)

FROM intakesource_daily

...