Comments by jamuro77 - CodeProject

jamuro77 14-Dec-16 2:41am View

I don't understand well your results. What is obtained date in tour first point? The minimum date? And with regard to second point, is "date difference" set with origin in "initial date"?

jamuro77 9-Dec-16 3:21am View

I know it. For this reason, you have several solutions:

1) Use your first query to load a new variable table and then apply UNPIVOTING as described above.
2) Use a Common table expression to encapsulate your first query and then apply UNPIVOTING over it.
You will get the desired results.

jamuro77 9-Dec-16 1:46am View

It would be necessary to know more about, at least two issues:
1) Which is the correct result set you are looking for?
2) Further information about data in tables

jamuro77 1-Dec-16 6:13am View

You can't group two times by the same fields. There's no sense. You can obtain "count" or "sum" separately but not together. I think that you need a field not grouping by EmployeeID and UserID. Expected results would be necessary to elaborate a solution...

jamuro77 30-Nov-16 3:11am View

Could you add the tables structure related to your query? If not, It's diffcult to know...

jamuro77 27-Nov-16 4:24am View

Happy the code has been useful for you!
If you want to know a little more about this you can have a look and rate an article that I wrote some days ago, "Using PIVOT with SQL Server"

jamuro77 26-Nov-16 16:14pm View

Indexes can be "unique" or "not unique". If you want to have unique values in one field (or field combinations), you have to create a "unique" index on those fields. In addition to this, you can also create "unique" restrictions on columns.

Comments by jamuro77 (Top 7 by date)