Awesome thank you Sue_H, one last question, in your experience, has CDC had overhead on the SQL server, of course it would depend on how many databases/tables and data size...

I did find this article:

https://www.sqlshack.com/sql-server-always-on-availability-group-log-backup-on-secondary-replicas/

I made sure the backups are set on the secondary, also on the Always on AG group, in properties, i set backup preferences to "Prefer SEcondary"...

Great thank you Jeffrey for the info, very informative 🙂

thanks Mike for the info, the brief background was poor written store procedures that made many many unnecessary tempdb but after finally reviewing it, i made some changes, tested and...

Found my solution 🙂

https://stackoverflow.com/questions/19775451/ssrs-how-to-repeat-the-table-header-on-each-page-in-print-preview

Thank you sue I will try that, I have the terms and cons on 1 table seperate from the actual invoice... Will that work for the method you suggested?

thank you all, with the info you gave me, i was able to use the queries and get it right 🙂

Found the problem, the table is HUUUUUUGE, just 1 table, and they were trying to query the data from there client PC, guess this is what happens when you let...

Hey Steve, 

thanks for your reply, no these are different machines, and i made sure the firewall is allowing the default SQL port open to both servers only. Browser...

Hey Jeff,

thanks for the LAG function, it does seem to work for the first and second row, however when it gets 2 the 3rd and 4th etc., it...

thank you @Taps, i tried to switch it from SQL server 2016 to 2014... didn't work, still same error, then i tried to switch it back to 2016, still same...

good morning, thank you Fred for the input, i did try to apply, but the hotfix says it doesnt apply to the server, plus i have SP2 on SQL and...

thank you all for your replies, i know, why would they have a column null especially when it needs to be joined on... again bad table architecture, but i am...

any info will help thanks Lynn, but what can i do to get around this :(, have you faced something like this? i hope maybe there is something out there....

awesome big thanks Lynn,

one last thing, i am really sorry, is there a way to do this:

ID PersonName Order  Purchase order
1         Bob ...