Viewing 15 posts - 2,116 through 2,130 (of 4,820 total)
October 4, 2017 at 6:44 am
rmcfaden - Tuesday, October 3, 2017 4:25 PMIs it a memory hog?
Would just a decimal(10,5) be better?
Jeff's not concerned about memory here,...
October 4, 2017 at 6:13 am
October 4, 2017 at 6:04 am
Try this on for size:SELECT DISTINCT D.Id, D.Nbr, D.Unit_Total, D.Type_Code, D.Serv_Code, D.Pro_Code, D.Pro_Mod,
(
SELECT CONVERT(money, SUM(C.paid_amt))
FROM PAYMENT AS C --142,623,313 records in Payment
WHERE C.Source_Code = 'FTE'
ND...
October 3, 2017 at 3:13 pm
October 3, 2017 at 3:02 pm
And there's no possible way to sync two such nightmares into a single table. It simply cannot be done.
October 3, 2017 at 2:54 pm
Without the addition of some kind of unique key to such a table, you are correct. You would be far better served by finding out whether or not duplicate records...
October 3, 2017 at 2:51 pm
Could anyone help fixing below error? I can see this error in SQL...
October 3, 2017 at 2:25 pm
If the column data is compressed, then it has to be uncompressed before SSRS can understand the data in that column. How did the data get compressed?
October 3, 2017 at 2:20 pm
@bartedgerton-2, no recursive self joins - it might have been easier if there were...
October 3, 2017 at 1:37 pm
October 3, 2017 at 1:20 pm
October 3, 2017 at 1:12 pm
Viewing 15 posts - 2,116 through 2,130 (of 4,820 total)