Tag Info

New answers tagged

1

You may want to normalize out the comments field to allow for a comments chain. This may have additional fields such as userid and date. This might result in a table tracking actions on issues. If this is not part of your design, I wouldn't normalize the comments field out. It appears you have an optional 1-1 relationship between the status checks and ...


0

I can see that this question has been here a few days and no one has taken a stab at it yet. I'm not familiar with mySQL so I can't give you a sample that will work, but here is an idea for you. Add another column to your table with a hash of the two teamID's. You will need to take care that the teams are entered in the same order, say ascending by their ...


0

Here are your duplicates, then everything else is your non-duplicate. with c as ( select *, row_number() over (partition by PostSur, Name order by ID) as rowID from Aron_Reporting.dbo.Customer_NewSort ) select c.* from c inner join c c2 on c.PostSur = c2.PostSur AND c.rowID > 1 AND c2.rowID = 1 as rowID order by PostSur This ...



Top 50 recent answers are included