Viewing 15 posts - 1 through 15 (of 37 total)
Yes - I agree with Steveo. There is a challenge in finding ways to flexibly enable end users to explore well managed, modeled, and governed data, while also being able...
June 10, 2019 at 3:30 pm
August 16, 2017 at 12:22 pm
"I prefer Count Star to Count Dracula, because I don't like having to consider which Draculas are NULL"
March 8, 2016 at 6:48 am
select ROUND(7.9, 0) , ROUND(7.4, 0)
Works for me...
November 16, 2015 at 11:47 am
dndaughtery (10/21/2015)
Yeah its between the CTE's and main query. Need that value for some math
Then you need to load that value separately. Your CTEs all cease to exist as...
October 21, 2015 at 10:38 am
Is this a query between your CTEs and your main select? That would make it so that your CTEs don't exist by the time your query is run.
...
October 21, 2015 at 10:29 am
The CTE must come first, before the INSERT keyword.
The semicolon you had in there had terminated your statement before it had begun.
with cte
as
(
select distinct NHF.UOM,MAP.DESCRIPTION
from Dataload..RepairSORNHF NHF
INNER JOIN
Dataload..RepairSORMapping MAP
ONNHF.UOM =...
October 7, 2015 at 7:42 am
Also, is there significance to the extra spaces in the 3rd row of data? (Before and after the '=')
September 16, 2015 at 10:12 am
Are there always three fruits, or does that quantity vary row to row?
September 16, 2015 at 10:09 am
So given a value of 2, what would you expect as results? All rows that are a member of an "unchanged" group of 2 or more? Or do...
September 16, 2015 at 5:49 am
It's a full Cartesian Product. There's no join criteria.
select A.Numbers , B.Serial
fromTableAA,
TableBB
or
select A.Numbers , B.Serial
fromTableAA
cross joinTableBB
(Edited to tighten up formatting)
September 14, 2015 at 9:17 am
ChrisM@Work (9/10/2015)
http://sqlblog.com/blogs/aaron_bertrand/archive/2009/10/06/bad-habits-to-kick-order-by-ordinal.aspx
Yes, my argument has heretofore been
From above article: "Invariably, someone at some point is going to come in and add a column, remove a column, or change the...
September 10, 2015 at 7:39 am
Lynn Pettis (9/9/2015)
One last thing, don't order by position (ORDER BY 1), order by named column (ORDER BY ico.providerspecialty).
Lynn -
I'm interested in the reasoning behind this suggestion. I agree...
September 10, 2015 at 6:44 am
Please show us your table, the data in it, and the results you want to see.
Better yet, give us the DDL for the table, INSERT statements for your data, the...
June 22, 2015 at 2:19 pm
Viewing 15 posts - 1 through 15 (of 37 total)