Hi

What about the Resource Governor on Prod?

Imho this feature can limit the amount of CPU and memory consumption if implemented, but

this is only small advice.

Br.

Mike

Very good question Hugo, but I'm still not sure that "Nolock CAN NOT cause the query to not return committed rows" is the wrong answer.

Could anybody clarify me this point...

Hi Almighty

Please change the package protection level to EncryptSensitiveWithPassword.

Br.

Mike

Hi

A bit different version:

WITH dates AS (SELECT EntryDte FROM #tmpChgs UNION SELECT

EntryDte FROM #tmpPmts UNION SELECT

EntryDte FROM #tmpAdj)

SELECTd.EntryDte

,ISNULL(c.Charges,0)AS Charges

,ISNULL(b.Payments,0)AS Payments

,ISNULL(a.Adjusts,0)AS Adjusts

FROM dates AS d LEFT OUTER JOIN...

Carl, they smell the Friday. 😀

Stu, very good question.

Thanks

Mike

I developed simlar project a few years ago. It exports invoices to the flat file in specified order:

Invoice 1

Invoice header

Item lines

Subtotal netto

Subtotal by VAT

Total

Footer

...

Invoice n

Invoice header

Item lines

Subtotal netto

Subtotal...

Easy one. It seems Steve didn't try to kill us on Friday. 😀

My first thought - 1 row and why the hell there's no such answer, and then

slow down, review carefully all available. 😎

Thanks Eirikur

Hi David

Small example for current date:

=FormatDateTime(IIf(DatePart(DateInterval.Weekday,DateAdd(DateInterval.Day,-(Day(Now())),DateAdd(DateInterval.Month,1,Now()))) = 7,DateAdd(DateInterval.Day,-(Day(Now())+1),DateAdd(DateInterval.Month,1,Now())),DateAdd(DateInterval.Day,-(Day(Now())+1),IIf(DatePart(DateInterval.Weekday,DateAdd(DateInterval.Day,-(Day(Now())),DateAdd(DateInterval.Month,1,Now()))) = 1,DateAdd(DateInterval.Day,-(Day(Now())+1),DateAdd(DateInterval.Month,1,Now())),DateAdd(DateInterval.Day,-(Day(Now())+2),DateAdd(DateInterval.Month,1,Now()))))),DateFormat.ShortDate)

But it doesn't check Church & Civic Holidays, personally I prefer scalar function to find it.

Best regards

Mike

Ps. Sunday specified as the...

Nice 😉 Welcome to Cartesian join.

Thanks

Hi

Forgive me, I'm very busy today and the first impulse that comes to mind:

//string Month = ls[5];

string m = ls[5];

//month name to int

int NoM = DateTime.Parse("1." + m + "...

Mishra

You probably didn't remove spaces between myid and mytext in row "2 Azure SQL Database is very useful for some...

Hmm, I'm a little bit surprised the explanation.

Hi

I'm glad to see you find your own workaround of problem, but please think about error handling

to this task. Sometimes the name of file can be totally screw...

Hi

You can use LastIndexOf() method to find the position of last "_" character in string,

try in such way:

//char to find

String UndSc = "_";

// (3 + 2) month & year...