Are you sure that the service is started?

Hwo do you know you are even connected to the server?

What's the query you are trying to run?

DECLARE @sql AS nVARCHAR(4000)

SET @sql = 'SELECT WHATEVER FROM ' + @ObjectName

EXEC (@SQL)

You can't do that... and it's really not a good idea to even try to!

What do you need to be able to do exactly?

Or another solution, just for the kicks of it.

Select valid data into newtable

truncate oldtable

drop old table

rename new table

you can change the drop rename by and insert if you want to...

You cannot use the alias name of the column untill the order by clause... or untill the whole query becomes a derived table.

You'll have to rewrite the query to use...

This one : .

.

What's the url??

How would that return a dataset instead of a varchar(?)?

BTW, you'll need to use >= AND then < (because the 2nd date is at midnight so you'll want to filter that out).

This should do it (yesterday, tomorrow).

DATEADD(D, -1, DATEDIFF(D, 0, GetDate()))

AND

DATEADD(D, +1, DATEDIFF(D, 0, GetDate()))

More details on what I'd like to offer : starting from any of these identities (single entity, single id) :

Technicians

Bills of work

Bills (to be paid by our clients)

Contracts

Inventory

Orders for inventory

Clients

go to...

SELECT Main.* FROM dbo.Table Main INNER JOIN (SELECT DateCol, Max(Qty) AS mQty FROM dbo.Table GROUP BY DateCol) dtMRD ON Main.DateCol = dtMRD.DateCol AND Main.Qty = dtMRD.mQty

I totally see your point about reusability.  But here's why I think it's completely off topic :

When I decide to pass a long list of ids, I do so...

I think he meant 500 MB.

But I'd like to see a tempdb of 500 GB someday .