Viewing 15 posts - 2,191 through 2,205 (of 59,066 total)
What SQL did you use to solve it?
Ah... sorry. Like I said, I used the "Quirky Update" method, which allows variables to interplay with columns as each row passes,...
December 26, 2022 at 4:43 pm
It sounds like the dynamic technique of using a CROSSTAB would fit the bill here. Have a look at the following article as an introduction and let me know...
December 25, 2022 at 6:24 am
Yes and the Value field is varchar(02), it needs to hold "1", "2", or "NA".
It would save 2/3rds of the memory required if it could be a...
December 25, 2022 at 1:42 am
Heh... Edge. Take a look at Task Manager when that puppy is open with even just 1 window.
December 25, 2022 at 1:29 am
Damn forum software ate my response due to paging... hopefully, this post will make it appear.
Yep... that did the trick.
December 24, 2022 at 10:35 pm
Yes and the Value field is varchar(02), it needs to hold "1", "2", or "NA".
It would save 2/3rds of the memory required if it could be a numeric 0,...
December 24, 2022 at 10:27 pm
Sorry, you're right.
This is what the "base table" I have looks like.

There will be over 2 million IDs and each ID will have the same exact...
December 24, 2022 at 9:42 pm
I mean I can on my last day and my last minute of my contract..........lol
😀 I'm just curious why the customer says they need this? This could be done...
December 23, 2022 at 9:51 pm
It does work as the trailing space is ignored. That being said, I'll edit the question as no one should be confused by this. I'll also look to PR...
December 23, 2022 at 8:04 pm
BTW... the documentation for the subject of "trailing blanks" NOT being included in comparisons is a bit difficult to find. You would think that MS would have included...
December 23, 2022 at 8:03 pm
smells like the usual lambda spam of "i got this" with a link
Most probably but I couldn't resist the temptation to rant about the cloud a bit myself. 😉
December 23, 2022 at 7:55 pm
The values are what I will populate with various updates but after that I need to pivot it out.
.
.
.
This is a requirement per the customer.
To be honest, I'd tell...
December 23, 2022 at 7:52 pm
Rant understood and much appreciated. The cloud has many advantages but I still refer to it as "Smoke'n'Mirrors" for this very reason. There's also a huge chance that scaling out...
December 23, 2022 at 5:23 pm
Just for fun, -40 degrees is where the Celsius and Fahrenheit scales cross.
December 23, 2022 at 5:10 pm
BTW... the documentation for the subject of "trailing blanks" NOT being included in comparisons is a bit difficult to find. You would think that MS would have included it in...
December 23, 2022 at 4:30 pm
Viewing 15 posts - 2,191 through 2,205 (of 59,066 total)