Skip to content Skip to sidebar Skip to footer
Showing posts with the label Data Warehouse
Java/.net Developer Moving Towards Data Warehouse

Java/.net Developer Moving Towards Data Warehouse

Post a Comment
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 Id,feature Id,complete Hrs By Accessing Tfs Warehouse By Date In Vs 2017?

How To Get Task Id,feature Id,complete Hrs By Accessing Tfs Warehouse By Date In Vs 2017?

Post a Comment
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?
Sql/mysql: Split A Quantity Value Into Multiple Rows By Date

Sql/mysql: Split A Quantity Value Into Multiple Rows By Date

Post a Comment
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
Filter Length Of Time

Filter Length Of Time

Post a Comment
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
Merge - Update Column Values Separately, Based On Logic In When Matched Block

Merge - Update Column Values Separately, Based On Logic In When Matched Block

Post a Comment
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
Merge - Conditional "when Matched Then Update"

Merge - Conditional "when Matched Then Update"

Post a Comment
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"