Viewing 15 posts - 12,346 through 12,360 (of 59,062 total)
You're also using a GROUP BY as a replacement for DISTINCT. That usually means that the criteria is insufficient for the job.
Also, what you posted is an estimated...
May 9, 2018 at 7:44 pm
If you have to do the conversion anyway, maybe convert through HASHBYTES??? It's not quite a guarantee of things that are identical but, if the result of hasbytes is different,...
May 9, 2018 at 7:24 pm
I agree with DHeath above. It doesn't matter what any of us think or say. It only matters what the vendor says. Ask them to verify and then sign off...
May 9, 2018 at 7:21 pm
May 9, 2018 at 6:58 pm
May 9, 2018 at 6:47 pm
May 9, 2018 at 2:35 pm
May 9, 2018 at 2:33 pm
Trying to update some datetime2 columns.
UPDATE T_MYTABLE SET dateTransferred = '2018-03-26 05.00.00' where id =...
May 9, 2018 at 2:23 pm
ID DESCRIPTION
1 An
1 Apple
1 a
1 day
1 keeps
1 doctor
1 away
2 hello
3 The
3
3 XYZ
3 XYZZ
OUTPUT
ID DESCRIPTION
1 An,Apple,a,day,keeps,doctor,away
2 hello
3 The,,XYZ,XYZZ
Have implemented using xml_path with stuff.
But I will be having millions of...
May 9, 2018 at 2:17 pm
Steve Jones - SSC Editor - Tuesday, May 8, 2018 8:47 AMAlso, what you're describing is what DevOps is about.
Agreed. And...
May 8, 2018 at 5:09 pm
May 8, 2018 at 8:15 am
May 7, 2018 at 11:18 am
Viewing 15 posts - 12,346 through 12,360 (of 59,062 total)