Viewing 15 posts - 1,126 through 1,140 (of 1,470 total)
The following code in a separate file per table, means that the entire file is deployed each time there is a change. It is also re-runnable.
If there is...
May 5, 2017 at 8:55 am
Use EXCEPT to find the mismatched.
UNPIVOT those rows, and Use EXCEPT again.
May 4, 2017 at 1:38 pm
Create a trigger that updates the value of confirmDate
May 3, 2017 at 11:24 pm
May 3, 2017 at 8:27 am
Stuart Davies - Wednesday, May 3, 2017 12:45 AMSpace
Odyssey
May 3, 2017 at 1:06 am
ManicStar - Tuesday, May 2, 2017 7:03 AMWaiting
Lady (in)
May 2, 2017 at 11:17 am
I believe that this will achieve what you are looking for.
It feels a bit clunky, but I can't seem to think of a better way at this stage.
.
May 1, 2017 at 2:40 am
I get:
ORDER...
April 28, 2017 at 2:25 pm
This should get you what you are looking for
SELECT
ANK.id
, ReconstructedAutoName = ltrim(rtrim(ANK.grp)) + ' -'
+ STUFF(...
April 28, 2017 at 2:14 pm
Show us what you done so far, and we will try to steer you towards a good design.
April 28, 2017 at 1:11 pm
Can you please provide more information on what you are trying to achieve.
April 28, 2017 at 1:08 pm
Is it possible that RecordID is not the correct field to group on?
If I take Steve's sample and tweak it slightly (with a different RecordID for each row),...
April 28, 2017 at 9:57 am
April 28, 2017 at 8:55 am
April 27, 2017 at 7:53 am
ManicStar - Thursday, April 27, 2017 7:50 AMList
Laundry
April 27, 2017 at 7:51 am
Viewing 15 posts - 1,126 through 1,140 (of 1,470 total)