Viewing 6 posts - 1 through 6 (of 6 total)
With that said - this should really be done in the reporting layer and not in SQL Server.
I understand this should be done on Reporting layer, but one of...
July 9, 2021 at 8:19 am
Yes, there are NULL values for certain rows as some is not used or just used by one employee and not the other (e.g. Bonus). Besides a new component might...
July 8, 2021 at 7:35 pm
You are absolutely right! I should do this before taking any other step now.
I can see what you mean in what I've done so far because, even though I had...
June 29, 2021 at 8:37 am
Thank you for researching and posting the valid answer 🙂
June 28, 2021 at 3:15 pm
Thank you all!
One more question though not fully related to this topic, for UNIQUE fields, is there a difference to define UNIQUE at column definition and/or while defining index? Are...
June 28, 2021 at 2:55 pm
Viewing 6 posts - 1 through 6 (of 6 total)