Viewing 15 posts - 31 through 45 (of 67 total)
Oh my gosh..... that was it. Like worked
there are spaces. thank you !
April 9, 2020 at 9:41 pm
So I attach the Table schema (I think it got blocked) , both date fields are Datetime type.
I don't have an actual example of a record not showing up because...
January 14, 2020 at 6:59 pm
Jeff,
I noticed that the query stops retuning records after 6:00pm , so I used the other date option you suggested. because both tables date columns are Datetime data type.
January 14, 2020 at 12:34 am
Hey Jeff,
That worked like a charm , thanks much !
The other Date was TransactionDate, I added that in , and although both Tables use column Datetime, it worked right without...
January 11, 2020 at 8:43 pm
Hallelujah !! Yes, that worked perfectly , thank you Phil.
September 12, 2019 at 10:47 pm
For real ! I think you guys are taking the Piss out of me.
I appreciate the education and advise on ISO standards and best practises , Heaven knows I need...
September 12, 2019 at 9:32 pm
I've included 2 rows below, but not sure that's helpful.
So maybe an explanation will help more. I'm not sure you will approve of the overall design as a best practice...
September 11, 2019 at 7:15 pm
It was missing parenthesis on the values...this worked.
USE [SSSUTIL]
GO
INSERT INTO [dbo].[RailCarCycleYard]
([RailcarID]
...
September 11, 2019 at 6:29 pm
my bad..here is the insert again.
I though I was qualifying the field name by prefixing it with the table , I originally tried an alias but that gave me a...
September 11, 2019 at 4:40 pm
Here you go...sorry about this Im a bit green (but learning)
USE [SSSUTIL]
GO
INSERT INTO [dbo].[RailCarCycleYard]
([RailcarID]
...
September 11, 2019 at 4:24 pm
Hope this helps....
Here is the insert I was trying
Insert into [RailCarCycle] ([Railcarid],[StartDate])
select [RailCarid],[LoadDate]
from [RailCarCycleYard]
where [RailCarCycle].[Railcarid] = [RailCarCycleyard].[Railcarid] and [RailCarCycle].[EndDate] is not...
September 11, 2019 at 3:47 pm
I looked at you example of how to post a question.........I've provided the code sample that I'm using , I added an image of the table. I've described my scenario...
September 11, 2019 at 3:33 pm
Im using a subquery NOT EXISTS but this only stops duplicates
Insert into [RailCarCycle] ([Railcarid],[StartDate])
select [RailCarid],[LoadDate]
from [RailCarCycleYard]
where not exists( select NULL from [RailCarCycle]...
September 11, 2019 at 3:04 pm
Great !!! that did the trick 🙂
Thanks so much
March 1, 2019 at 11:12 am
November 2, 2018 at 11:59 am
Viewing 15 posts - 31 through 45 (of 67 total)