but your @student table does not allow nulls for the lunch; that is the constraint failure;:

,LunchPeriod INT DEFAULT(4) ...

i think i had to change my data; you had one class with a null lunch:

SELECT '10-B', NULL

which i changed so it would work; i was kind of assuming...

000, 052, 020, <--those are not numbers. 0 is zero, there are no preceeding digits for real number types like integers, so you are right, you'd want to consider a...

ahh...exactly my point... a view never needs to be updated. you might think of it as self-updating.

technically, it is a saved query, that is run on demand.

if you run it...

how about selecting from the @Class table?

INSERT INTO @Student(FirstName, LastName, ClassID, LunchPeriod)

SELECT 'John', 'Smith', @ClassID, isnull(@LunchPeriod,LunchPeriod) from @Class where ClassId = @ClassID

yes it does; at a minimum, i followed your steps and got a shared lock on the table; you can check it yourself by doing as you described, and then...

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...