Viewing 15 posts - 706 through 720 (of 9,725 total)
I think it would be nice to archive off the older SQL version forums so the threads are still available even if the posting ability is not.
I...
May 25, 2018 at 7:39 am
Hola, Fellow Threadzians.
As I push my head above dense project waters to grab a breath of fresh air, I was wondering if anyone would care to assist me...
May 23, 2018 at 12:42 pm
I probably shouldn't have used the word "upgraded." I did get a new box entirely, fresh install of the OS.
Sorry for the length of time to respond to...
May 15, 2018 at 12:46 pm
March 15, 2018 at 4:57 am
February 26, 2018 at 11:19 am
The worst part about it is the people who were developing this code kept insisting on turning SQL tables into flat files and doing stupid stuff like that, no matter...
February 23, 2018 at 10:55 am
Thanks, Drew. I was working on that, but changing different items in the CASE. I'll take a look at that and see how it works.
February 13, 2018 at 5:12 am
February 12, 2018 at 12:27 pm
February 12, 2018 at 12:16 pm
BAH. I thought I was through with this, but I just found an outlier.
When testing with the this data:
INSERT INTO #MyTemp (Office, POID, DeliverySite,...
February 12, 2018 at 11:46 am
Drew, thank you so very much. I'd never heard of LAG() or the ROWS UNBOUNDED PRECEDING stuff until now. I love this job because I learn new things every day.
February 10, 2018 at 1:29 pm
February 10, 2018 at 6:52 am
January 23, 2018 at 3:40 pm
Had to fiddle with your code, Drew. It didn't take into account multiple Address codes on a single invoice. Then again, neither did my sample data because I didn't see...
January 23, 2018 at 1:20 pm
Almost 3 hours later and the CTE is still trying to run. I'm going to yank it out, run the code for PayDate = LastAccountDate, then do an update for...
January 23, 2018 at 11:32 am
Viewing 15 posts - 706 through 720 (of 9,725 total)