Viewing 15 posts - 61 through 75 (of 5,502 total)
For a quick overview you could use the Standard Reports from SSMS
Right click on a database -> Reports -> Standard Reports -> Disc Usage by Tables
August 31, 2014 at 7:25 am
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...
August 31, 2014 at 6:51 am
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...
August 31, 2014 at 5:56 am
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...
August 31, 2014 at 3:50 am
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...
August 31, 2014 at 3:33 am
Lynn Pettis (8/30/2014)
...Page 1 is now ALL spam.
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......
August 30, 2014 at 4:28 pm
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...
August 24, 2014 at 12:38 pm
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...
August 24, 2014 at 9:12 am
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...
August 24, 2014 at 5:32 am
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)....
August 24, 2014 at 3:59 am
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)...
August 24, 2014 at 3:55 am
please don't cross post. Original post: link
August 24, 2014 at 3:31 am
farhana.sethi (8/24/2014)
It worked for me. I sorted out by myself. ...
Care to share your solution so others may benefit?
August 24, 2014 at 3:27 am
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...
August 24, 2014 at 3:05 am
this is not working for some reason
doesn't include any details what the issue might be.
Is there any error message?
August 24, 2014 at 3:02 am
Viewing 15 posts - 61 through 75 (of 5,502 total)