and if all this is within a transaction scope why not use a temp table - if created and used within the same transaction it will be available to all...

datetime DOES have a format on convert - and that is what is causing it to fail.

format 1 is US - so date string should be...

datetime DOES have a format on convert - and that is what is causing it to fail.

format 1 is US - so date string should be on format "mm/dd/yyyy"

for YYYY-MM-DD...

the truncate sp needs execute as owner.

the sp that calls it does not need to have "execute as owner" - only change you need to do on that one is...

either ALTER table or execute permissions on a proc that does the truncate like the following

create procedure TruncateMySchemaTable
with execute as owner
as truncate table schemaname.MyTable;

no. not the best way, neither the minimum access - its more like FULL access.

grant control on a table is a SUPER SET of permissions that include ALTER (which is...

• This reply was modified 5 years, 3 months ago by frederico_fonseca.

you may be right - issue here is that the process is backing up all databases and outputting all commands to log - and it shows truncated.

so backup would have...

if you go from Access to SQL and with 8 users you most likely will be able to work well with a 2 vcore and 8-10 GB ram - won't...

date(o.created_datetime)

change to

convert(date, o.created_datetime)

if(od.amended_quantity is not null, od.amended_quantity, od.quantity)

change to

case when od.amended_quantity is not null then od.amended_quantity else od.quantity end

regarding "and date(o.created_datetime) >= '2020-04-01'" - this should be changed as using...

attach that as an image or text and someone may be able to help - and do explain what you trying to do

try values instead of value

FacilityID - Decimal (12, 0) - takes 9 bytes - better to use a bigint - 8 bytes so I would look at this particular column to see...

thats all pretty and so on. but what tests did you do so far - and what was the performance difference between loading the data onto that table

...

look at this http://bilearninghub.blogspot.com/2018/05/format-date-in-ssis-mm-dd-yyyy-or.html

RIGHT("0" + (DT_STR,4,1252)DATEPART( "mm" , getdate() ), 2) +"-"+RIGHT("0" + (DT_STR,4,1252)DATEPART( "dd" , getdate() ), 2)+"-"+(DT_STR,4,1252)DATEPART( "yyyy" , getdate() )

as you are doing a bit of calculation...

• This reply was modified 5 years, 3 months ago by frederico_fonseca.

thats all pretty and so on. but what tests did you do so far - and what was the performance difference between loading the data onto that table

• table with...