Actually for the query the performance shouldn't be too bad for that kind of thing. Coding it can kind of PITA though. 😉

Glad that worked for you and thanks for...

That stinks!!! Hopefully you will find another opportunity soon.

Jan Van der Eecken (9/20/2013)

---

I don't think I'm the lone non-US citizen who doesn't quite understand what the Filibuster is all about. The way I understand...

You're welcome. Glad it makes sense now. At least you will be able to sleep this weekend. 😀

Sounds feasible for sure. Let me know if that works for you.

RedBirdOBX (9/20/2013)

---

I'm mostly a VB.NET guy so those same rules don't apply. I am slowly teaching myself C# though so I'm sure I would have come across that in...

Maybe you can simply write the parameters to the cache at the beginning and then update that row with the result at the end of processing?

Just as I said previously. You have multiple lines inside your conditions. If you do that you MUST include begin/end.

Think about C#/Java or whatever with if conditions.

if(SomeCondition)

...

workin

Like this?

order by name

cgreathouse (9/20/2013)

---

I have a stored procedure that takes a while to run that returns a single result. What I was finding was that this stored procedure was getting called...

RedBirdOBX (9/20/2013)

---

OK. I've referenced a couple books and searched this forum. Syntactically speaking, I see nothing wrong here. SSMS is refusing to accept this. Says have...

Excellent job posting ddl and sample data. I am however totally lost on your requirements. Can you try to explain it more clearly?

vina117831 (9/20/2013)

---

Import Canon XF300 MXF to FCPX. Mountain Lion 10.8.2. Many threads seem to point to needing a converter for these files before FCP X will read them. If...

You're welcome. Glad that worked for you.