In most DBMSs, a GROUP BY is a more efficient way to eliminate duplicate rows compared with the DISTINCT keyword. The reason for this is that a GROUP BY invokes...

Using without an aggregate causes the resultset to behave like DISTINCT, and is faster.

You're welcome.

(sum of DATALENGTH for all columns) multiplied with the number of rows gives a rough estimate of the amount of data sent.

Nice. Well done!

I was so focused on producing the groups, I didn't see the obvious.

yes, that is doable.

First you must create some kind of a lookup table where every attachment (path & filename) is stored with an ID.

Second, create another lookup table where you match each...

Maybe parsing the query and searching for "FROM " / "UPDATE " / "INSERT INTO " / "INSERT " text, and then a space after that, should give a table...

True. I didn't really think...

WHILE EXIST (SELECT * FROM Account WITH (NOLOCK) WHERE ProviderID = 70 AND IsActive = 0 AND Status <> 'Deleted')

   UPDATE  Listing

   SET     Status...

Have you tried

 SET @x = @@rowcount 

PRINT @x

 SET @cnt = @cnt + @x

to see what @x gives?

Otherwise

WHILE EXIST (SELECT * FROM Account WITH (NOLOCK) WHERE ProviderID = 70 AND IsActive...

Or do you simple want this?

-- Populate test data

declare @t table (prog varchar(8), cost float)

insert @t

select 'Prog A', 32.600187121827403 union all

select 'Prog B',...

There are three 77.358114112521619

I ask you the same question again, how would you like ties (same numbers) to be ranked?

How do you differentiate between equal numbers?

Something like this?

In this example, IDs must be consecutive, otherwise just create a table variable with ID as IDENTITY and insert into that table first, ordered by...

-- Populate test data

declare @t table (aDate datetime, otherdata varchar(50))

insert @t

select '2006-01-01', 'a' union all

select '2006-01-15', 'b' union all

select '2006-02-01', 'c' union all

select '2006-02-02', 'd' union all

select '2006-02-03', 'e'

-- Do the work efficient

select...

Is this same group

11 2004-05-13 16:54:58.000           C

12 2004-05-18 12:29:42.000           C

13 2004-05-18 12:29:43.000           C

Even if date has changed?

Could you...

-- Populate test date

declare @t table (prog varchar(8), cost int)

insert @t

select 'Prog-A', 16000 union all

select 'Prog-B' ,16000 union all

select 'Prog-C', 21000 union all

select...