How do I account for accidental swipes in a card swipe table? I tried selecting the max(time_cst) by grouping them on entry. It did not solve the problem. http://www.sqlfiddle.com/#!18/06cc8/2 EmpID …
Tag: ssrs-2012
To UNION or Not to UNION
I am currently running into an issue with my UNION clause. I am trying to figure out how many orders I am import via each day. The problem is, I have two tables that these orders are stored in OLDORDERHEADER and ORDERHEADER. After an order is completed, it moves from the ORDERHEADER table into the OLD. Both have the same
what is the difference between Coalesce and nullif
I am currently working on an SSRS report that will need to display a Dr’s ID based on either their DEA number or NPI number. I need to be able to do a coalesce on DEA and NPI to find the non-unknown one, which I will then add code to the SSRS report that will display a hover over stating
How to create heat map on a table in SSRS?
How can I create like this in SSRS? The color will change from red to green based on a value in a row (Underwriter). And all that in a group: Answer You can do this by right clicking on the individual cells and setting the fill colour based on an expression: In the Image below I’ve mistakingly put “==” where
SQL Server Reporting Studio report showing “ERROR#” or invalid data type error
I struggled with this issue for too long before finally tracking down how to avoid/fix it. It seems like something that should be on StackOverflow for the benefit of others. I had an SSRS report where the query worked fine and displayed the string results I expected. However, when I tried to add that field to the report, it kept