stephen99999 (1/12/2012)

---

Mark-101232 (1/12/2012)

---

bicky1980 (1/12/2012)

---

stephen99999 (1/12/2012)

---

in table format, bicky, please post what you are expecting your results to look like. Earlier you stated you wanted to see 9, 6, etc to...

stephen99999 (1/12/2012)

---

in table format, bicky, please post what you are expecting your results to look like. Earlier you stated you wanted to see 9, 6, etc to be returned, and...

stephen99999 (1/11/2012)

---

@bicky

It has to be one of these two options lol. For each option, I started out with a quote on your desired results should be, as well as...

Hello All

I think I have managed to run the counts individually

select count(*) from test

select count(distinct datakey) as Unique_Dataset

from (select *, row_number() over(partition by datakey order by case when Datakey!='' then...

No, its not performing the counts I need to get back (thanks for the effort though)

Total = 9

Total Unqiue Datakey = 6

Total Unique Landline = 6

Total Unique Mobile =5

Total Unique...

The query certainly groups the results by the datakey

but all the values are the same...

stephen99999 (1/11/2012)

---

bicky1980 (1/11/2012)

---

stephen99999 (1/11/2012)

---

Try this bick, and please reply with the results... I am not on a machine with management studio, so can't test.

SELECT datakey,COUNT(datakey) OVER(Partition by datakey) AS Uniquedatakey,

...

stephen99999 (1/11/2012)

---

Try this bick, and please reply with the results... I am not on a machine with management studio, so can't test.

SELECT datakey,COUNT(datakey) OVER(Partition by datakey) AS Uniquedatakey,

...

stephen99999 (1/11/2012)

---

Have not tested this, but :

SELECT COUNT(DISTINCT datakey) OVER(Partition by datakey) AS Uniquedatakey,

COUNT(DISTINCT CASE WHEN landline<>'' THEN landline END) OVER(Partition by datakey)...

Cadavre (1/11/2012)

---

I can't quite match your requested results, can you double check them?

I make it: -

Total ...

Mark-101232 (1/11/2012)

---

worker bee (1/11/2012)

---

I know your not inserting columns, :), After you insert you data into the table you are wanting to count the datakey column, if so then your...

I feel you...

worker bee (1/11/2012)

---

I know your not inserting columns, :), After you insert you data into the table you are wanting to count the datakey column, if so then your select...

I am not inserting columns (just did that...

Hi

I personally put the code into job

E.g.

DECLARE @totalrecords int,

@lcmessage nvarchar(max)

select @totalrecords=count(*) from [tablename]

set @lcmessage=

'This is a Test

Your query has completed and there are '+CAST(@totalemails AS NVARCHAR)+' new records'

EXECUTE Msdb..sp_send_dbmail...