not much you can do on this except remove the sort.

plan here https://www.brentozar.com/pastetheplan/?id=BJrAKS0RD

SELECT [DocumentCategory].[CategoryID] AS [CategoryID]
     , [DocumentCategory].[ProcessEvents] AS [ProcessEvents]
  ...

• This reply was modified 4 years, 10 months ago by frederico_fonseca.

stop mixing questions - you asked for something that was answered - thats it.

your last post is a completely different question - so raise a new thread for it.

But before...

if there is a FK column on that column and the column is not null(not sure if this one required) then if no column is retrieved from the other table...

regarding using "PKWare SecureZip" - this is a commercial software - I suggest you also look at 7zip - quite good and free.

all remaining comments above apply.

kind of you can.

https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-server-permissions-transact-sql?view=sql-server-ver15

• View any database
• connect any database
• view any definition
• select all user securables

you can do it - but not easy.

option 1 - Sharepoint Excel Services - https://docs.microsoft.com/en-us/sharepoint/dev/general-development/excel-services-overview 

option 2 - use OpenXML https://github.com/OfficeDev/Open-XML-SDK - C# code - better as an independent...

Hello everyone,

I am currently looking for a way to create Excel reports that include formulae (probably also Pivot tables and other stuff) from Reporting Services. Searching the web...

try

,convert(decimal(38, 2), case when f.HAI ='A' then (isnull(f.NUM,0)/f.DEN) *10000
                  ...

add required indexes - and see why the table does not have any at all - including a clustered index as that is normally, although not always, a good idea

I assume you are running that query and outputting onto a table so you can compare changes between runs - those are cumulative values since last instance startup - having...

out of the normal but in a particular application from one of my clients sequences always started at 1000.

And on a similar situation, multi-tenant, each tenant would start at 1.000.000...

Hi,

Had not seen it when I hit the send button.

your code works for most - not all cases.

see these two examples

 create view dbo.myview5
/* view name dbo.myview
--*/as
...

you didn't specify where you will be getting the text for the views - that may also change how you process it.

but take the following examples in consideration - they...

darn forum security - not even allowing to add a file with .7z if not a proper zip file

• This reply was modified 4 years, 10 months ago by frederico_fonseca.
• This reply was modified 4 years, 10 months ago by frederico_fonseca.

error is quite clear

Error converting data type nvarchar to datetime.

what you need to do is to look at which field is being converted from a nvarchar/varchar to...