Here's one example of configuring SSRS to use gmail.

http://db-pub.com/forum-80534388/data-base-mail-configuration-using-gmail-giving-error.html

Good luck! Sorry I couldn't be of more help.

Pieter

Can you not change the spelling in your list? Otherwise, you would have to use a function to remove the spaces in your store names, and then match on...

Makes sense...

select 'WholeFoods' as Keyword

will never match 'Whole Foods'. If you fix that, your problem is solved.

You could use a UNION query and then just use NULL for the missing columns in the dataset with fewer columns. The sorting might be an issue. Hard...

You could use a UNION query and then just use NULL for the missing columns in the dataset with fewer columns. The sorting might be an issue. Hard...

Mario,

Just wondering, but why do you have Earnings and Amount in the same column? If you separated them so that they were in separate columns, it would make dealing...

If you have 2012, then here's an example of a running total using window functions (from Itzik Ben-Gan's book on Window functions in 2012):

SELECT empID, qty,

SUM(qty) OVER (PARTITION BY empID

...

Maybe my brain is not working, but if you can return a set of punch in/outs for an employee, shouldn't you be able to use ROWNUMBER() to get odd (clock...

So this was a simplified example?

If you're having trouble implementing a more complex solution, post the table info and the expected result.

Umm... Okay! I hope you're being facetious!

This is close:

WITH cteList(col1, col2, freq) AS

(SELECT col1, col2, count(*) OVER (PARTITION BY col1, col2) AS Freq

FROM (

SELECT 'John' AS col1,1 as col2,1 as col3

UNION ALL

SELECT 'John',1,1

UNION ALL

SELECT 'John',2,2

UNION ALL

SELECT...

This is the article I was thought might help:

http://www.sqlservercentral.com/scripts/Miscellaneous/31733/

What you're describing is called a data-driven subscription. What version of SQL Server are you using? Enterprise supports them natively. If not, I am pretty sure that Jason...

Why not just use a junction table? Normally, the junction table holds the foreign keys from the two parent tables and then any information that is specific to the...