Viewing 15 posts - 1 through 15 (of 2,637 total)
This is close... hopefully someone can figure out the one part I can't.
I wonder if I can upload .rar files... wish me luck.
October 22, 2019 at 2:19 am
I got the REPLACE stuff to work consistently correctly only if I looped (yep, dirty word) until all the double spaces were replaced. For example, if the input string had...
October 17, 2019 at 5:05 am
October 17, 2019 at 2:06 am
Don't you determine entities and relationships first, and then determine groupings of those and put those into schemas?
Your questions are REALLY vague. Maybe you should clarify them.
October 14, 2019 at 11:08 pm
Okay, here's my screenshot. It's starting to make more sense. If I move up the hierarchy from a leaf node to the root, I just multiply the quantity at each...
October 11, 2019 at 11:38 pm
(and Steve, who's kinda busy this week) and anybody else... for grins, I did a PPT of this so I could see the hierarchy and understand what's going on "in...
October 11, 2019 at 3:16 pm
Gotta get some sleep... Just got home, so I'll do it in the morning sometime. It's a really simple tree with 3 levels, but I think it's enough to get...
October 10, 2019 at 6:18 am
Just to explain it to myself or visualize what's going on, I drew a tree of parts with assemblies etc. I started with something I could get my head around...
October 9, 2019 at 12:07 am
Something like this? (Use a Calendar table).
use tempdb;GO-- count the dates between two days excluding weekendsCREATE TABLE #Calendar (TheDate DATE PRIMARY KEY CLUSTERED);GODECLARE @TheDate DATE = '01-Jan-2019'WHILE...
October 6, 2019 at 9:12 pm
Got some dummy data? Create table script... you know the drill.
October 6, 2019 at 2:41 am
That’s what I was thinking. Get max of level and return all parts having that same level.
Makes sense! Thanks!
October 4, 2019 at 6:05 pm
This worked... ugly, but it worked:
DECLARE @string VARCHAR(200) = 'All I want (for Christmas) is better (TSQL) coding skills (this year).'--remove everything between parens--remove the parensDECLARE @StartPos...
October 4, 2019 at 3:12 am
Use CHARINDEX() to find the position of the open/close parens, and then use SUBSTRING() to get the parts between them, and REPLACE() to swap that with an empty string?
October 4, 2019 at 12:09 am
is there an easy way to identify those?
October 3, 2019 at 7:18 pm
Live and learn, I guess.
I might have to revisit this and rewrite it when I learn how to do it better. I think part of the challenge is that it's...
September 30, 2019 at 6:06 pm