For example?

Does your passport identify you completely?

And what else do you need to identify a person?

First Name, Second Name, Last Name, Date of Birth.

What else do you have in your passport?

Can you name any entity with more than 10 different profiles to describe it?

Seems, i explained the reason clearly:

"a table with a load of columns"

It's against any of relational database rules and all of them together.

So it's failure. And there is no point...

Not only you've been drinking today.

> the second one cannot be avoided because of the another 1:N relationship between #tblAccount and #tblB.

?????

In the query we have:

 ac.ID = a.ID = b.ID

"group by ac.id" actuall means...

You mean SQL2000 or your application running against SQL2000?

SQL2000 does not have such feachure.

And if you need it for your application you need to develop it.

Unless somebody will give...

> Hope this helps.  (at least helps more than telling you that "you already failed")

Probably helps. For today.

And leads to a deeper trouble tomorrow.

"The road to hell is paved with...

There is a condition:

where tbc.userblogID in(select UserBlogID from tbl_userBlog  where UserID = 1 and active =1 and publicflag = 1)

This allows only to return BlogNames with existing comments.

So...

select tub.userblogID , tub.blogname, count(tbc.UserBlogID) as commentcount

From tbl_BlogComments tbc

INNER JOIN tbl_userBlog tub  ON tub.userblogID = tbc.UserBlogID

where tbc.userblogID in(select UserBlogID from tbl_userBlog  where UserID = 1 and active =1...

> a table with a load of columns

Stop right here.

You don't need to go anywhere further.

You have already failed.

If this is a botleneck in your SP performance you are lucky!

You must have fastest SPs in the world!

Look in the execution plan of your SP. You must have find...

It's really incompartible things.

It's like to ask "what is your con and pro for using CAR and BOAT?"

As you can see UDF just does not work where VIEW should be...

You know, people invented data normalization not only to deliver some exercises to their bored brains.

Sometimes it's really useful.