Thank you. This is really helpful.

Thank all of you for help

I use J Livingston SQL's code, it works great!

I need pass exact string format from getdate() to third party application in which I can not do anything.

The third party applicaton only take format like below(including space):

'11/07/2011 09:30:00 AM'...

I need to pass getdate() to get current date and time string and then pass it to another function.

It works great.

Thanks

Thank you for help.

I think that both ways will work.

Yes, there is a primary key on ID column.

I want to keep min(ID)

Sorry, my question is:

Should I nedd to create a special account in SQL server in order for ASP.NET to connect database?

Yes, it works great.

Thank all of you.

Someone creaete a table in which "1900-01-01 00:00:00.000" are in one column (only 30% have real date).

How to code to convert them into null in my new table?

Sorry, I do not see second step. I'll try it.

Thank you

No, either way is for "Or" only.

What I need is for "And". The color must be "RED" and "GREEN"

Thank you, Lowell.

It works great!

Thank you for help. I ran bitbucket-25253's code. It works like magic.

This is my fault. I do not write clear.

There are three fields: Excellent, Good, Fair in which stored a value as below.

Excellent---Good---Fair

0---------- 1-------0

1---------- 0-------0

0---------- 0-------1

I need a case statement form...