Viewing 15 posts - 4,921 through 4,935 (of 59,071 total)
Thanks for the feedback, Bruin...
Heh... you DO have to pay attention to the resolution of the data. 😀
--Jeff Moden
Change is inevitable... Change for the better is not.
July 19, 2021 at 2:29 am
Probably not the operating system. Have you checked the files in the two different places for things like...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 17, 2021 at 2:15 pm
Did you click on the text 'Failed"? That should explain what is wrong.
If I had to guess - you have a 64-bit version of SQL Server installed and are...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 16, 2021 at 12:25 am
The result of the query SELECT @@VERSION is: "Microsoft SQL Server 2014 - 12.0.2269.0 (X64)"
I don't understand that (X64) because this query is executed in: C:\Program Files (x86)\Microsoft SQL...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 16, 2021 at 12:23 am
Had a strange error processing file from server...
It was the first file that had data...
StartDT: 15 Jul 2021 08:44:42:777 Working on file 25 of 89 files: G:\line_speed\F303-Line10.csv... Msg 2627,...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 16, 2021 at 12:14 am
On the subject of "sometimes" quoted CSV's...
I totally agree that it shouldn't be necessary. MS has had more that 2 decades to make this "simple" stuff right as...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 15, 2021 at 10:15 pm
FROM tblRecievedQuantity TRQLEFT JOIN tblOrderQuantity AS TOQ ON TOQ.order_id = TRQ.order_idLEFT JOIN tblIssuedQuantity AS TIQ ON TOQ.order_id = TIQ.order_idLEFT JOIN tblReceivedTrack AS TRT ON TOQ.order_id...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 15, 2021 at 10:12 pm
Actually, both OR and ISNULL are horrible for performance and should be avoided... when I say "should be avoided", I'm very close to saying "must be avoided at all costs"...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 15, 2021 at 3:12 am
My previous experience with SSIS was to determine a method to make table-to-table transfers like this work much more quickly. The way I did that was I stopped using SSIS...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 15, 2021 at 1:51 am
Now that you have a couple of answers, I have to ask... why do you need to do this? What will it be used for? What business purpose does it...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 15, 2021 at 1:49 am
You left out the name of the date column for the two tables you're talking about and you didn't include those names anywhere in the code. With that in mind,...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 15, 2021 at 1:10 am
A systems works with Windows Server 2012 R2 Standard On this system MS SQL-server 2014 (x86) Express version 12.0.2000.8 is installed. The service pack SP3 had to be installed....
--Jeff Moden
Change is inevitable... Change for the better is not.
July 15, 2021 at 12:26 am
I read your question a little differently than Grant and Jeff, so I just wanted to confirm what you were looking to do.
If I understand your question correctly,...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 14, 2021 at 8:46 pm
On the subject of "sometimes" quoted CSV's...
I totally agree that it shouldn't be necessary. MS has had more that 2 decades to make this "simple" stuff right as have a...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 14, 2021 at 8:19 pm
Let's peel one potato at a time. The first stop is the last item in your code...
(jh.ProdQty - jh.QtyCompleted > 0)
Do you see any problems with...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 14, 2021 at 5:02 am
Viewing 15 posts - 4,921 through 4,935 (of 59,071 total)