Viewing 15 posts - 1 through 15 (of 38 total)
In the end i used powershell script like below to change Encoding to ASCII and that did the trick
Get-ChildItem "PathToYourFolder" -Filter *.xml |
ForEach-Object{
$file=Get-Content $_.FullName
$file | Set-Content -Encoding...
July 23, 2021 at 9:50 am
I can't unfortunately.
So, script task is the way to go and C#.
I see what i can do.
Thank you!
July 14, 2021 at 12:27 pm
Awesome!
It works as i wanted to!
Many, many thanks!
January 8, 2021 at 1:40 pm
Thank you very much for your answers!
November 18, 2019 at 12:43 pm
That works like a charm. Thank you very much.
Best regards
March 27, 2019 at 3:34 am
Thank you very much for a response.
Unfortunatelly, i can't alter or add any functions on the server.
February 25, 2019 at 7:05 am
Tom, thank you very much for replying.
It is my mistake that i haven't mentioned in first post that this conversion takes place in the WHERE clause, so actual data...
January 31, 2019 at 2:26 am
Thanks for replying @ronkyle.
Because i don't have underlying key in base table i've decided to stick with a table approach.
January 28, 2019 at 12:37 am
Thanks for all replies.
The view is part of a model used in PowerBI. I wanted to build a system that will containt main table with all necessary data....
January 24, 2019 at 2:12 am
Thank you for reply.
Unfortunatelly, i don't have client identifier in originating table
January 23, 2019 at 5:30 am
Storing commas in numeric data turns that data into useless text.
This info changes my decision. I will leave data as it is and i'll try to solve...
December 13, 2018 at 6:49 am
Well, unfortunately i still don't know what i am doing wrong.
I've attachted PrintScreen from my installation window of VS 2017 where it can be seen that i've checked SSDT...
October 16, 2018 at 6:12 am
Thank you very much for your reply.
I'll try to go with your advice.
Best regards.
Lukas
October 15, 2018 at 4:42 am
Thank you for reply, that solves my problems.
July 2, 2018 at 7:21 am
Hi,
Thanks for reply but what i meant is whether i can expect version for sql server 2016 or 2017?
July 2, 2018 at 5:26 am
Viewing 15 posts - 1 through 15 (of 38 total)