Viewing 15 posts - 1,126 through 1,140 (of 1,464 total)
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
The correct answer is not provided in the possible options.
According to the link provided as proof of the answer, it expressly indicates that the "CORRECT" answer is not...
April 27, 2017 at 4:53 am
rodjkidd - Thursday, April 27, 2017 2:12 AMJack
Jill
April 27, 2017 at 2:26 am
Perhaps this will provide what you are looking for
sys.dm_exec_describe_first_result_set_for_object
April 26, 2017 at 12:49 pm
where AdmitDateTime is not...
April 26, 2017 at 12:23 pm
April 26, 2017 at 4:14 am
Viewing 15 posts - 1,126 through 1,140 (of 1,464 total)