Thank you Phil,

The CSV file is out my control. It will be a growing file, yes but limited to few records once a month. It won't grow too big (not...

Thank you Jeff,

The target table is to be used for only one processing and won't be used by any other users at all. it's like a collection bucket.

That's why I...

Phil,

The python itself doesn't need any permission to run. It runs any script on my Windows authentication. (on terminal)

The python script acts like an envelope over the SQL, so that...

Hi Phil,

yes the Update works fine from Python.

When there are no errors, update completes with a commit.

When an error happens, even Rollback works but fails to send the mail.

Vin

Thanks frederico_fonseca.

That worked. I guess "and" clause is part of the left join (even after the brackets) and "where" clause is the final filter applied in the CTE join.

• This reply was modified 4 years, 6 months ago by  datsun.

Phil,

This one is good as it doesn't lock the table. I just tested a huge update on 30M records and while it's going on, the count using your method immediately...

Hi Phil,

This XMLA script seems to have worked for processing the Cubes. Both Last Updated and Last processed date were changed.

Although the process completed, the job history shows the number...

You can create an iTVF that will generate numbers on the fly

DesNorton,

Apologies for late response for this. But your function iTVF is perfect. Exactly what I needed. works for small...

To all with similar issue,

I resolved it finally.

1. From the Reporting Services Configuration manager change the Service account to Network Service. (it will ask for Backup key. Set one in...

...If you are using SSMS 18.2, there is a bug

Hi Sue,

Yes you are right. it was SSMS 18.2 which was driving me crazy with the wrong default language.

I installed 18.3...

Andrey

exec sp_helplanguage

The above is showing 34 languages langID from 0 to 33. 0 being us_english.

no. 23 is there as British (name) - British English (alias).

When I set language British to...

Many thanks Andrey

Some are showing English and some British.  I prefer to have "British English".

From the SSMS - login properties default language shows as "Arabic". British English is not listed...

Fredrico,

I think I resolved this using this way. Still need to test different sql calls using this method, but it seems to be working for my main call.

EXEC master.dbo.sp_addlinkedserver

David,

DOS/Windows commandline  'COPY' does the end of marker addition (SUB). which is then used in the Batch file.

Vinay

Thom,

It's all part of a big batch file. A zip file comes in from FTP, extracts it, copies it where SSIS filemanager reads it from and then the processing continues....