Viewing 15 posts - 5,896 through 5,910 (of 59,070 total)
I apologize for not knowing the answer, Neil, but wanted to thank you for giving me another reason to avoid SSRS. 😀
December 11, 2020 at 11:00 pm
Hello,
I am not great with SQL and the statement I wrote is in TSQL and it is working. I would like this same statement to run in MSSQL, can...
December 11, 2020 at 10:58 pm
Are you terminating the preceding statement with a semicolon?
You can start statements that begin with "WITH" with a semicolon:
;WITH ret AS(
Now, there's an interview question if...
December 11, 2020 at 10:53 pm
we are currently doing a 1 hour tran log backup for a system, I'd like to push that up to 1 minute. Is there a performance hit to be...
December 11, 2020 at 10:20 pm
The standard pattern uses 0 as the base, not 1 or -1 or some other "cute" trick.
No sir... There are a couple of "standards". The "standard" that YOU and...
December 11, 2020 at 9:00 pm
Those extra steps are not required for SQL 2016, at least according to MS internals folks. For example, your statement of needing an explicit CREATE TABLE statement? Again, I...
December 11, 2020 at 8:57 pm
@aaron.reese ,
If you're absolutely stuck with doing the way that you've outlined, you've posted in a 2017 forum so lets use some of the functionality available.
First, here's the test data...
December 11, 2020 at 8:33 pm
...the extracts will be ad-hoc so I'm not concerned about speed, rather about maintainability.
Right now, the "config" table is setup only to provide a list of columns by...
December 11, 2020 at 8:14 pm
No. The human brain is designed to recognize patterns. Sticking with a familiar patterns drastically speeds up recognition...
December 11, 2020 at 4:14 pm
Ok... you said that the entire table is generated nightly. That makes me want to assume that you're not actually doing any updates or additional inserts to the table. ...
December 11, 2020 at 7:31 am
not wanting to get off-topic and there are dozens of threads on EAV on this site, why would you prefer EAV for this problem. I can turn it into...
December 11, 2020 at 3:15 am
I'm clueless after trying everything and searching for others with this experience still getting the same errors again and again.
Please help me out with this error
Like I said earlier...
December 11, 2020 at 2:57 am
Convoluted method, don't do it.
Only to those that think so.
December 11, 2020 at 2:53 am
Just as a bit of a drive by shooting, the following code...
select
DATEPART (d, datetime) AS Day,
CASE DATEPART(DW, datetime)
WHEN 1 THEN 'Sun'
...
December 10, 2020 at 4:28 pm
(at least it's not EAV!)
Actually, too bad it's not! 😉
December 10, 2020 at 4:17 pm
Viewing 15 posts - 5,896 through 5,910 (of 59,070 total)