Viewing 6 posts - 1 through 6 (of 6 total)
Florian Reischl (4/13/2009)
sreddy (4/13/2009)
--------------------------------------------------------------------------------
select
user.userid,
user.name,
count(news.userid)
from user
inner join news on user.userid = news.userid
group by user.userid,
user.name
Why count(userid)?
j1a4l0: What do you want returned for a user that has no news items?...
April 13, 2009 at 3:33 pm
sreddy (4/13/2009)
--------------------------------------------------------------------------------
select
user.userid,
user.name,
count(news.userid)
from user
inner join news on user.userid = news.userid
group by user.userid,
user.name
Why count(userid)?
j1a4l0: What do you want returned for a user that has no news items?
--------------------------------------------------------------------------------
Gail Shaw
thats a...
April 13, 2009 at 1:03 pm
Hey,
Here's the Soln....
select
user.userid,
user.name,
count(news.userid)
from user
inner join news on user.userid = news.userid
group by user.userid,
user.name
April 13, 2009 at 12:33 pm
Hey,
find the following soln...
SELECT [ID]
,[Title]
,[fname]
,[lastname]
,[Company] ...
April 13, 2009 at 12:21 pm
so one of your problem is solved now thats kewl..........
and there is no need to comment the two lines just comment the select @@rowcount statement and you can still use...
April 10, 2009 at 9:25 am
Hi,
After Quick review I have found the following issue with the code.
--********** Delete Duplicates
--begin tran
SET ROWCOUNT 1
SELECT @@rowcount
the above statement was returning your first result set just...
April 9, 2009 at 3:46 pm
Viewing 6 posts - 1 through 6 (of 6 total)