Viewing 15 posts - 1,291 through 1,305 (of 1,415 total)
How often do you add documents/nodes to this hierarchy?
According to the OP there are approximately 25k rows in the table. If this represents 5 years of activity, then...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
October 27, 2019 at 1:09 pm
At one point I looked into this because we got called into one of those "we want to slap a UI on our database" jobs. Thankfully it didn't go anywhere. ...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
October 25, 2019 at 1:12 pm
The alternate solutions don't factor in all of the constraints. Also, both assume the apparent ordinality of dates/ranges will be valid while the OP has offered no assurances that's the...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
October 23, 2019 at 5:19 pm
By 'base64' column you must mean varbinary(max)? I've never done it with a pdf file before but if it is possible in t-Sql then OPENROWSET would be my guess as...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
October 23, 2019 at 4:04 pm
I can't test it (don't have the table) and all of your column names are reserved words so here's a swag at it:
with range_cte(ID) as (
select
...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
October 22, 2019 at 8:54 pm
Why not just create a primary key in table A?
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
October 22, 2019 at 8:25 pm
If 'jsonpayload' is valid JSON it could be updated in place. Using Sql 2016+ something like this (copy, paste, run) could work:
/* create a test table with...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
October 19, 2019 at 1:29 pm
Is there a business definition that defines an "error" or is the error table only supposed to contain errors generated by sql? Please post the definition of the student table...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
October 16, 2019 at 2:03 pm
I wasn't taking into consideration the Convert.To/FromBase64 calls that are used with the decryption method, so I wasnt converting to or from Base64 when i was performing the substring,...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
October 16, 2019 at 3:46 am
..., then store the decrypted value(s) into a MySQL database. My task is now to get said Data onto our Reporting SQL Server and store as decrypted.
The MySQL is...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
October 15, 2019 at 10:52 pm
Could you provide the definitions for the tables that you reference? Is there an integer identity primary key on id in the student table?
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
October 11, 2019 at 10:55 pm
Here's a tvf named 'left_chars' that attempts to generalize all of the requirements. Sorry I'm learning about APPLY (new hammer) so everything looks like a nail. The function should work...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
October 10, 2019 at 1:54 pm
If the dollar values are randomly distributed across rows then any sample (of sufficient size, about 35 for reasonable precision and confidence) should have an average $/cust that's close to...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
October 8, 2019 at 6:18 pm
It would be similar to what was posted except using your calendar table instead of the daterange function. Eomonth can't be used either because it's Sql 2016+.
Something like this:
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
October 8, 2019 at 2:28 pm
Yea yea, I know or I noticed after I posted that. Instead of eomonth() you could use:
dateadd(day,-1,dateadd(month,1,@test_month))
Then you could use a tally table and dateadd function. Or...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
October 8, 2019 at 2:01 pm
Viewing 15 posts - 1,291 through 1,305 (of 1,415 total)