Cheers Grant

Testing appears to be working, so I'm going for it. Just wondered if anyone else had tried.

I may ask a loaded question at one of your SQL Bits sessions...

@Frederico...

• This reply was modified 4 years, 3 months ago by  peter.cox.
• This reply was modified 4 years, 3 months ago by  peter.cox.

I would - but I'm slightly wary of preceding if there is a known issue....I'm always wary of Microsoft's encryption on SSRS, and I just cannot find anything on this...

Thanks

unfortunately, we are where we are, and we need to change the existing password
Will changing the SSIS password lead to encryption errors? Does anyone know? Or is...

ooh and you have it straight away. From here

This is the most common port allowed through the firewall. It applies to routine connections to the default installation of...

Sorry! Been ages.

It was just a business requirement to search a free form field. Obviously with that being the case, people have the ability to put the data in any...

Oh i will.

NO LOCK features heavily throughout the procedure. Shouldn't really be an issue (as it runs at 1am normally), but better safe than sorry

sorry for the delay in replying.

on the Friday morning we had the same issue; so the first wednesday of the month was a red herring.

On checking there was nothing that...

funnily enough, last night I came up with a function. I shall compare the two, but many thanks

GO

/****** Object: UserDefinedFunction [dbo].[split_test] Script Date: 28/06/2014 07:57:00 ******/

SET...

but I need it any order, not just the order it came in, or the reverse, but any combination.

and the variable could be up to say six words

nope - the Cube is on another box

As to the whole Julian malarky - it's a pain, but entire system is set up like that. The fact the SP normally...

Also,the two indexes on the table are dropped at the start of the SP, and recreated in a further step.

It gets past the drop index, and truncate easily (we...

The function - as I'm sure you're going to ask, is solely

Select @Result=

Case When @JulianDateToConvert <> 0

THEN

dateadd(dd,right(@JulianDateToConvert,3)-1,0)

+dateadd(yy,left(@JulianDateToConvert,

case

when len(@JulianDateToConvert)=5

then 2

else 3

end

)+0,0)

ELSE NULL

END

I have wondered about this function, and whether that's the...

here you go; fairly anonymised

INSERT INTO dbo.tblSales2

(

duedate

,gldate

,invoicedate

,PaidStatus

,OverdueStatus

,Days

,OverdueAmount

,InvoiceDate

,DueDate

,PaiementDate

,GLDate

,PayStatus

,DocCompany

,OrgID

,OrganisationDesc1

,HyperionCode

,AddressNum

,AddressBookSearchType

,CustomerID

,JDECustDesc

,EDBCustDesc

,DocNumber

,Doctype

,PayItem

,PayItemNumber

,PayItemDocType

,GrossAmount

,openamount

,TaxableAmount

,NonTaxableAmount

,Tax

,RPCRCDCurrencyCode

,CurrencyID

,MonthXRate

,ConstantXrate

,OpenAmountUSDMonthRateValue

,OpenAmountUSDConstantRateValue

,BankAccount

,ObjectAccount

,Subsidiary

,DateOfLastSentReminder

,InvoiceNumber

,remark

,NoOfPayments

,AlphaName

,ItemNumberShort

,LastUpdatedBy

,DateTimeLastUpdated

,Deleted

)

SELECT

F.duedate

,F.gldate

,F.invoicedate

,CASE

WHEN F.openamount <> 0 THEN 'Not yet Paid'

ELSE 'Paid'

END AS PaidStatus

,CASE

WHEN openamount <> 0 AND duedate < @TodayinJulian THEN 'Overdue'

ELSE (

CASE

WHEN openamount = 0...

funnily enough i've had both

option (OPTIMIZE FOR (@StartDate UNKNOWN, @todayinJulian UNKNOWN),MAXDOP 12)

and

option (RECOMPILE,MAXDOP 12)

on there (not at the same time, obv). It happened no matter what.

sorry Gail...

It hangs on a select into, but the step itself truncates a table, then selects data and put it back into the table.

Run the statement separately, it runs fine.

It's...