Viewing 15 posts - 1 through 15 (of 122 total)
January 17, 2020 at 3:17 pm
Actually I wrote data in both instances. An example is below
-- Approach 1
CREATE TABLE FOO (iid int identity, ky int)
INSERT FOO(ky) SELECT ky FROM myTable ORDER BY ky
-- Approach 2
January 17, 2020 at 2:36 pm
Thanks for the responses, everyone. Yes, once again tripped up by floats. And fooled by the fact that for most of the numbers the result worked out how we wanted. ...
December 11, 2019 at 7:11 pm
Yes, this was happening on an Excel import process. Users entered percentage values from 1-100. When they get to the server they are presented as floats by the C# import...
December 11, 2019 at 7:02 pm
that's some awesome coding there! Thanks for the improvements 🙂
December 11, 2019 at 2:25 pm
In looking at it further I think I'm barking up the wrong tree.
July 26, 2019 at 2:48 pm
Great idea, I'll look at the execution plan. Thanks for the tip.
January 4, 2019 at 10:04 am
Yes, The reason for the cartesian join is to simulate every possible calculation in the current data set to see of the result is the same when handled as an...
January 4, 2019 at 9:46 am
Thanks for the reply. What are your concerns with the cartesian join?
January 4, 2019 at 8:16 am
I think this will work but I don't know that it really saves you much. The subquery that you used doesn't go back to the same table again, it just...
September 18, 2018 at 7:57 am
I agree with you J. Drew Allen. It's not the MOST efficient way to do it but it demonstrates the mechanics of how to do it. The approach you mention is...
September 13, 2018 at 6:12 am
Here's one way to do it-- Use a common table expression to find the max values for records and records that are duplicated-- This won't...
September 12, 2018 at 10:01 am
I see what you mean. If I look at the data from the POSS perspective instead of the Sales perspective that makes sense. Thanks, now to apply this to the...
July 12, 2018 at 1:08 pm
If you were to use inner join and the Mary sales record had 2 entries, each entry would join to the POSS table causing duplication. I don't think inner join...
July 12, 2018 at 11:49 am
DoH. I can use exists and 'not exists'. I guess that's the better option.
SELECT person, category, item, Qty FROM SalesUNIONSELECT person, category, item,...
July 12, 2018 at 11:06 am