Hi

The status must be updated to "Close" only if the mail has been sent successfully right ?

If this is not the case then you can put both the select and...

Hi

I agree with micheal there. Connecting every 1 sec is not a very good idea.

What is the purpose of getting data so promptly ? I

Hi

I think Pivot will help in your case. Pivot has its own performace implications and is generally found to be slower than conventional way of doing the same...

Hi

What I like about this site - Everything

Hi

I searched for my posts, went inside one of them and right clicked on my profile and selected Find all members posts.

This is really a cumbersome way to do things....

Hi

Lowell

Thanks for explaining the thing to me..

Noel

I know its a good practice to prefix table names to columns.

I was just curious thats all. Thanks for your...

Hi

Hope i have understood your issue correctly....

In order to not re-query the db u will have to fetch all the details from the db first time itself. How good...

hi

do you have a separate address table or are the address details stored in the customer table ?

Hi

Sorry.... the sign off line does show... did not see it in preview

Chirag

Hi

Overall i think its good enough.  Few things i noticed.

It looks a bit too bright for me what with this blue color  ....;)

also it has a cluttered feel to it...

BTW i...

Hi

Has your log file has grown to a large size.

hi

if the tables have same columns then you should be able to write a single update query.

update TableB set TableB.Text2 = TableA.Text2 FROM TableA where TableA.BookID =...

Hi

calculate the difference between 2 payments (no:of days)

take the sum of above mentioned days

calculate average

am not including any SQL statements here, since i dont know ur tables...

How many records are there in the table?

How many records are there in the table?