Viewing 15 posts - 3,511 through 3,525 (of 7,614 total)
March 13, 2018 at 11:49 am
So below either one should work,
where sg.storedDate...
March 13, 2018 at 11:30 am
TableA is not the issue. And the subquery is not correlated, so the subquery is not directly the issue either.
Look at the query plan. If SQL's having to...
March 13, 2018 at 11:24 am
March 8, 2018 at 11:36 am
'm fully in agreement about normalization, though. The impedance mismatch between object oriented design and 3NF is often painful (3NF is viewed by many developers as horrifically antiquated).
Roger.Plowman
March 8, 2018 at 10:24 am
True enough. However, one nitpick. Nothing wrong with using identities as a clustered and primary key. Mind you, my experience is designing "small to medium" OLTP systems (read, around...
March 8, 2018 at 10:17 am
March 7, 2018 at 2:52 pm
March 7, 2018 at 2:47 pm
?? Nothing's changed in that query.
...
from
(
select B.company_name as Company
,SUM(CASE WHEN IssMth = 1 then (CashOnly) else 0 end) as Jan1...
March 7, 2018 at 2:27 pm
SELECT ID, FIRSTNAME, LASTNAME,
FIRSTNAME + '.' + LASTNAME +
CASE WHEN row_num = 1 THEN '' ELSE CAST(row_num - 1 AS...
March 7, 2018 at 2:08 pm
Those requirements seem contradictory to me.
What I need help figuring out is how can I see if
All of the Difference columns are > 1 (meaning there...
March 5, 2018 at 3:52 pm
Copy the :
where SplitEmpID is not null
check into both the inner queries so that it execs before the UNION A-L-L, not after.
If you at all can, change...
March 5, 2018 at 3:47 pm
Also, you need to either:
1) check the number of logical log files
2) shrink the log as much as possible, then immediately reallocate it in large chunks.
2) is easier...
February 28, 2018 at 1:16 pm
February 27, 2018 at 1:00 pm
Viewing 15 posts - 3,511 through 3,525 (of 7,614 total)