James - Thank you! This is very helpful.

Norbert

meLearnASP.net

James - thank you for the reply.

1. I tried truncating all the supporting tables, but for some reason, i am still getting the same error for the main table that...

Jason,

Perfect. This is exactly what I was looking for.

Thank you for the great solution.

Norbert

meLearnASP.net

Jason - thanks for the answer.

Actually this what I had in mind.

If there is a user_pic_default = 'y' for the post_id then in the result, return the value for

Sorry for not being clear.

I would like all results to return for Comment.post_id = @postid regardless if user_pic.user_pic_default = 'y'

So if there is a row that matches the post_id...

It works for me.

I am using SQL 2005 express, but I am not sure if that makes a difference.

Norbert

meLearnASP.net

NMT - This is amazing!

This is exactly what I was looking for.

Thank you very much for your time and help.

Norbert

meLearnASP.net

Thank you both for the answer.

How do I determine the time that has passed and display a response accordingly?

For example:

if less than 1 hour show minutes

if less than 24 hours...

James,

Your solution worked perfectly!

Thank you very much for your help on this.

Norbert

meLearnASP

I figured it out.

I entered localhost\SQLEXPRESS for the server name. I was than able to create the connection.

Greg and William thanks for...

- For some reason I am unable to create a System DSN.

The SQL Server Express Database is stored on my C drive.

I am trying to create a connection using SQL...

Thank you. This is very helpful.

Norbert

meLearnASP.net

JDixon.

Thanks for your help! Both of your answers were very helpful.

Sincerely,

Norbert

meLearnASP.net

Is there a way to hardcode the file location into the script that can be used in a stored procedure?

Thanks.