Viewing 15 posts - 1,006 through 1,020 (of 15,381 total)
If you truly need an identity there is no way to ensure the "order" without using a order by. You correctly identified that this would require the steps you identified.
February 13, 2017 at 3:00 pm
This should be a foreign key. Plain and simple. Doing this in a trigger is a bad decision for several reasons. It is more complicated to maintain, it far more...
February 13, 2017 at 2:56 pm
I am shocked at how many people are still creating new applications in VB6, Delphi,...
February 13, 2017 at 7:51 am
February 10, 2017 at 1:16 pm
February 9, 2017 at 3:05 pm
I'm trying to do some matching between tables for record exclusion based on matching...
February 9, 2017 at 2:36 pm
I worked in a place that had one of these monstrosities. It was named MasterXRef. By the time I arrived it was as you describe, somewhat wide and way too...
February 9, 2017 at 1:22 pm
SEEEEEEEAAAAAAAAANNNNNNN!
@whine <poke> <poke> @whine
BTW, this is me pretending to be one of those "I...
February 9, 2017 at 1:07 pm
Looks Gail and Jeff are headed into new territory shortly. They are both (especially Gail) about the surpass the 50k mark. WOW!!!
February 9, 2017 at 12:58 pm
When recursive data extracts are required, try CTE:
DECLARE @SPLITROW TABLE
(ORDER_NUMBER INT
,...
February 9, 2017 at 7:03 am
February 7, 2017 at 10:50 am
February 7, 2017 at 10:39 am
February 6, 2017 at 3:03 pm
Viewing 15 posts - 1,006 through 1,020 (of 15,381 total)