Viewing 15 posts - 1 through 15 (of 201 total)
thanks for input folks
the reporting isn't time critical down to seconds or even a few minutes behind but the budget for sql Ent probably wont exist right now, working of...
July 15, 2021 at 3:19 pm
yes sub reports i am having some luck with now (been really restricted in what i can do due to fixed datasources etc from an ERP)
just needed to take the...
June 28, 2021 at 3:59 pm
no unfortunately all i have access to is predefined data definitions from the software i am reporting on, it does not even allow me to see the code behind...
June 3, 2021 at 7:09 am
so the 31450 figure (now 213677) is possibly the total rows of data returned via the index?
June 3, 2021 at 7:04 am
yes i agree, would be much cleaner split into separate fields in sql, but i am working with a reporting solution that actually takes the address fields (all of...
June 2, 2021 at 7:37 am
cheers Eirkur! just testing some theory !
October 9, 2020 at 11:54 am
yes this works perfectly
i had quite a few columns so i basically wrote the result set into a table, scripted the table as a Create table and tagged the...
May 7, 2020 at 12:45 pm
thanks Eddie, pretty sure it will be fine with some work, just wanted to hear if the community had good/bad experiences
September 2, 2019 at 1:50 pm
ooops feel stupid now!
i had another stray sql task hidden from view also passing vales to the same varaible
apols, all fixed now 🙂
April 1, 2019 at 2:21 pm
apols i forgot to reply to close thread,
i got it working eventually, had to logon as local admin and reapply security etc and all is working again
January 24, 2019 at 6:19 am
nothing seems unusual when i query these
there must be some service/folder/database that i need to reapply the service account credentials to?
January 15, 2019 at 3:29 am
never even though sue!
and perfect i have found the culprit! a 3rd party has for some reason decided to run random sql log backups in the middle of...
April 26, 2018 at 8:10 am
no thats the thing, i am not missing any backups, no other backups are running
and strangely it will allow me to restore the last log file restored before...
April 26, 2018 at 7:23 am
hi Gilayea we are going straight to 2017 hopefully in later part of the year! be nice to read a new book for a change 🙂thanksmal
February 26, 2018 at 7:12 am
soon hopefully we will upgrade, and we can experience 10 year old Tech 🙂
February 26, 2018 at 6:28 am