Viewing 15 posts - 331 through 345 (of 4,087 total)
This is a public forum, not private messages. You don't need to respond to every single person who responded with the exact same information.
Also, my name is Drew, not Dew...
October 31, 2019 at 3:02 pm
You haven't given us enough information to provide a solution for you.
October 30, 2019 at 8:10 pm
You've been around long enough to know that you should post sample data (as DML with INSERTs) and not pictures. I can't cut and paste your pictures into SSMS.
You need...
October 30, 2019 at 3:30 pm
I certainly would love to know the thinking behind the decision to write <Field1> + (-1*<Field2>) instead of just writing <Field1> - <Field2>. I'm seeing it in multiple places in...
October 28, 2019 at 8:14 pm
@FlashX, You should ALWAYS use QUOTENAME() instead of hard-coding opening and closing brackets[]. One of the methods used in SQL injection is adding spurious closing brackets.
Drew
October 28, 2019 at 7:11 pm
There are many different options here and they all depend on what your final data needs are. Since we don't know what your final data should look like, we can't...
October 28, 2019 at 5:01 pm
A left join and a right join are not the same thing. They are mirrors of each other.
The main issue here is that they are using NULL values for unknown...
October 24, 2019 at 10:01 pm
The easiest thing is to probably have two fields one with the number and the other with the percent of total and to load one as visible and the other...
October 24, 2019 at 4:11 pm
No, it is assigning BOTH. It assigns values based on the last row processed. (I believe it's also smart enough to know it only needs to process one row.) One...
October 24, 2019 at 3:59 pm
I'm guessing that the table is set up as an EAV. There are other ways to get the information, but the fastest will most likely be the CROSS TAB using...
October 24, 2019 at 3:39 pm
It's all guesswork until the OP responds. The query I posted was an update to bmg's. I think the best approach is actually to use a MAX/CASE, but I didn't...
October 23, 2019 at 5:35 pm
You're using the wrong spatial type. Geometry uses a flat Euclidean coordinate system, but latitude and longitude are properties of a round-Earth coordinate system which is used in Geography.
Drew
October 23, 2019 at 4:39 pm
WITH cte AS (
SELECT [RANGE], [STATUS], LAG([DATE]) OVER (PARTITION BY [ID] ORDER BY [RANGE]) AS [PrevDATE]
FROM <table name>
)
UPDATE [cte]
SET [STATUS]='Y'
WHERE [RANGE]='001' AND [PrevDate]='30-SEP-2019'
I think this...
October 23, 2019 at 4:24 pm
Duplicate post. Please post responses here.
Drew
October 23, 2019 at 3:40 pm
I think this is what he is looking for.
WITH t2 AS
(
SELECT t2.ID, t2.ValueA, ROW_NUMBER() OVER(PARTITION BY t2.ID ORDER BY t2.ValueA) AS rn
FROM Table2 AS t2
)
, t3...
October 22, 2019 at 8:27 pm
Viewing 15 posts - 331 through 345 (of 4,087 total)