Yes, there are products that...

😀

hmm, I saw some books or article says the execution plan is inaccurate , if like this how we can compare which sql statement is better ?

I used actual...

This will actually pull the  individual values by row so you can use them if you need to.

See Scott's code (below) if you just want to get rid of most...

BWAAAAA-HAAAAA-HAAAA!!!  Heh... you struck a funny bone because I've found that to be true...

so if I understand you correctly, if I give them the permission to execute the procedure I am not giving them any god given rights so they can execute...

Hi all,

Thank you everyone for your input, it works perfectly.

Your speed and responses have been fantastic.

I also have a question on Splitting values, but i will post that in...

8<

>8

Also, just to be sure, the OP stated that they weren't the ones that are responsible for the poor datatyping that you're correctly talking about.  A 3rd party...

Thank you for the very kind words, Michael.  Glad to help.

• This reply was modified 5 years, 6 months ago by Jeff Moden.

Congratulations, Michael!  Well deserved.  You really did put your shoulder to the wheel from what I've seen of your posts on this forum.

Would WITH EXECUTE AS OWNER make any difference  ???

or

Can I just add this stored procedure to the list of securables their  role can execute ?

Would not then  this procedure...

DATE and TIME are available data types that can be combined into the newer DATETIME2(n) data type. Just use the CAST() function and simple math. The use of an...

Hi Jeff,

Here is the result of your code:

Date                                           ...

Heh... "The OP has left the building". 😀

Hello,

So we have noticed our trigger that does insert from one table to another if there is an update or insert, so we noticed the timestamp GETDATE() has been...