Viewing 15 posts - 16 through 30 (of 595 total)
not wanting to get off-topic and there are dozens of threads on EAV on this site, why would you prefer EAV for this problem. I can turn it into EAV...
December 10, 2020 at 5:02 pm
Thanks Scott, you have waaay too much time on your hands.
That was effectivley what I was going to do but rather than create 300 views, just dump the data sets,...
December 10, 2020 at 5:01 pm
Have a look at the DataVault pattern. It allows you to store temporal changes in a very efficient manner as you can split the columns in a table into fast...
December 10, 2020 at 12:51 pm
One solution:
Schedule job and stored procedure. Take the record ID (primary key?) and a hash of all the other columns and store it in a new table. The stored procedure...
April 25, 2020 at 9:48 am
Yes!
I am learning Vue.js and Angular 9 (search Udemy for courses by Max Schwartzmuller - he is excellent). Knowing how is supposed to work on the front-end helps you model...
April 25, 2020 at 9:41 am
Sounds like homework to me...
AS PP said, no code without DDL and populated tables... but here is my approach:
Q1: CTE to filter cases to 2010H2, CTE to apply RANK() OVER()...
April 25, 2020 at 9:24 am
>>I have to support all versions from SQL Server and SQL Express 2005
Congratulations, you have just missed the 4th anniversary of Microsoft no longer supporting SQL Express 2005. It sounds...
April 24, 2020 at 5:29 pm
but the problem isn't necessarily with the trigger, it's with the design philosophy - but in my experience, good luck trying to change that 🙂
The CASE statements will be slowing...
April 24, 2020 at 5:10 pm
I agree. So many times I have had to either read or create XML files that are effectively flat data files without proper collections or hierarchy tags and I think...
April 24, 2020 at 3:42 pm
Not a direct answer to the question, but I think you may be looking at the problem from the wrong end. How about holding all price history in the live...
April 24, 2020 at 2:55 pm
#tagbloat
My Favourite was an XML file I worked with in the health service. <PersonGenderCurrent>1</PersonGenderCurrent>
FWIW I still like XML. Yes you need a decent viewer but XML parsers have been built...
April 24, 2020 at 2:46 pm
because you can't do rs.EOF if the stored procedure returned a message before it returned the dataset
October 8, 2019 at 5:38 pm
not one that I would call easy 🙂
in the past, I have used STUFF()...FOR XML to build a hierarchical map string (not strictly necessary but helps with debugging) and then...
October 8, 2019 at 5:35 pm
In the absence of any responses. I have managed to fashion the following code which looks like is working for the specified data set and should work generically
October 3, 2019 at 2:12 pm
What happens inside @query? This might need SET NOCOUNT ON as well
October 3, 2019 at 1:02 pm
Viewing 15 posts - 16 through 30 (of 595 total)