Viewing 15 posts - 2,131 through 2,145 (of 59,066 total)
Thanks for the CR LF note, I am trying to bcp out from mssql and load to mysql.
Does that mean you're all set now?
January 5, 2023 at 1:53 pm
Some old tech that I wish would come back is people that actually know how to ask a question and then read the answer and act upon it correctly. 🙁
And......
January 5, 2023 at 1:25 am
p.s. If there are millions of rows each day, this is the slow method. It would be better to have the remote machine export the data in the "native" format...
January 5, 2023 at 1:23 am
Since there are millions of records for each day..
On Local server: Won't I have to find the max(t_stamp) for date 2/10/2022 and then Min(t_stamp) for 2/17/2022 then pass that...
January 5, 2023 at 1:22 am
I ended up with this as my query...
Would there be any way to get the range of t_stamp values for 01-21-2022 thru 01-25-2022 and send that into query string...
January 4, 2023 at 9:43 pm
Jonathan AC Roberts wrote:It will even answer Jeff's primary interview question correctly:
Actually, that's just the first part of the answer that I expect. 😀
But...
January 4, 2023 at 6:32 pm
Jonathan AC Roberts wrote:It will even answer Jeff's primary interview question correctly:
Actually, that's just the first part of the answer that I expect. 😀
But I'm sure it got further than...
January 4, 2023 at 5:47 pm
It will even answer Jeff's primary interview question correctly:
Actually, that's just the first part of the answer that I expect. 😀
January 4, 2023 at 5:42 pm
Does any of the data itself contain a control code for a carriage return or line feed?
It's also a really bad thing to include logins and passwords in clear text. ...
January 4, 2023 at 5:22 pm
I don't believe you need a date table for this. It would just be another thing to worry about. I'd use a method similar to what Ant-Green used.
I...
January 4, 2023 at 5:18 pm
Heh... Rick and I are "old tech" and we still work just fine. 😀
January 4, 2023 at 5:13 pm
You're still using this junk...
convert(date,DATEADD(s,t_stamp/1000,''1969-12-31 20:00:00'')
There's no need to convert the time stamps on the remote server to date time. You also already know how to convert...
January 4, 2023 at 2:56 pm
Jeff Moden wrote:Except for the occasional Indexed View, this is one of the many reasons why I hate views.
Ha my exception is for VIEWS with INSTEAD OF triggers
Cool and timely...
January 4, 2023 at 12:37 am
Except for the occasional Indexed View, this is one of the many reasons why I hate views.
Instead, try a "parameterized inline view" better known as an "Inline Table Valued Function"...
January 4, 2023 at 12:13 am
Happy New Year, everyone, and welcome to 2023!
Thanks, Steve, and thanks for taking care of this Website and all that you do for the community!
January 3, 2023 at 11:50 pm
Viewing 15 posts - 2,131 through 2,145 (of 59,066 total)