Thanks Grant.

If you are in New York City, it's....

update tasks
set opendate = DATEADD(HH,-4,[opendate])

Thanks guys and it's always nice to see Phil 🙂

"Exactly how do you invoke the HARMONY web service ? If you use C# today to do so, you can do the same in a Script Task within SSIS."

That makes sense 🙂

Thank you

This solution would work, but its not realistic for my case. Most reporting environments just call the proc. This blog is talking about linked servers and Open query which is...

I spoke to soon. That link looks like it might work.
Thanks Jason.

Hi Chris,

Tableau doesn't support SQL Procs either :(.

I see this more and more with new technologies. They release a product that is incomplete and say...

Sorry man, I am doing 4 things a once here. Thank you for cleaning that up.

Here is the data.

CREATE TABLE #test
(UID varchar(50),
DateTimeStamp timestamp
);

INSERT INTO #test 'DJeter@yanks.com', '2017-02-06 13:08:49.417'
INSERT INTO #test 'DJeter@yanks.com', '2017-02-06 13:08:49.417'

Ok, so just in case anyone has the same issue, I came up with a query that shows the number of clicks per minute. 

What my associate was asking...

I am not sure how I can replicate data that might not even exist. That is the challenge with this. I am trying to find users that meet this criteria,...

I don't understand Phil. I posted the query that I have been working on. I am not sure what else I can say. I was able to get the query...

Sorry guys, didn't paste the query. The table simply has 2 columns... UID and timestamp (apologies for the crude diagram).

This is the general idea. I am hard...

Thank you very much!!!!!!!!!!!!!!!

I will try this.