Even without your data, let me give you an example. Say I have a table full of end-of-day stock prices, as well as the sector in which that stock resides....

Id be happy to if you can provide me some sample data, and expected results.

A group by can only contain the grouped columns or aggregates. If you change the column in the group by, you roll up at a different granularity. Since there...

EDIT: Removing these solutions. I think they just add confusion.

There's more than one way to skin this cat. Here's one:

if object_id('tempdb.dbo.#fileSize') is not null drop table #fileSize

create table #fileSize

(

database_id int,

space_used_in_mb...

For varchar and nvarchar, it's sufficient to take the datalength of the string and add two bytes for the offset block. For most every day purposes, you don't really need...

If you find yourself saying this in SQL, it's usually the wrong way.

Are the users executing these statements directly against the database? I would think if you're controlling access to these operations via a stored procedure, you could bake in the logic...

I'm not sure I follow. The first example allows you to do just that. You can define any sql you want and still insert it into the temp table defined...

if this is to perform cross database maintenance, powershell might be a better option (one which I'm altogether not familiar with). But what I was saying about the temp tables...

You could use a regular temp table as well, unless you need the temp table to be accessible from other SPIDs, in which case I'd recommend using a persisted table.

Or...

Lord I hope this is a joke.

thanks for the replies. I'm heading out for the evening so I haven't had a chance to read the articles yet but I will.

Jeff, to your question perhaps...

I dont know if this behaves any different from parseonly but...

set noexec on

select 1

set noexec off

Edit I don't think this would gain you anything over parseonly. The only difference I...

Alexander Suprun (12/22/2014)

---

sqlvogel (12/22/2014)

---

No, a "record number" / surrogate key is not necessary in all cases. Adding such a column to every table offers no general advantage in terms of...