Viewing 15 posts - 46 through 60 (of 622 total)
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
But that will give you all of the nodes and their position in the tree. The OP specifically asked for only the bottom nodes. Some of these will be at...
October 3, 2019 at 12:59 pm
Bit of a dirty cheat, but seeing as they do support the site...
Download Redgate Toolbelt and use database compare. This will not only pick up top level objects such as...
October 3, 2019 at 12:52 pm
The short answer is PowerBI if data is already in the cloud
If the data sets are not too large (< 1M rows) then Excel and Pivot tables is always an...
October 3, 2019 at 12:48 pm
Viewing 15 posts - 46 through 60 (of 622 total)