Sounds like parameter sniffing and in this case it might be what Grant Fritchey calls bad parameter sniffing.

In the plan with the parameters right-click on the Update operator and select...

What is the language on the SQL Server?

What is the locale on the report server and on your computer?

I've never seen this, but it does sound like the query isn't...

SpiderDK,

Your issue really should be a separate thread as it doesn't really have to do with Trace Templates. Having said that, you need to find a way to "normalize"...

Grant Fritchey (4/26/2013)

---

jasona.work (4/26/2013)

---

I just going to hope we don't get mocked on Saturday for wearing our Red Wings jerseys...

As for smuggling back Canucks, do we want the hockey players...

That was certainly an interesting read. Not sure where the "chill pill" comment...

This is a common problem when numeric data is stored as character and durai has posted one solution. Often in these types of applications the application will prepend 0's...

Jeff Moden (4/24/2013)

---

Agreed but that's a terrible function. It stops scanning at the first non-alpha character to...

Those both point to the...

You could also be thinking about the SOUNDEX function.

If I remember correctly, cost is the amount of time it took for an operation to run on the specific computer when optimizer costing code was created. It doesn't...

Are you sure it is a horizontal tab ("\t")? Sounds like it might be another white space character. I'd through in a...

apat (4/24/2013)

---

Cluster is made of Dell R815 server. With Intel x570 10GB NICs connected to Cisco Nexus 5596 Switch through a coper twinex cables. That is connected to EMC VNX...

Okay. I don't even remember the last time I was on here. I'm not even going to try to catch up. Just based on the mentions of...

I'd start with something like this which is the most common way to get a previous value:

WITH ctePFE

...

The recommended method for returning a single value from a stored procedure is to use an output parameter. Which I'm sure is what the link provided in the previous...