In one of the interviews I was asked to how I’d rank the column values without using Windows function and found it interesting. Any such
I literally don’t know anything about SQL. I don’t know how to start anything, I tried watching many youtube videos for this simple task but
Hi! I have a column with some empty rows and then some sales, so i had to import it as VARCHAR so the importwizard wouldnt
I understand that memory/storage difference between one column vs two columns is going to be negligible unless the database is very large. And I realize
We have an old Access application that is important to the business. The application will sometimes slow to a crawl and I’m not sure why.
I’ve been a Business Analyst for 15+ years. I love excel and every way of manipulating data within it. Unfortunately, my department is getting shut
I’d like to get the average of the past 6 months for each parternadvertiser–however the current output I am getting isn’t giving me the correct
I know, the title is hard to understand but I don’t know how to describe my problem in one line. So, in my schema I
Example: i j 0 aa 1 aaa 2 aaaa Is there a way to grab either the bytes or the length of this value (or
Trying to create a function that updates the verified field of my subscribers table. Technically, this works, but it updates the value on every row.