It is not that it is not at all working, or there is not a syntax error, but my questions is this. What make this one return nothing

--Return nothing, not...

There are great tutorials in the SQL Books Online.

and it is free, and should already be loaded when you installed SQL Server.

Andrew SQLDBA

What I actually wanted was a query that counted some records that met a certain criteria, instead of just a count of all the rows. I was only keeping things...

The resultset will always be a single integer. This one is only performing a count or the rows

Thanks

Andrew SQLDBA

Thanks Dood

That one works perfectly.

I think that I failed to mention that the stored procedure does not have an Output param. I am sure that one can be added.

Thanks

Andrew

The SQL Books Online, I think is the best. And it is free.

Andrew SQLDBA

I would suggest that you not group by department or work type. But by size and the work load on the database. You do not want to over whelm one...

Create the temp database to the adequate size before use. Determine how large you need the Temp database to be, and then set the initial size to that, and set...

Cool

Thanx

Thanks, I hope this can help someone else also.

I will go back and read it again. Maybe i looked right over it

Andrew SQLDBA

Whoooops!

I forget the quotes around the date. But you get the jest of it. I know the date is supposed to have quotes.

Thanks Everyone. I will try your suggestions

Is that...

That is what I am saying....

Is Visual Studio or SQL Express already installed on that box? If so, then that is why SQL will want to install part of the...

Make certain that you select "Custom Install" as well. That way you modify the data location and the Binary location

Andrew SQLDBA

Is SQL express or Visual Studio already installed on the box? That is the only thing that I can think of that would cause some of the files to be...

How can you have a SQL 2008 database that is 3 years old? Uhmmmmm, SQL 2008 came out in...well, 2008 and it is only 2010, that is only 2 years.

Andrew...