Lab Sql

I understand the concept of a Data Warehouse after reading questions like this: What is a data ware… Read more Java/.net Developer Moving Towards Data Warehouse

how to get Task,Feature id,completed hours by date SQL SERVER QUERY.lets say there is a task 123 i… Read more How To Get Task Id,feature Id,complete Hrs By Accessing Tfs Warehouse By Date In Vs 2017?

I have a table with three columns: planning_start_date - planning_end_date - quantity. For example … Read more Sql/mysql: Split A Quantity Value Into Multiple Rows By Date

I need to calculate the time that is between 8AM and 10PM. Other time I dont need. and now I do thi… Read more Filter Length Of Time

Earlier today, I asked this question and got the answer I was looking for. Now I have a follow-up q… Read more Merge - Update Column Values Separately, Based On Logic In When Matched Block

The highlights in the image below shows the logic I want to implement. I realize the syntax is inco… Read more Merge - Conditional "when Matched Then Update"

I have a number of sql queries which take year as a parameter and generate various annual reports f… Read more Collecting Annual Aggregated Data For Later Quick Access

I'm familiar with the concept of using partitions in Oracle as a technique to pubish incrementa… Read more Partition Exchange As Publishing Technique In Sql Server?