Viewing 15 posts - 916 through 930 (of 1,413 total)
Thank you, Steve
Sadly none of your examples works for me from the Studio - getting various error messages.
The code probably worked just fine for Steve. When you get...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 15, 2020 at 12:12 pm
Maybe you do not have an fnTally function? If so that's easily remedied. Have a look at this thread. What are the specific messages?
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 14, 2020 at 10:12 pm
Here's for six letters. It returns Bertha. To do for five letters would follow a similar pattern.
DECLARE @six_letters NVARCHAR(MAX) = 'hurrah, buzzed, Bertha, patter, mettle, holler, collie,...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 14, 2020 at 9:37 pm
DECLARE @six_letters NVARCHAR(MAX) = 'hurrah, buzzed, Bertha, patter, mettle, holler, collie, yuppie, rabble, tallow, brooks, tassel, meddle, callus, peddle, sobbed, kneels, getter, brooms, dulled, maggot, webbed' ...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 14, 2020 at 2:52 pm
Maybe have a look at this other thread where something similar was discussed.
https://www.sqlservercentral.com/forums/topic/ignoring-error-and-continue/page/2/#post-3765149
Not the connecting using openrowset but the loop and the error and continue
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 13, 2020 at 3:47 pm
For the road I have a small-form-factor laptop that fits nicely on an airline tray table.
That's what I should've done. My Asus laptop with a 17" screen weighs like...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 13, 2020 at 3:33 pm
You should write an article on it and submit it.
...I'll submit something.
Since this was written I've been on this trying to make it happen. Wow, 3 months ago...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 13, 2020 at 1:33 pm
What I dislike about PIVOT is that you have to repeat UNIONs several times depending on the metric. This makes it difficult to change and error-prone as you may...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 12, 2020 at 2:06 pm
Frank's answer above removes the reference to the CODE_CHARGECREDIT table and removes c.PEOPLE_ORG_ID (which is non-existent) from the GROUP BY. Idk if that makes sense. Fixing the (many) errors and...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 11, 2020 at 12:00 pm
Horses for courses and everybody thinks their way is the best. Why not have a sense of humor about it? I agree Pivot and Unpivot are kludge compared to conditional...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 10, 2020 at 7:20 pm
Here's a simple CASE, what wouldn't this take embedded IIFs?
Idk why don't you give it a try and let us know
... since I write SQL now not a...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 10, 2020 at 2:59 pm
Ha I think's the other way around. CASE WHEN is an abomination of over wordiness that never should've been created. First, back in the day you used to have to...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 10, 2020 at 2:22 pm
Imo IIF gets hated on because it was available first in MS Access. IIF gets interpreted back to "CASE WHEN" so it's really the same (which is a shame because...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 10, 2020 at 11:55 am
It also works without the tally table and just using CROSS APPLY
select
po.ProductCategory, po.ProductSubCategory, v.Region, v.OrdersPlaced,
(v.OrdersPlaced*100.0/SUM(v.OrdersPlaced) over (partition by po.ProductCategory)) PercentPlaced
from #po po
...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 8, 2020 at 10:48 pm
Why not just UNPIVOT, as shown here in a CTE:
Both work. The tally based is probably more efficient depending on scale. It didn't occur to use a tally table...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 7, 2020 at 5:13 pm
Viewing 15 posts - 916 through 930 (of 1,413 total)