Viewing 15 posts - 2,116 through 2,130 (of 13,838 total)
I think it's just a matter of adding this to the end of your query
ORDER BY SubQuery.department,SubQuery.myrank
I had assumed that the DENSE_RANK() was there for a reason! If your...
March 18, 2021 at 1:52 pm
Something like this?
WITH ranked
AS (SELECT te.department
,te.salary
,rnk =...
March 18, 2021 at 1:31 pm
OK, that looks like two instances on the same server. One called CONFLUENCE and one called EPO.
EPO looks active, CONFLUENCE not.
I recommend that you don't shut down the server until...
March 9, 2021 at 7:28 pm
Do you know how SQL Server is structured?
There is a thing called an 'instance' and the services associated with it (SQL Server, SQL Agent and others) run the instance.
Databases are...
March 9, 2021 at 6:57 pm
SQL Server Configuration Manager does not list databases, as far as I can see. So what do you mean by this:
The SQL Configuration Managers shows them as stopped
?
March 9, 2021 at 5:41 pm
Also test whether doing an outer join to the approved table and looking for nulls might be faster than the NOT IN.
Thanks, Grant. To be honest, I'd probably have...
March 9, 2021 at 2:55 pm
Apologises I was thinking that the rows you need to check might all be new or have been updated. As you said it won't pick up existing, unchanged, rows.
I...
March 9, 2021 at 1:11 pm
Is there anything obviously different about this report, when compared with other reports which are working OK?
March 9, 2021 at 11:17 am
Scott and as1981, thank you for taking the time to respond.
These responses at least suggest that I did not miss anything obvious.
Unless I have misunderstood, CDC does not achieve what...
March 9, 2021 at 10:13 am
MaryWard, this is a SQL Server forum. Moving data to Excel and processing it there is a really bad idea!
March 5, 2021 at 10:28 am
One problem I have seen before with SSIS and VCSs is that people sometimes make changes which affect the project file (eg, add or remove parameters, add or remove packages)...
March 4, 2021 at 2:12 pm
What makes you think that this is a TFS issue?
March 4, 2021 at 9:55 am
Thanks for the update and quick reply. I'll be sure to keep an eye on this thread. Looking for the same issue. Bumped into your thread. Thanks for creating...
March 3, 2021 at 3:18 pm
the only link is the CallID number
OK, that is enough.
March 2, 2021 at 6:39 pm
My previous 'yes' answer does depend on there being a link (eg, PersonId) between all of the rows which are associated. If there is no link between the different rows,...
March 2, 2021 at 6:34 pm
Viewing 15 posts - 2,116 through 2,130 (of 13,838 total)