Viewing 15 posts - 241 through 255 (of 607 total)
Jeremiah Peschka has an option https://facility9.com/2010/02/rounding-to-the-nearest-x-minutes-the-lazy-way/
May 21, 2019 at 2:29 pm
This isn't right, and you'll want to convert to a function that takes in your punches and test it thoroughly, but it's the time I have at the moment. You...
April 24, 2019 at 4:08 pm
The consent rule is also problematic. If you're travelling and become sick or injured, perhaps unconscious, how would that data be accessed quickly enough?
if you are unconscious they aren't...
April 22, 2019 at 6:29 pm
Rather than dropping the table, I'd reccomend denying select permission, and then wait at least 45 days before dropping it.
....and then finding out it was used for 1099s next...
April 10, 2019 at 6:57 pm
Until product owners are willing to put enough detail into requirements documents, we're not going to see AI build complete programs. I know that I routinely round trip back...
April 10, 2019 at 6:54 pm
Re: redeemable for what: "RedGate is happy to present for you an extremely talented and active member of the SQL Community at this year's Pass Summit"......
April 8, 2019 at 7:28 pm
I think Steve is in a unique position here, not to the exclusion of others, but certainly at a different vantage point than most of us. While we see what...
April 8, 2019 at 4:14 pm
Happy birthday to me, get a new SSC, plumber fixed my busted pipes at the lake house within 12 hours of finding them and I get to go play at...
March 29, 2019 at 11:44 am
you know what, that's the wrong link. I meant to point you to Barry King - https://www.red-gate.com/simple-talk/sql/reporting-services/reporting-services-with-style/
that one is still up, I checked.
March 29, 2019 at 6:46 am
I don't work for RedGate, but I have used SQLPrompt, so I am VERY biased. Use SQL Prompt.
March 29, 2019 at 6:27 am
We use extended properties, and store the report styles in our database, a la Michael Coles: http://sqlblog.com/blogs/michael_coles/archive/2010/01/12/t-sql-tuesday-easy-extended-properties.aspx
use it for our confidentiality notice which is in the...
March 26, 2019 at 11:32 am
Dang, well I do too now. thanks Drew!
March 26, 2019 at 11:22 am
first, if you can change the structure of your table, do so. you should have multiple entries for each machineNo, with only one set of driver and driverVersion columns. Then...
March 26, 2019 at 7:03 am
I think EXCEPT is cleaner, but you could also use the subquery as a derived table and LEFT JOIN to it WHERE slog.subscription_id IS NULL.
March 25, 2019 at 6:45 am
Viewing 15 posts - 241 through 255 (of 607 total)