Viewing 15 posts - 421 through 435 (of 1,419 total)
Back in the 200#'s I had my own home server with 2008R2 installed. It was a Dell box and I bought different disk drives, memory, and cards to experiment with...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
June 10, 2022 at 1:37 pm
One graceful solution could be for the vendor to address the issue they caused. Another graceful way could be to rewrite the application so the DB Engine manages locks and...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
June 10, 2022 at 10:55 am
Ok I updated the query so the ORDER BY is using the numeric 'wk_num' column instead of 'WeekNo' which is CHAR(3) and other slight changes too
with lead_cte...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
June 9, 2022 at 5:25 pm
You could fill in the missing weeks by using the LEAD(WeekNo) function to determine start/end points of the ranges. To expand rows across the ranges you could use the...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
June 9, 2022 at 3:51 pm
Yes it's just an encoding. How could one perform such an encoding without XML? That's the hijacked topic 🙂 As an aside: I associated the encoding with a conversion because...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
June 7, 2022 at 11:44 am
Something similar iiirc. As I recall HASHBYTES were applied too. It was to make offers which expired
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
June 6, 2022 at 11:28 pm
This concatenates (a bunch of guid's and an expiration date) together and encodes to binary base 64 and converts the result to nvarchar. The encoded token could be used in...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
June 6, 2022 at 9:58 pm
One area where it seems XML is required is for the conversion/encoding of strings to varbinary base 64. Altho if there's newer way I'd be interested to hear about it
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
June 6, 2022 at 8:00 pm
As frederico and Jeff have already explained the numeric value in the table has no display format of its own. If you're ok with a type conversion (from numeric to...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
June 5, 2022 at 11:52 am
'sysdate' is an Oracle function? Idk the syntax doesn't look like SQL Server
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
June 2, 2022 at 7:43 pm
A bit of a sidebar... I almost always avoid both EOMonth and anything else that is used to calculate the last day of the month because so many people...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
May 31, 2022 at 3:52 pm
Great information from ratback. I totally agree about staying within the larger segments as being a good strategy.
The chart I always come back to and track is db-engines.com. It attempts...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
May 31, 2022 at 3:10 pm
Here's a table valued function which takes as input a (2-part named: schema.name) stored procedure (as column type SYSNAME) and which produces a SQL script some of which could be...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
May 29, 2022 at 1:38 pm
I've heard of RedGate SQL Source Control, but would prefer to stay in the Microsoft cosmos....
Kind of an odd sentence. RedGate is in the greater Microsoft cosmos as their...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
May 29, 2022 at 11:58 am
Can't say anything without seeing the code
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
May 22, 2022 at 12:11 pm
Viewing 15 posts - 421 through 435 (of 1,419 total)