Viewing 15 posts - 1 through 15 (of 37 total)
Transact SQL has a set of functions called Window functions meant to deal with problems of the kind you deal with.
Here is a good link to read: https://www.red-gate.com/simple-talk/sql/t-sql-programming/introduction-to-t-sql-window-functions/
If you...
June 30, 2020 at 5:39 pm
You are right about commas. Good catch and useful observation, thank you. Comma issue be avoided by rearranging the statement, by positioning commas inside CASE. However, Concat_WS() is way better,...
June 30, 2020 at 5:29 pm
Without more information, It looks like the table design does not support well what you want to achieve. The best thing would be to normalize the design - instead of...
June 30, 2020 at 4:16 pm
AI is just a new gadget that promisses hope of 'managing things succesfully' even if we don't know how to manage them without AI. I have seen managers waiting for...
July 22, 2019 at 7:31 pm
The best days in my career where whan I was 25 years old. Worked as engineer back then, dated a younger coleague, and also did some computer work. I do...
August 20, 2018 at 11:03 am
Perhaps we need to go back to the theory, to deal with NULLs. I pologize for a bit longer post, perhaps even boring. If you are afraid of being bored,...
July 17, 2018 at 3:23 pm
Perhaps the simplest way to demonstrate what is going on is:
If you need to show each month for each institution, regardless of any activity for given institution in...
June 27, 2018 at 10:49 am
It is not just the developers. Unlike IT industry, in engineering fields, knowledge is cumulative - one learns what older generations have learned, plus some new stuff. As time goes...
June 25, 2018 at 3:00 pm
There is not enough data. In table #stores you provided absolute values for metrics - column names are metrics names, I assume. We don't know which value corresponds to which...
May 10, 2018 at 2:59 pm
"I'd just prefer that we stick to a single time schedule the entire year."
Amen to that 🙂
Regarding problems witth extracurricular activites, in case summer day is too...
March 8, 2018 at 12:20 pm
Maybe you should read something on relational database design, independent of SQL. If you need to constantly add columns to your tables, then your problem is of a different sort....
February 5, 2018 at 1:35 pm
Once you know the rules, you set a UNIQUE constraint on the target table and stop worrying. However, the need to prevent attempt to enter duplicates on teh front end...
February 5, 2018 at 12:49 pm
All advices offered above are valid. However, it is possible to write the query with only one date - the one you want.
Once, I had similar problem. The...
October 6, 2017 at 9:39 am
I want to thank everybody for useful observations and comments, this is my first article, and all comments mean a lot to me 🙂
The idea was...
August 8, 2017 at 2:04 pm
But somebody else on here may have a better idea
Any book on SQL Querying by Itzik Ben-Gan shows how to deal with hierarchies, graphs and networks as...
July 13, 2017 at 10:50 am
Viewing 15 posts - 1 through 15 (of 37 total)