@adi, you're the man. I was starving to death for this solution and now I am well fed.

Thank you sir!

I needed this query...

Thank you @HowardW for the information. Greatly appreciate it.

Thank you very much for your quick response!

Hmm. So, the only option I have is to get rid of the function since I was using LOWER(FRUIT) = 'apple'. ...

Thank you for the very detailed response. It worked perfectly. The trick was "type::", that is what I didn't know about... 🙂

I tried first but gave me conversion error. But now, it works without converting to string. Thank you Anthony one more time. You saved my day! 🙂

SELECT...

Thank you Anthony! Your solution worked perfectly. I had to create the ISO date string and then use between operator to make work perfectly. For some reason...

Thank you Cadavre for your quick response. But this returns zero rows. Also, I cannot hardcode values and it should be dynamic based on the user selected criteria.

i apologize. I edited my post.

What it turns out to be is you have to use separate triggers then only it won't trigger for After Delete but it...

Okay, thank you for your responses.

I found this article after I posted my question here.

Take a look at this article and i was dead right... But...

If it is Mixed Mode and u r the Admin to that box and you logged in as administrator, then you do not need any other password to log in...

That is exactly what i was looking for. Thank you very much Lutz. I know it can be done because I have seen somebody doing at somewhere like...

Do you have Mixed Security Mode enabled or just SQL Security Mode?

If you have mixed mode and you're the Administrator (windows) for that server then you don't need...

Thank you for your quick response. That should do it.:-)

perfect Stefan_G. It worked just great!

Thank you very much and have a great day!

Oh boy! if i use cursor i have to fetch each row into variables. That sucks! can i fetch that row into a table? any syntax???