patelchandresh330 80387 (8/22/2014)

---

Sometime following stored procedure suddenly taking 10 seconds when we called through application.

CREATE PROCEDURE TestStatus

AS

BEGIN

...

Make sure you understand what that code is doing before you implement it. 🙂

Would be a lot easier if you could post ddl and sample data next time. Saves us a lot of time putting this all together. I am still not 100%...

ByronOne (8/21/2014)

---

Hi everyone

I really hope someone can help me with this...

I have a table in SQL called dbo.Sales which looks something like this

ID DATE REGION ...

Weird...I can now see...

You might also look into adding SCHEMABINDING to your itvf.

Thanks Steve. With all the issues lately I feel like "one of those" people always complaining. Hopefully it isn't seen that way.

Isn't that just the weirdest thing??? :w00t:

If you hit ctrl+f5 you will no longer see anybody's including your own....

Ahh now I...

What is prefix and postfix? That should be a single table. And the name of the movie should not be in more than 1 table. That is the point of...

Glad that worked for you and thanks for letting us know.

+1000 to Luis for his ability...

Agreed 10000% with Matt about normalization. You should have a Movies table and that is the ONLY table where you will find the name. Then you would have a table...

Koen Verbeeck (8/21/2014)

---

Sean Lange (8/21/2014)

---

Both of your avatars are now displaying again. There seems to be a lot of serious bugs with SSC lately. In addition to those there seems...

Both of your avatars are now displaying again. There seems to be a lot of serious bugs with SSC lately. In addition to those there seems to be a number...