Viewing 15 posts - 61 through 75 (of 153 total)
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...
November 27, 2019 at 5:15 pm
Found my solution 🙂
September 16, 2019 at 1:57 pm
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?
September 12, 2019 at 12:49 am
thank you all, with the info you gave me, i was able to use the queries and get it right 🙂
August 1, 2019 at 5:09 pm
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...
July 11, 2019 at 5:52 pm
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...
December 21, 2018 at 1:53 pm
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...
December 3, 2018 at 10:10 am
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...
November 19, 2018 at 1:53 pm
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...
November 19, 2018 at 8:53 am
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...
November 9, 2018 at 12:51 pm
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....
November 9, 2018 at 12:13 pm
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 ...
July 10, 2018 at 3:09 pm
Hello sgmunson,
thanks for getting back to me,
i am doing this to help eliminate duplicate rows when i join it back to another table, which the table is...
June 19, 2018 at 10:48 am
ahh that would help right saravanatn lol, sorry
the output i...
April 21, 2018 at 11:54 pm
Sorry John, but big thanks for answering the question, it worked perfectly 🙂
April 21, 2018 at 9:36 pm
Viewing 15 posts - 61 through 75 (of 153 total)