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,...

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...

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....

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...

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...

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...

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

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...

The following query gives the result I want. But I consider it a ham fisted approach. I am sure there must be a better way and I would appreciate it...

Jeff,

Thanks for the clarification. I appreciate it.

Scott, Thanks for the confirmation.

Jeff, I tried the [0-9] and it worked. I am not sure if there is a performance gain. This query will not be used very often...

You have correctly identified the declaration of the parameters, specifically the data type, as the problem. My VS statement, “.addwithValue(“@LotNo”,”000000113855”) which is implicitly converted to @LotNo=N' 000000101058' is the...

Grant,

I did not know that so thanks for the advice. In this instance I have a Server dedicated to testing. I am the only one using it. I turn the...

I have found a partial answer. I am capturing, ShowXMLPlan, RPC:Completed, SP:StatementCompleted, SQL:BatchCompleted and SQL:BatchStarting. So far in the trace I am following, only Stored Procedures have been called. It...

Gail,

I am still a bit lost so let me paraphrase. A CTE never writes data to the TempDb. But in this instance since the TempDb grows from 8MB to 3.8...