That's what I thought. This kind of work is best done by the reporting tool, whether it be crystal, SSRS, or some other tool.

You've probably hit the tipping point on one of the server's resoruces to where things start getting exponentially worse. You may consider monitoring the box during the backup to...

Here's a great example. This includes a comprehensive log-shipping solution, but you can pull out the full backup/restore pieces. I've implemented this at a place that has not...

Why can't you use the data as-is in your stored procedure?

In that case, you'll want to go with a multi-statement table valued function. Check in BOL for details, but here's a quick example.

CREATE FUNCTION dbo.udf_functest(@ID int)

RETURNS @ReturnTable TABLE (TranID...

Have you tried CAST or CONVERT?

You don't need the table declaration section. The function itself is a table variable. Your function needs only to have the SELECT statement in it.

CREATE function...

Is there a question here?

No problem.

So you're talking TempDB, not memory? Yes, restarting the service will shrink your TempDB back to it's original size, but I would only do that if you are out...

Vika,

I just want to stress how important it is not to do anything that may use the original data drive until you've taken a shot at recovering the deleleted...

All DML statements must first load the appropriate data pages into memory so using a derived table should not have an abnormal effect to your query. It needs to...

Yep, that's it. I should emphasize the importance of setting ROWCOUNT back to 0 (unlimiited) because if you don't, SQL Server will use the limit that you've set for...

Please don't cross-post.

This thread is continued here:http://www.sqlservercentral.com/Forums/Topic564222-8-1.aspx

TOP does not allow for a variable value in SQL Server 2000.

You'll need to use SET ROWCOUNT:

declare @mytable table (zipcode varchar(10))

insert into @mytable

select '68144' union all

select '68132' union...