Viewing 15 posts - 1 through 15 (of 96 total)
Andy,
Thank you for your reply. Sorry about the zip. I was looking for a way to attach a doc of some sort. I ruled out Word. Thought PDF would be...
April 3, 2020 at 3:17 pm
Third try
March 26, 2020 at 6:29 pm
First upload failed. Trying a Zip file of the pdf
March 26, 2020 at 6:28 pm
Thank you for confirming what I suspected.
Pat
January 10, 2018 at 2:14 pm
Update. It does not seem to be a permissions issue. I believe it is a syntax issue.
Truncate Table [FS-JirEMSQL].JIREM10.dbo.JIRABConcentration Fails
But
Truncate Table JIREM10.dbo.JIRABConcentration is successful.
It...
September 27, 2016 at 11:05 am
SS,
Thank you for your efforts. So that other who read this will have a better understanding without having to recreate the tables and queries, I have added a Identity field...
December 23, 2015 at 6:57 pm
First let me offer an apology to everyone who has tried to use the data I supplied. it was bad, even the second set. Sorry.
Insert into OverlapTest
(ItemNo, Start_Dt, End_Dt)
Select 'A',20150101,20151231
Union...
December 23, 2015 at 1:34 pm
John,
Yes. I agree that would work. I was hoping to find a query solution. I was thinking that if the table were Ordered by item number and Start date,...
December 23, 2015 at 9:55 am
Lynn,
Ooops. Sorry. You are correct. Item B should have two date ranges that do NOT overlap each other.
Insert into OverlapTest
(ItemNo, Start_Dt, End_Dt)
Select 'A',20150101,20151231
Union all
Select 'A',20140101,20151231
Union all
Select 'B',20150101,20151231
union all
Select 'B',20140101,20141231
union all...
December 23, 2015 at 9:47 am
Both solutions worked. The Union only worked fine. So did the double CTE. I didn't know that (a second CTE) could be done. The key seems to be the comma....
June 9, 2015 at 11:14 am
Thanks for your replies. I should have thought about the UNION. I will try that now.
I do not understand how to create a CTE from a CTE. Could you reference...
June 9, 2015 at 9:29 am
Gila,
Thank you. I didn't try that.
I did find an answer that worked for all of my questions. On the new server and newer version of SQL, I found that if...
November 25, 2014 at 7:33 am
Lynn,
There is still an error. Notice line 2 and Line 5 are both Item 2. Yet the grid shows a different per item cost $20 and $40, respectively. Line 5...
November 18, 2014 at 11:05 am
Lynn,
You are correct. My posted data is incorrect. Please see below.
MMartin1 and Serg-52, Thank you and I will review your comments more closely this evening.
thanks,
pat
November 18, 2014 at 6:47 am
Further testing on more complicated BOM's show that the above response does not return the correct results.
Creating a BOM listing or an indented BOM is well documented on this and...
November 16, 2014 at 12:21 pm
Viewing 15 posts - 1 through 15 (of 96 total)