For a quick overview you could use the Standard Reports from SSMS

Right click on a database -> Reports -> Standard Reports -> Disc Usage by Tables

I'm sorry, my mistake.... (maybe due to the missing table def and sample data...)

select postalcode, count(parcels) as Cnt, ROW_NUMBER() OVER(ORDER BY count(parcels) DESC ) as Ranking

from TableParcel

group by postalcode

order by...

Without knowing what "earlier versions" refer to here's a solution using ROW_NUMBER

select postalcode, count(parcels) as Cnt, ROW_NUMBER() OVER(PARTITION BY postalcode ORDER BY count(parcels) DESC ) as Ranking

from TableParcel

group by postalcode

order...

Like I wrote before: not enough information.

There are several ways to provide a unique billing number using SQL Server.

Either a table with pre-generated numbers where a used number is marked...

Not enough information.

What system provides the billing number in the first place?

If an app would request a billing number from SQL Server, it could be guaranteed that there'll never be...

Steve wrote a couple of days ago that developers will have a look at it.

I truly hope that's not the result of it......

I'm not sure what you referred to regarding " issue it may cause".

So let's talk about all aspects:

1) WHERE DATEPART(MM, SR.SalaryDate) = DATEPART(MM, @Process_Date) without a check for a matching...

From my point of view there's a risk to get unwanted results from the previous year since there's only a comparison against the month value.

Speaking of it: applying a function...

What permission does the user have who's running that code?

Based on MS Technet

Only members of the sysadmin fixed server role can execute sp_OASetProperty.

If you're not a member of the sysadmin...

see my previous reply using a loop.

as a side note: it would be very helpful if you wouldn't flood all forums with your very same question (= numerous duplicate posts)....

Here's a solution based on the "Groups'n'Islands" concept:

WITH cte AS

(

select *,

ROW_NUMBER() OVER (ORDER BY point_of_time)-ROW_NUMBER() OVER (PARTITION BY name ORDER BY point_of_time) as NameGrp

from #test

),

cte_grp as

(

SELECT

min(name)...

please don't cross post. Original post: link

Care to share your solution so others may benefit?

This is one of the rare scenarios where you'll have to use a loop and iterate through every distinct user.

Assign the mail addresse to a separate variable (e.g. @userMail) and...

doesn't include any details what the issue might be.

Is there any error message?