I tried that actually earlier but its given me some random numbers..

like

1.look

16.Boy

39.Cool

Is this because i'm GROUPING?

Thanks in Advance

Yeah went through some tutorials.

Will post back if need some help

Thx

Thanks.

But the thing is i have 6 insert statements FOR example below

So can i do :-

if  @ProductName,@ProductName1 is not null

  insert Products(ProductName,UnitPrice)

  VALUES (@ProductName, @UnitPrice)

 insert Products(ProductName,UnitPrice)

  VALUES (@ProductName1, @UnitPrice)

 insert Products(ProductName,UnitPrice)

 ...

Thx Jo Pattyn for the reply.

Thats exactly my problem.

The resultset that return is good.

But the problem is if i databind it appears twice that means...

Thanks Vladan for the reply and everybody else who has been replying me.

And after testing your Stored Proc it did the job.

I have...

Thanks Kenneth  and David for the reply here is my DDL for the two tables

CREATE TABLE [newpostSR] (

 [postid] [int] IDENTITY (1, 1) NOT NULL ,

 [name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL...

Thx guys.

Will get back to you.

Patrick

Thx guys for the replies..

GilaMonster its very well possible that i have similar reply dates and actually didn't notice that.But i the postid' are ok now after using max(replyid) and...

Farrell thanks for the reply.Yes when there is more that one reply its a problem because after databinding it to a datagrid and i load the newpost page the some...

Thx very much for the reply and the S_p u posted did the trick

Bu i have one more problem since i'm using a datagrid for it after binding it to...

Thx very much for the reply and the S_p u posted did the trick

Bu i have one more problem since i'm using a datagrid for it after binding it to...

GilaMonster thhx for the post and yes i want to retrieve the LAST REPLY of each post in a datagrid

but when i tried your query in Query analyzer i got...

Thx all for the replies but i pasted the wrong Storepd procedure  below is the  correct one and the problem 'm facing 

I get the error when i INSERT a record the...

Thats true.

there is also an issue where in an asp application some DBA's write long chunky S_procedure and the asp applcation in the client does nothing.

So when u request the...