CREATE PROCEDURE [dbo].[select_IM_NewMessageRecipients_count_OUTPUT] 
	(
	@userID int,
	@minutes int,
	@newRecipients_OUTPUT [tinyint] OUTPUT 
	)
AS SET NOCOUNT ON

SELECT count(DISTINCT messageTo) as newRecipients FROM tblMessage WHERE messageFrom = @userID and date >= DATEADD (mi , @minutes, getDate()) 

AND messageTo NOT IN (SELECT messageFrom FROM tblMessage WHERE messageTo = @userID)

 
SELECT @newRecipients_OUTPUT = ???


GO

quote:

---

Originally posted by mike123


Hi,

I'm writing a query, and I'm thinking its going to be alot better to use an OUTPUT parameter instead returning a whole dataset. I'm not sure if its possible with this specific query, or how to do it. Can anyone lend me a hand on this one?

I think this query is pretty self explanatory but I'll let it be known that I only need one value brougth back, and that is

"count(DISTINCT messageTo) as newRecipients"


Thanks very much!
mike123

CREATE PROCEDURE [dbo].[select_IM_NewMessageRecipients_count_OUTPUT] 
	(
	@userID int,
	@minutes int,
	@newRecipients_OUTPUT [tinyint] OUTPUT 
	)
AS SET NOCOUNT ON

SELECT @newRecipients_OUTPUT = count(DISTINCT messageTo) FROM tblMessage WHERE messageFrom = @userID and date >= DATEADD (mi , @minutes, getDate()) 
AND messageTo NOT IN (SELECT messageFrom FROM tblMessage WHERE messageTo = @userID)
GO

---

quote:

---

Originally posted by khtan



Slow internet connection ?

---

KH
[spoiler]Time is always against us[/spoiler]

---