Comments by Gupta Poonam

Gupta Poonam 9-Sep-14 2:11am View

Can you please clearly define your second table...Rows in second table are inconsistent. You can use Improve Question widget to edit your question.

Gupta Poonam 5-Sep-14 9:44am View

Solution will give a wrong result if substring of other name is same as the name you are looking for eg: if 'Jordan' name exist in table instead of dan it will still give you the output

Gupta Poonam 3-Sep-14 6:41am View

Thanks George..
Yup you are right there might be a case where first row is much larger than 1.
Will improve my answer.

Gupta Poonam 21-Aug-14 9:07am View

you can use backup/restore option.
You can take a backup of your server database and restore it on local.

Gupta Poonam 21-Aug-14 8:00am View

Thanks.. I was trying to explain/express the same. But I'm not a good writer

Gupta Poonam 21-Aug-14 7:50am View

Have improved my answer. Hope it will help you out

Gupta Poonam 21-Aug-14 5:33am View

Are you getting any error?
Please specify the error.

Gupta Poonam 20-Aug-14 8:50am View

sorry i don't know much about it. I mean what do you mean by execution plan?

Gupta Poonam 20-Aug-14 5:52am View

Thanks for Quick reply...
Will learn more about indexing and try to implement it. Hope it will help me out.

Gupta Poonam 20-Aug-14 5:16am View

int index= ddlgender.SelectedIndex // To get SelectedIndex
int value=(Convert.ToInt32(ddlgender.SelectedValue)) // To get SelectedValue

Gupta Poonam 20-Aug-14 3:13am View

Have you set the DataTextField and DataValueField property of your dropdownlist?

Gupta Poonam 13-Aug-14 5:46am View

i have tried it on sample tables... you can check the below code its working.

create proc [dbo].[CommentsInsertTest]
(
@CommentID INT,
@ParaID INT,
@Comment VARCHAR(MAX),
@CreatedOn DATETIME,
@EditedOn DATETIME,
@CreatedBy INT,
@EditedBy INT,
@IsActive BIT
)
as

begin

if not exists(select CommentID from Comments where CommentID=@CommentID)
BEGIN
insert into Comments(ParaID,Comment,CreatedOn,EditedOn,CreatedBy,EditedBy,IsActive) values (@ParaID,@Comment,@CreatedOn,@EditedOn,@CreatedBy,@EditedBy,@IsActive)
insert into AdditionalComment(Comment,CreatedBy,ModifiedBy) values (@Comment,@CreatedBy,@EditedBy)
END
else
BEGIN
update Comments set Comment=@Comment,EditedOn=@EditedOn,EditedBy=@EditedBy where CommentID=@CommentID
update AdditionalComment set Comment=@Comment,ModifiedBy=@EditedBy where AddCommentID=@CommentID
END
end

Comments by Gupta Poonam (Top 12 by date)