just use straight convert with the correct destination type (e.g. no VARCHAR without specifying a size - bad practice!!) and with the correct format - no need for substring either.

If you don't need the end user connecting as themselves, you could have it connect as a specific user on the remote machine.  Downside is you may need to...

Instantaneous transaction rollback

With...

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

please stop posting the same question on different threads - you have already 4 or 5 on same subject.

keep this on https://www.sqlservercentral.com/forums/topic/inline-table

error message does tell you what to do -

• create a staging table with same structure of the main table, with all required constraints/indexed
• do a partition switch from the...

not enough information to tell you what is the correct way to do for your particular query but the following should point you on the right direction.

select...

sql playing dumb on this case

if your software can be set to do other types of joins/cross applies or even to, as you said, generate the isnull (which works on...

on the server itself (or through xp_cmdshell on that sql instance) execute

tnsping tableau

if the server is names like that you will get an output with the ip/hostname of the server...

very few items from a SQL coding perspective are not available on standard since 2016 SP1 - before yes it was a problem, nowadays not so much unless you are...

and how many cpu/cores/numa nodes does that machine have?

from a functionality point of view they are exactly the same.

its just licensing that is different - install is also same just different license key which determines how cpu/core is...

CAST(SUM(p.QTY * 1.0) / SUM (r.QTY) AS decimal (5,2)) AS 'Forecast Accuracy'

by "forcing" one of the operators to be a decimal the results is now a decimal.

no

what you need to do is not add them to any role that allows data changes (or ddl changes) - e.g. do not add them to db_datawritter or db_ddladmin -...

first step is to change the owner of the database to be either a lowlevel SQL Login created just for that or to SA

ALTER AUTHORIZATION ON database::testdb TO DisabledLogin;

then create...

if the index is partitioned then yes.

alter index indexname on tablename rebuild partition = 3 ...